You are planning a solution that will use Azure SQL Database. Usage of the solution will
peak from October 1 to January 1 each year.
During peak usage, the database will require the following:
24 cores
500 GB of storage
124 GB of memory
More than 50,000 IOPS
During periods of off-peak usage, the service tier of Azure SQL Database will be set to
Standard.
Which service tier should you use during peak usage?

You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.
You plan to create a database named DB1 in Pool1.
You need to ensure that when tables are created in DB1, the tables are available
automatically as external tables to the built-in serverless SQL pool.
Which format should you use for the tables in DB1?

You have 50 Azure SQL databases.
You need to notify the database owner when the database settings, such as the database
size and pricing tier, are modified in Azure.
What should you do?

You have SQL Server on an Azure virtual machine named SQL1.
SQL1 has an agent job to back up all databases.
You add a user named dbadmin1 as a SQL Server Agent operator.
You need to ensure that dbadmin1 receives an email alert if a job fails.
Which three actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines. Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure. You need to recommend a solution to fail over the database tier of App1 to Azure. The
solution must provide the ability to test failover to Azure without affecting the current environment. What should you include in the recommendation?

You have an on-premises Microsoft SQL Server 2019 server that hosts a database named
DB1.
You have an Azure subscription that contains an Azure SQL managed instance named
SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The onpremises
network connects to VNET1 by using an ExpressRoute connection.
You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.
You need to configure VNET1 to support the migration.
What should you do?

You are building an Azure virtual machine.
You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk
provides 5,000 IOPS.
You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual
machine. The instance has a database that contains a 1.2-TiB data file. The database
requires 10,000 IOPS
You need to configure storage for the virtual machine to support the database.
Which three objects should you create in sequence? To answer, move the appropriate
objects from the list of objects to the answer area and arrange them in the correct order

You have a 50-TB Microsoft SQL Server database named DB1.
You need to reduce the time it takes to perform database consistency checks of DB1.
Which Transact-SQL command should you run? To answer, select the appropriate options
in the answer area.
NOTE: Each correct selection is worth one point.