- All Exams Instant Download
Which windowing function should you use to perform the streaming aggregation of the sales data?
Topic 3, ADatum Corporation Overview 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...
What should you use as the event_file target?
You need to identify the event_file target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements. What should you use as the event_file target?A . an Azure SQL databaseB . an Azure Blob Storage containerC . a SQL Server filegroupD . an...
You need to configure high availability for dbl
SIMULATION Task 12 You need to configure high availability for dbl. The solution must tolerate the loss of an Azure datacenter without data loss or the need to modify application connection strings.View AnswerAnswer: To configure high availability for dbl, you can use the failover groups feature of Azure SQL Database....
What should you implement to meet the disaster recovery requirements for the PaaS solution?
What should you implement to meet the disaster recovery requirements for the PaaS solution?A . Availability ZonesB . failover groupsC . Always On availability groupsD . geo-replicationView AnswerAnswer: B Explanation: Scenario: In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal...
What should you include in the recommendation?
You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements. What should you include in the recommendation?A . a public endpoint via a database-level firewall ruleB . a private endpointC . a...
What should you include in the backup strategy?
You have 10 Azure virtual machines that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?A . Automated...
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...
What should you recommend?
HOTSPOT You need to recommend which service and target endpoint to use when migrating the databases from SVR1 to Instance1. The solution must meet the availability requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point. View...
You need to protect all the databases on sql37006S95 from SQL injection attacks
SIMULATION 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...
How should you protect the contents of Column1?
HOTSPOT You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1. You need to protect the contents of Column1 at rest, in transit, and in use....
