02 Chapter 02 DP-300T00A-Trainer-Files-Administering-Relational

What type of storage offers the lowest latency in Azure?

• Ultra Disk
• Premium Disk
• Standard SSD

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

• Availability sets
• Availability zones
• Availability units

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

• Azure Reserved VM Instances
• Availability Set
• Pay as Your Go Licensing

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 Managed Instance
• Azure SQL Database
• Azure SQL Database Hyperscale

You are 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
• Azure SQL Database Hyperscale

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

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

Which version of SQL Server does compatibility level 100 equate to?

• SQL Server 2008
• SQL Server 2014
• SQL Server 2019

What is a valid reason for migrating your database to Azure SQL Database?

• Your applications need to run older versions of SQL Server, such as SQL Server 2016
• You want to eliminate the complexity of configuring and managing high availability, backups, and other database tasks
• You want to improve query performance of your application

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

Which tool is recommended for large database migrations?

• Data Migration Assistant
• Database Migration Service
• Database Experimentation Assistant