- (Exam Topic 2)
Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

1. A. Business Critical 4-vCore
2. B. Hyperscale
3. C. General Purpose v-vCore
4. D. Serverless

Correct Answer: A
There are CPU and Data I/O spikes for the PaaS prototype. Business Critical 4-vCore is needed. Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview

- (Exam Topic 5)
You have an Azure SQL database named DB1.
You have a table name Table1 that has 20 columns of typeCHAR(400). Row compression for Table1 is enabled.
During a database audit, you discover that none of the fields contain more than 150 characters. You need to ensure that you can apply page compression to Table1.
What should you do?

1. A. Configure the columns as sparse.
2. B. Change the column type tonvarchar(MAX).
3. C. Change the column type tovarchar(MAX).
4. D. Change the column type tovarchar(200).

Correct Answer: D

Reference:
https://www.sqlshack.com/sql-varchar-data-type-deep-dive/ https://36chambers.wordpress.com/2020/06/18/nvarchar-everywhere-a-thought-experiment/

- (Exam Topic 5)
Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1. You have an Azure subscription.
You plan to migrate db1 to an Azure SQL managed instance.
You need to create the SQL managed instance. The solution must minimize the disk latency of the instance. Which service tier should you use?

1. A. Hyperscale
2. B. General Purpose
3. C. Premium
4. D. Business Critical

Correct Answer: D

- (Exam Topic 5)
You have an Azure subscription that contains the resources shown in the following table.

App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.
You need to modify db1 to resolve the issues experienced by Appl as soon as possible, without considering immediate costs
What you do?

1. A. Increase the number of vCores allocated to db1.
2. B. Decrease the auto-pause delay for db1.
3. C. Disable auto-pause delay for db1.
4. D. Enable automatic tuning for db1.

Correct Answer: D

- (Exam Topic 5)
You have an Azure subscription that contains an Azure SQL managed instance named SQLMi1 and a SQL Agent job named Backupdb. Backupdb performs a daily backup of the databases hosted on SQLMi1.
You need to be notified by email if the 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.
NOTE:More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Solution:
Text Description automatically generated
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A