DP-300 Practice Test practice questions, page 8 of 15, with answer review and explanations.
Question 36
You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL. Which service should you use?
Azure SQL Database
SQL Server on an Azure Virtual Machine
Azure SQL Managed Instance
Azure Database for MySQL
Question 37
You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime. What should you do?
Configure Transaction Log Shipping.
Implement Always On availability groups.
Configure transactional replication.
Import a BACPAC.
Question 38
You have an Azure SQL database named DB1. You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled. During a database audit, you discover that none of the fields contain more than 150 characters. You need to ensure that you can apply page compression to Table1. What should you do?
Configure the columns as sparse.
Change the column type to NVARCHAR(MAX).
Change the column type to VARCHAR(MAX).
Change the column type to VARCHAR(200).
Question 39
You have an on-premises Microsoft SQL Server named SQL1 that hosts five databases. You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss. What should you use?
Always On availability groups
Backup and Restore
log shipping
Database Migration Assistant
Question 40
You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet that uses partitioned columnstores. You need to configure table1 to meet the following requirements: • Each partition must be compressed. • The compression ratio must be maximized. • You must be able to index the compressed data. What should you use?