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

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, thesequestions will not appear in the review screen.You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22).You need to implement masking for the Customer_ID field to meet the following requirements:The first two prefix characters must be exposed.The last four prefix characters must be exposed.All other characters must be masked.Solution: You implement data masking and use a random number function mask.Does this meet the goal?

• Yes
• No

You manage an enterprise data warehouse in Azure Synapse Analytics.Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.You need to monitor resource utilization to determine the source of the performance issues.Which metric should you monitor?

• Data Warehouse Units (DWU) used
• DWU limit
• Cache hit percentage
• Data IO percentage

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

A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database.You must perform an assessment of databases to determine whether data will move without compatibility issues.You need to perform the assessment.Which tool should you use?

• Azure SQL Data Sync
• SQL Vulnerability Assessment (VA)
• SQL Server Migration Assistant (SSMA)
• Microsoft Assessment and Planning Toolkit
• Data Migration Assistant (DMA)

You are monitoring an Azure Stream Analytics job.The Backlogged Input Events count has been 20 for the last hour.You need to reduce the Backlogged Input Events count.What should you do?

• Add an Azure Storage account to the job
• Increase the streaming units for the job
• Stop the job
• Drop late arriving events from the job

You are monitoring an Azure Stream Analytics job.You discover that the Backlogged Input Events metric is increasing slowly and is consistently non-zero.You need to ensure that the job can handle all the events.What should you do?

• Change the compatibility level of the Stream Analytics job.
• Increase the number of streaming units (SUs).
• Create an additional output stream for the existing input stream.
• Remove any named consumer groups from the connection and use $default.

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

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 replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region.To complete this task, sign in to the Azure portal.NOTE: This task might take several minutes to complete. You can perform other tasks while the task completes or ends this section of the exam.To complete this task, sign in to the Azure portal.

• Explanation: 1. In the Azure portal, browse to the database that you want to set up for geo-replication. 2. On the SQL database page, select geo-replication, and then select the region to create the secondary database.3. Select or configure the server and for the secondary database. Region: Central Canada Target server: REPL102775214. Click Create to add the secondary. 5. The secondary database is created and the seeding process begins.6. When the seeding process is complete, the secondary database displays its status.References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-active-geo-replication-portal

A company plans to use Azure SQL Database to support a mission-critical application.The application must be highly available without performance degradation during maintenance windows.You need to implement the solution.Which three technologies should you implement? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

• Premium service tier
• Virtual machine Scale Sets
• Basic service tier
• SQL Data Sync
• Always On availability groups
• Zone-redundant configuration

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 have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB.You plan to copy the data from the storage account to an enterprise data warehouse in Azure Synapse Analytics.You need to prepare the files to ensure that the data copies quickly.Solution: You convert the files to compressed delimited text files.Does this meet the goal?

• Yes
• No