DP-200

DRAG DROP You have an Azure SQL database named DB1 in the Each US 2 region. You need to build a secondary geo-replicated copy of DB1 in the West US region on a new server. Which three actions should you perform in sequence? To answer, move the appropriate actions from...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You need to create an elastic pool that contains an Azure SQL database named db2 and a new SQL database named db3. To complete...

You are developing a data engineering solution for a company. The solution will store a large set of key-value pair data by using Microsoft Azure Cosmos DB. The solution has the following requirements: - Data must be partitioned into multiple containers. - Data containers must be configured separately. - Data...

HOTSPOT You need to implement an Azure Databricks cluster that automatically connects to Azure Data Lake Storage Gen2 by using Azure Active Directory (Azure AD) integration. How should you configure the new cluster? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You need to create an elastic pool that contains an Azure SQL database named db2 and a new SQL database named db3. To complete...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You need to create an Azure Storage account named account10543936. The solution must meet the following requirements: - Minimize storage costs. - Ensure that...

You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data. The analytical data store performs poorly. You must implement a solution that meets the following requirements: - Provide data warehousing - Reduce ongoing management activities...

DRAG DROP You have an Azure SQL database named DB1 in the Each US 2 region. You need to build a secondary geo-replicated copy of DB1 in the West US region on a new server. Which three actions should you perform in sequence? To answer, move the appropriate actions from...

SIMULATION Use the following login credentials as needed: Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10277521 You need to increase the size of db2 to store up to 250 GB of data. To...

SIMULATION Use the following login credentials as needed: Azure Username: xxxxx Azure Password: xxxxx The following information is for technical support purposes only: Lab Instance: 10543936 You plan to enable Azure Multi-Factor Authentication (MFA). You need to ensure that [email protected] can manage any databases hosted on an Azure SQL server...