Boot Camp DSD

What Azure storage is recommended for production data files that requires maximum throughput?

• A.     Premium SSD

• Standard SSD

• Ultra disks

• Blob

What option should you select to change the auto-pause setting of a serverless SQL Database?

• Ensure that there are no active transactions in the database, as the auto-pause change will result in a disconnection

• The Azure portal allows you to change the auto-pause setting at any time

• The auto-pause setting can't be changed, and it's fixed at one hour

• None

Which SQL Server PaaS offering should you choose if you want to restore an on-premises database backup to Azure?

• Azure SQL Managed Instance

• Azure SQL Database

• Azure SQL VM

• You can use both Azure SQL Database and Azure SQL Managed Instance.

What type of storage offers the lowest latency in Azure?

• Standard SSD

• Ultra SSD

• Premium SSD

• HHD

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

• Pay as You Go Licensing

• Availability set

• Azure Reserved VM Instances

• None

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

• Availability units

• Availability sets

• Availability zones

• None

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

• Availability Set

• Azure Site Recovery

• Azure Backup for SQL Server

• Availability Groups

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 Managed Instance

• Azure SQL Database Hyperscale

• None

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 Hyperscale

• Azure SQL Database Serverless

• None

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 Managed Instance

• Azure SQL Database Elastic Pools

• Azure SQL Database Serverless