Free Implementing an Azure Data Solution DP-200 Exam Practice Test

Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.You develop a data ingestion process that will import data to a Microsoft Azure SQL Data Warehouse. The data to be ingested resides in parquet files stored in an Azure Data Lake Gen 2 storage account.You need to load the data from the Azure Data Lake Gen 2 storage account into the Azure SQL Data Warehouse.Solution:1. Create a remote service binding pointing to the Azure Data Lake Gen 2 storage account2. Create an external file format and external table using the external data source3. Load the data using the CREATE TABLE AS SELECT statementDoes the solution meet the goal?

• Yes
• No

You need to implement event processing by using Stream Analytics to produce consistent JSON documents.Which three actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.You need to ensure that the missing indexes for REPORTINGDB are added.What should you use?

• SQL Database Advisor
• extended events
• Query Performance Insight
• automatic tuning

You need to configure a disaster recovery solution for SALESDB to meet the technical requirements.What should you configure in the backup policy?

• weekly long-term retention backups that are retained for three weeks
• failover groups
• a point-in-time restore
• geo-replication

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You plan to create an Azure Databricks workspace that has a tiered structure. The workspace will contain the following three workloads:A workload for data engineers who will use Python and SQLA workload for jobs that will run notebooks that use Python, Spark, Scala, and SQLA workload that data scientists will use to perform ad hoc analysis in Scala and RThe enterprise architecture team at your company identifies the following standards for Databricks environments:The data engineers must share a cluster.The job cluster will be managed by using a request process whereby data scientists and data engineers provide packaged notebooks for deployment to the cluster.All the data scientists must be assigned their own cluster that terminates automatically after 120 minutes of inactivity. Currently, there are three data scientists.You need to create the Databrick clusters for the workloads.Solution: You create a Standard cluster for each data scientist, a High Concurrency cluster for the data engineers, and a Standard cluster for the jobs.Does this meet the goal?

• Yes
• No

Use the following login credentials as needed:Azure Username: xxxxxAzure Password: xxxxxThe following information is for technical support purposes only:Lab Instance: 10277521You need to generate an email notification to admin@contoso.com if the available storage in an Azure Cosmos DB database named cosmos10277521 is less than 100,000,000 bytes.To complete this task, sign in to the Azure portal.

• Explanation: 1. In the Azure portal, click All services, click Azure Cosmos DB, and then click the cosmos10277521 Azure Cosmos DB account. 2. In the resource menu, click Alert Rules to open the Alert rules page. 3. In the Alert rules page, click Add alert. 4. In the Add an alert rule page, specify: Metric: Available storage Condition: Less than Threshold: 100,000,000 bytes

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You plan to create an Azure Databricks workspace that has a tiered structure. The workspace will contain the following three workloads:A workload for data engineers who will use Python and SQLA workload for jobs that will run notebooks that use Python, Spark, Scala, and SQLA workload that data scientists will use to perform ad hoc analysis in Scala and RThe enterprise architecture team at your company identifies the following standards for Databricks environments:The data engineers must share a cluster.The job cluster will be managed by using a request process whereby data scientists and data engineers provide packaged notebooks for deployment to the cluster.All the data scientists must be assigned their own cluster that terminates automatically after 120 minutes of inactivity. Currently, there are three data scientists.You need to create the Databrick clusters for the workloads.Solution: You create a High Concurrency cluster for each data scientist, a High Concurrency cluster for the data engineers, and a Standard cluster for the jobs.Does this meet the goal?

• Yes
• No

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.You develop a data ingestion process that will import data to a Microsoft Azure SQL Data Warehouse.The data to be ingested resides in parquet files stored in an Azure Data lake Gen 2 storage account.You need to load the data from the Azure Data Lake Gen 2 storage account into the Azure SQL Data Warehouse.Solution;1. Create an external data source pointing to the Azure Data Lake Gen 2 storage account.2. Create an external tile format and external table using the external data source.3. Load the data using the CREATE TABLE AS SELECT statement.Does the solution meet the goal?

• Yes
• No

You have an Azure virtual machine that has Microsoft SQL Server installed. The server contains a table named Table1.You need to copy the data from Table1 to an Azure Data Lake Storage Gen2 account by using an Azure Data Factory V2 copy activity.Which type of integration runtime should you use?

• Azure integration runtime
• self-hosted integration runtime
• Azure-SSIS integration runtime

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.A company uses Azure Data Lake Gen 1 Storage to store big data related to consumer behavior.You need to implement logging.Solution: Create an Azure Automation runbook to copy events.Does the solution meet the goal?

• Yes
• No

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You are developing a solution that will use Azure Stream Analytics. The solution will accept an Azure Blob storage file named Customers. The file will contain both in-store and online customer details. The online customers will provide a mailing address.You have a file in Blob storage named LocationIncomes that contains based on location. The file rarely changes.You need to use an address to look up a median income based on location. You must output the data to Azure SQL Database for immediate use and to Azure Data Lake Storage Gen2 for long-term retention.Solution: You implement a Stream Analytics job that has one streaming input, one reference input, one query, and two outputs.Does this meet the goal?

• Yes
• No