- All Exams Instant Download
How should you collect and stream metrics?
HOTSPOT You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements. How should you collect and stream metrics? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The server, the elastic...
What should you do?
You have an Azure SQL database named db1 on a server named server1. You need to modify the MAXDOP settings for db1. What should you do?A . Connect to db1 and run the sp_configure command.B . Connect to the master database of server1 and run the sp_configure command.C . Configure...
Which windowing function should you use to perform the streaming aggregation of the sales data?
Topic 3, ADatum Corporation This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that...
Which Azure Storage functionality should you include in the solution?
Topic 4, Contoso Ltd Clothing Store You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . time-based retentionB . change feedC . lifecycle managementD . soft...
What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
You have an Azure SQL database. You identify a long running query. You need to identify which operation in the query is causing the performance issue. What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?A . Live Query StatisticsB . an estimated...
Which format should you use for the tables in DB1?
You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1. You plan to create a database named DB1 in Pool1. You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless...
What should you add to each pipeline?
You have an Azure Data Factory that contains 10 pipelines. You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory. What should you add to each pipeline?A...
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?A . Configure SalesSQLDb1 as writable.B . Update the connection strings of SalesSQLDb1App1.C . Update the firewall rules of SalesSQLDb1.D . Update the users in SalesSQLDb1.View AnswerAnswer: C Explanation: Scenario: SalesSQLDb1 uses database...
What should you include in the solution?
HOTSPOT You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation:...
What should you include in the recommendation?
HOTSPOT You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The solution must meet the business requirements. What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario:...
