- All Exams Instant Download
Which three actions should you perform in sequence?
DRAG DROP You create all of the tables and views for ResearchDB1. You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer...
What should you use?
You have an Azure SQL Database managed instance. The instance starts experiencing performance issues. You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort. What should you use?A . the Azure portal B. Extended Events C....
Which two columns support encryption?
You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the following columns. You plan to enable Always Encrypted for Table1. Which two columns support encryption? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one pointA . Column1 B....
What should you include in the recommendation?
You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1. You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync...
Does this meet the goal?
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...
What should you do to schedule the pipelines for execution?
You have the following Azure Data Factory pipelines: ✑ Ingest Data from System1 ✑ Ingest Data from System2 ✑ Populate Dimensions ✑ Populate Facts Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2....
You have an Azure SQL database named DB1 that contains a table named Table 1
HOTSPOT You have an Azure SQL database named DB1 that contains a table named Table 1. You run a query to load data into Table1. The performance metrics of Table1 during the load operation are shown in the following exhibit. Use the drop-down menus to select the answer choice that...
You configure version control for an Azure Data Factory instance as shown in the following exhibit
HOTSPOT You configure version control for an Azure Data Factory instance as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Graphical...
Which four actions should you perform in sequence?
DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. View AnswerAnswer: Explanation:...
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...
