02 DP-300 Plan and implement data platform resources

1. What type of storage offers the lowest latency in Azure?

• Ultra SSD
• Premium SSD
• Standard SSD

2. To reduce the cost of an Azure SQL Server VM you intend to run full time for three years, which option should you choose?

• Availability set
• Azure Reserved VM Instances
• Pay as You Go Licensing

3. Which option should you choose to spread workloads across data centers in a region?

• Availability sets
• Availability zones
• Availability units

4. Which service performs block level replication of your Azure virtual machine?

• Azure Site Recovery
• Azure Backup for SQL Server
• Availability Groups

5. You need to migrate a set of databases that use distributed transactions from on-premises SQL Server. Which of the following options should you choose?

• Azure SQL Database
• Azure SQL Database Hyperscale
• Azure SQL Managed Instance

6. You're building a new cloud database that you expect to grow to 50 TB. Which is the best option for your database?

• Azure SQL Managed Instance
• Azure SQL Database Serverless
• Azure SQL Database Hyperscale

7. You're building a database for testing purposes that will be used less than 8 hours a day. It's expected to be 20 GB in size. What is your most cost-effective option?

• Azure SQL Database Serverless
• Azure SQL Database Elastic Pools
• Azure SQL Managed Instance

8. How often do differential backups occur with Azure SQL managed instance?

• Every 1 hour
• Every 12 hours
• Every 24 hours

9. Which tool would you use to assess and migrate your databases from an on-premises SQL Server to an Azure Virtual Machine?

• Microsoft Assessment and Planning Toolkit
• Database Experimentation Assistant
• Data Migration Assistant

10. What does Microsoft guarantee if you upgrade versions of SQL Server but maintain the same compatibility level, on similar hardware?

• Syntax compatibility
• Execution Plan Shape
• Elapsed time of queries