Online Access Free DP-201 Practice Test

A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance. You must design a disaster recovery strategy for the solution.
You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region.
What should you recommend?

• A.SQL Replication
• B.Azure SQL Data Sync
• C.Active geo-replication
• D.Failover-group

You are developing an application that uses Azure Data Lake Storage Gen 2.
You need to recommend a solution to grant permissions to a specific application for a limited time period.
What should you include in the recommendation?

• A.account keys
• B.role assignments
• C.Azure Active Directory (Azure AD) identities
• D.shared access signatures (SAS)

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 an Azure Data Lake Storage account that contains a staging zone.
You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.
Solution: You schedule an Azure Databricks job that executes an R notebook, and then inserts the data into the data warehouse.
Does this meet the goal?

• A.No
• B.Yes

You plan to migrate data to Azure SQL Database.
The database must remain synchronized with updates to Microsoft Azure and SQL Server.
You need to set up the database as a subscriber.
What should you recommend?

• A.SQL Server Management Studio 17.9.1 or later
• B.Data Migration Assistant
• C.SQL Server Data Tools
• D.Azure Data Factory
• E.SQL Server Agent for SQL Server 2017 or later

You are designing a solution for the ad hoc analysis of data in Azure Databricks notebooks. The data will be stored in Azure Blob storage.
You need to ensure that Blob storage will support the recovery of the data if the data is overwritten accidentally.
What should you recommend?

• A.Add a resource lock.
• B.Enable soft delete.
• C.Use read-access geo-redundant storage (RA-GRS).
• D.Enable diagnostics logging.