- (Exam Topic 5)
You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1.
Several users execute adhoc queries to DW1 concurrently. You regularly perform automated data loads to DW1.
You need to ensure that the automated data loads have enough memory available to complete quickly and successfully when the adhoc queries run.
What should you do?

1. A. Assign a smaller resource class to the automated data load queries.
2. B. Create sampled statistics to every column in each table of DW1.
3. C. Assign a larger resource class to the automated data load queries.
4. D. Hash distribute the large fact tables in DW1 before performing the automated data loads.

Correct Answer: C
The performance capacity of a query is determined by the user's resource class.
Smaller resource classes reduce the maximum memory per query, but increase concurrency. Larger resource classes increase the maximum memory per query, but reduce concurrency.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workloadman

- (Exam Topic 5)
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.
You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements:
The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.
Administrative effort must be minimized. What should you use to host the databases?

1. A. a single Azure SQL database
2. B. an Azure SQL Database elastic pool
3. C. SQL Server on Azure Virtual Machines
4. D. Azure SQL Managed Instance

Correct Answer: D

- (Exam Topic 5)
You have a Microsoft SQL Server 2017 server.
You need to migrate the server to Azure. The solution must meet the following requirements:
• Ensure that the latest version of SQL Server is used.
• Support the SQL Server Agent service. Minimize administrative effort.
What should you use?

1. A. SQL Server on Azure Virtual Machines
2. B. Azure SQL Database
3. C. an Azure SQL Database elastic pool
4. D. Azure SQL Managed Instance

Correct Answer: D

- (Exam Topic 5)
You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:DB1.bak.
You plan to deploy an Always On availability group that will have the following configurations:
VM1 will host the primary replica of DB1.
VM2 will host a secondary replica of DB1.
You need to prepare the secondary database on VM2 for the availability group.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

Solution:
Graphical user interface, text, application, chat or text message Description automatically generated
Reference:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondar

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 5)
You are planning disaster recovery for the failover group of an Azure SQL Database managed instance.
Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs.
You set the Read/Write failover policy toAutomatic.
What are two results of the configuration? Each correct answer presents a complete solution.
NOTE:Each correct selection is worth one point.

1. A. In the event of a datacenter or Azure regional outage, the databases will fail over automatically.
2. B. In the event of an outage, the databases in the primary instance will fail over immediately.
3. C. In the event of an outage, you can selectively fail over individual databases.
4. D. In the event of an outage, you can set a different grace period to fail over each database.
5. E. In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour.

Correct Answer: AE
A: Auto-failover groups allow you to manage replication and failover of a group of databases on a server or all databases in a managed instance to another region.
E: Because verification of the scale of the outage and how quickly it can be mitigated involves human actions by the operations team, the grace period cannot be set below one hour. This limitation applies to all databases in the failover group regardless of their data synchronization state.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview