- All Exams Instant Download
What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
You have SQL Server on an Azure virtual machine that contains a database named DB1. You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit: What should you do to ensure that the query uses the execution...
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 create on VNet1?
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. You need to implement connectivity between VM1 and SqlDb1 to meet the following...
You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1 You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012
Task 11 You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1 You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012.View AnswerAnswer: To ensure that db1 is compatible with all...
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...
Which two dynamic management views should you use?
You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic management views should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . sys.dm_pdw_nodes_tran_locksB . sys.dm_exec_compute_node_errorsC . sys.dm_exec_requestsD . sys.dm_cdc_errorsE . sys.dm_pdw_nodes_os_wait_statsF . sys.dm_tran_locksView AnswerAnswer: AE...
How should you complete the Transact-SQL statement?
HOTSPOT You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales. You need to initiate a backup of Sales. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point....
Which audit log destination should you use to meet the monitoring requirements?
Which audit log destination should you use to meet the monitoring requirements?A . Azure StorageB . Azure Event HubsC . Azure Log AnalyticsView AnswerAnswer: C Explanation: Scenario: Use a single dashboard to review security and audit data for all the PaaS databases. With dashboards can bring together operational data that...
You need to protect all the databases on sql37006S95 from SQL injection attacks
Task 10 You need to protect all the databases on sql37006S95 from SQL injection attacks.View AnswerAnswer: SQL injection attacks are a type of cyberattack that exploit a vulnerability in the application code that interacts with the database. An attacker can inject malicious SQL statements into the user input, such as...
What should you recommend?
HOTSPOT You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point....
