- All Exams Instant Download
Which four actions should you perform for DB1 in sequence?
DRAG DROP You have an Azure SQL database named DB1. DB1 contains a table that has a column named Col1. You need to encrypt the data in Col1. Which four actions should you perform for DB1 in sequence? To answer, move the appropriate actions from the list of actions to...
Which four actions should you perform in sequence to resolve the issue?
DRAG DROP You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database. A recent failure causes the master database to be lost. You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine. Which four actions should you...
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:...
Which service should you use to ingest the data?
You are designing a streaming data solution that will ingest variable volumes of data. You need to ensure that you can change the partition count after creation. Which service should you use to ingest the data?A . Azure Event Hubs Standard B. Azure Stream Analytics C. Azure Data Factory D....
Which three objects should you create in sequence?
DRAG DROP You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB...
Topic 5, Misc. Questions
Topic 5, Misc. Questions HOTSPOT You have an Azure SQL database. You are reviewing a slow performing query 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...
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...
What should you include in the recommendation?
You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals. What should you include in the recommendation?A . For each customer, grant the customer ddl_admin to the existing schema.B . For each customer, create an additional schema...
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...
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...
