DP-200

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...

HOTSPOT You are developing a solution using a Lambda architecture on Microsoft Azure. The data at rest layer must meet the following requirements: * Data storage: - Serve as a repository for high volumes of large files in various formats. - Implement optimized storage for big data analytics workloads. -...

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 ensure that users in the West US region can read data from a local copy of an Azure Cosmos DB database...

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 To complete this task, sign in to the Azure portal.View AnswerAnswer: Step 1: Create a new SQL database named db3

A company runs Microsoft SQL Server in an on-premises virtual machine (VM). You must migrate the database to Azure SQL Database. You synchronize users from Active Directory to Azure Active Directory (Azure AD). You need to configure Azure SQL Database to use an Azure AD user as administrator. What should...

Load the data using the INSERT…SELECT statement Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B Explanation: You load the data using the CREATE TABLE AS SELECT statement. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lakestore

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 dat A. The analytical data store performs poorly. You must implement a solution that meets the following requirements: Provide data warehousing Reduce ongoing management activities Deliver...

You plan to implement an Azure Cosmos DB database that will write 100,000 JSON every 24 hours. The database will be replicated to three regions. Only one region will be writable. You need to select a consistency level for the database to meet the following requirements: Guarantee monotonic reads and...

DRAG DROP You manage a financial computation data analysis process. Microsoft Azure virtual machines (VMs) run the process in daily jobs, and store the results in virtual hard drives (VHDs.) The VMs product results using data from the previous day and store the results in a snapshot of the VHD....

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 dat A. The analytical data store performs poorly. You must implement a solution that meets the following requirements: Provide data warehousing Reduce ongoing management activities Deliver...