- All Exams Instant Download
You need to ensure that all queries executed against dbl are captured in the Query Store
Task 3 You need to ensure that all queries executed against dbl are captured in the Query Store.View AnswerAnswer: To ensure that all queries executed against dbl are captured in the Query Store, you need to enable the Query Store feature for the database and set the query capture mode...
Which two actions should you recommend?
A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table. You need to recommend changes to the data...
What should you run as part of the implementation?
You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements. What should you run as part of the implementation?A . CREATE LOGIN and the FROM WINDOWS clauseB . CREATE USER and the FROM CERTIFICATE clauseC . CREATE USER and the FROM LOGIN clauseD ....
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 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...
You need to configure your user account as the Azure AD admin for the server named sql3700689S
Task 2 You need to configure your user account as the Azure AD admin for the server named sql3700689S.View AnswerAnswer: To configure your user account as the Azure AD admin for the server named sql3700689S, you can use the Azure portal or the Azure CLI. Here are the steps for...
Which type of storage accounts should you use for the backups?
You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine. In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs. Which type of storage accounts should you use for...
What is the total number of data files that tempdb should contain?
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 8 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb. What...
Which three actions should you perform in sequence?
DRAG DROP You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only user who was created is the server administrator. You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication. Which three...
Which deployment option and pricing tier should you configure?
You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?A . Azure SQL Database HyperscaleB . Azure SQL Database managed instance...
