In relation to Azure SQL Database, which of the following is true?

Question

1. Additional database filegroups can be added via Transact-SQL statements
2. The maximum size of a database is determined by its database Edition
3. Additional database files can be added via Transact-SQL statements
4. All databases on a server must be the same database Edition

Answer 1

The correct answer is 1 -  Additional database filegroups can be added via Transact-SQL statements.

ALTER DATABASE database_name
{
<add_or_modify_files>
| <add_or_modify_filegroups>
}
[;
<add_or_modify_files>::=
{
ADD FILE <filespec> [ ,...n ]
[ TO FILEGROUP { filegroup_name } ]
| ADD LOG FILE <filespec> [ ,...n ]
| REMOVE FILE logical_file_name
| MODIFY FILE <filespec>
}
<filespec>::=
(
NAME = logical_file_name
[ , NEWNAME = new_logical_name ]
[ , FILENAME = {'os_file_name' | 'filestream_path' | 'memory_optimized_data_path' } ]
[ , SIZE = size [ KB | MB | GB | TB ] ]
[ , MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ]
[ , FILEGROWTH = growth_increment [ KB | MB | GB | TB| % ] ]
[ , OFFLINE ]
)
<add_or_modify_filegroups>::=
{
| ADD FILEGROUP filegroup_name
[ CONTAINS FILESTREAM | CONTAINS MEMORY_OPTIMIZED_DATA ]
| REMOVE FILEGROUP filegroup_name
| MODIFY FILEGROUP filegroup_name
{ <filegroup_updatability_option>
| DEFAULT
| NAME = new_filegroup_name
| { AUTOGROW_SINGLE_FILE | AUTOGROW_ALL_FILES }
}
}
<filegroup_updatability_option>::=
{
{ READONLY | READWRITE }
| { READ_ONLY | READ_WRITE }
}

To learn more about Azure, check this azure training out!

Answer 2

1. All databases on a server must be the same database Edition

Answer 3

The correct answer is “The maximum size of a database is determined by its database Edition.”

1. Additional database filegroups can be added via Transact-SQL statements: it is not true because additional filegroups are not supported by Azure SQL database.

2. The maximum size of a database is determined by its database Edition: True because maximum database sizes vary based on different editions.

3. Additional database files can be added via Transact-SQL statements: Extra database files cannot be added in Azure SQL Database 

4. All databases on a server must be the same database Edition: Not true because databases in an Azure SQL Database server can be of different editions.