You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements:
* Support failovers that do not require client applications to change their connection strings.
* Replicate the database to a secondary Azure region.
* Support failover to the secondary region.
What should you include in the recommendation?

• A.failover groups
• B.transactional replication
• C.Availability Zones
• D.geo-replication

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Data Factory that contains 10 pipelines.
You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.
What should you add to each pipeline?

• A.an annotation
• B.a resource tag
• C.a run group ID
• D.a user property
• E.a correlation ID

Comment: *

Name: *

Email: *

Verification: *

Note: This question is part of a series of questions that present the same scenario. Each question in
the series contains a unique solution that might meet the stated goals. Some question sets might have
more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these
questions will not appear in the review screen.
You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL
database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on
Server2.
Solution: You run the Remove-AzSqlDatabasePowerShell cmdlet for Database1 on Server2. You run the
Restore-AzSqlDatabasePowerShell cmdlet for Database1 on Server2.
Does this meet the goal?

• A.Yes
• B.No

Comment: *

Name: *

Email: *

Verification: *

You are evaluating the role assignments.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles

Comment: *

Name: *

Email: *

Verification: *

You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine
has 4 vCPUs and 28 GB of memory.
You scale up the virtual machine to 16 vCPUSs and 64 GB of memory.
You need to provide the lowest latency for tempdb.
What is the total number of data files that tempdb should contain?

• A.2
• B.4
• C.8
• D.64

Comment: *

Name: *

Email: *

Verification: *