DP-300 Full MCQ Set

You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload?

• Total size of all the databases

• Geo-replication support

• Number of concurrently peaking databases * peak CPU utilization per database

• Maximum number of concurrent sessions for all the databases

• Total number of databases * average CPU utilization per database

Which type of compression provides the greatest space reduction for a fact table with billions of rows in Azure SQL Database?

• Page compression

• Row compression

• Columnstore compression

• Columnstore archival compression

You plan to migrate DB1 from SQL Server 2019 to an Azure SQL database. What feature should be removed or replaced before migration?

• Clustered columnstore indexes

• PolyBase

• Change tracking

• Automatic tuning

You have a 4-TB database named DB1 in an on-premises SQL Server 2019 instance. You plan to migrate DB1 to an Azure SQL Database managed instance. What should you use to minimize downtime and data loss during the migration?

• Distributed availability groups

• Database mirroring

• Always On Availability Group

• Azure Database Migration Service

You have an on-premises SQL Server 2016 database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance using Azure Database Migration Service. How should you configure the backup of DB1?

• Use full database backup

• Use differential backup only

• Use log backup only

• Use transaction log backup with no recovery

Which type of compression provides the greatest space reduction for a large, batch-loaded table in Azure SQL Database?

• Page compression

• Row compression

• Columnstore compression

• Columnstore archival compression

Which distribution type should you use for a date dimension table in Azure Synapse Analytics dedicated SQL pool to minimize data movement?

• HASH

• REPLICATE

• ROUND_ROBIN

In Azure Synapse Analytics, which file format should you use for tables in a Spark pool so they are automatically available as external tables to the built-in serverless SQL pool?

• JSON

• CSV

• Parquet

• ORC

You are designing a streaming data solution in Azure. Which service allows you to change the partition count after creation?

• Azure Event Hubs Standard

• Azure Stream Analytics

• Azure Data Factory

• Azure Event Hubs Dedicated

What is the best solution for anomaly detection on streaming data from an Azure IoT hub that must send results to Azure Synapse and minimize development effort?

• Azure SQL Database

• Azure Databricks

• Azure Stream Analytics