- All Exams Instant Download
What should you do?
You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?A . Use the Agent XPs option. B. Enable the SQL Server Agent. C. Run the sp_configure command. D. Run the sp set_agent properties command.View AnswerAnswer: C
Which type of disk should you use for each workload?
DRAG DROP You have an Azure subscription. You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance. You need to configure the disks on the virtual machine. The solution must meet the following requirements: • Minimize latency for transaction logs. • Minimize the...
Which authentication solution or solutions should you include in the recommendation?
HOTSPOT You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1. You need to recommend an authentication solution for Pool1. The solution must support multi-factor authentication (MFA) and database-level authentication. Which authentication...
Which three actions should you perform in sequence?
DRAG DROP You need to configure user authentication for the SERVER1 databases. 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 area and arrange them in the correct...
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 50 Azure SQL databases. You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure. What should you do?A . Create a diagnostic setting for the activity log that has the Security log enabled. B. For...
What should you do?
You have an Azure SQL database named db1 on a server named server1. The Intelligent Insights diagnostics log identifies that several tables are missing indexes. You need to ensure that indexes are created for the tables. What should you do?A . RuntheDBCC SQLPERF command. B. Run the dbcc dbreindex command....
Which database option should set?
You deploy a database to an Azure SQL Database managed instance. You need to prevent read queries from blocking queries that are trying to write to the database. Which database option should set?A . PARAMETERIZATION to FORCED B. PARAMETERIZATION to SIMPLE C. Delayed Durability to Forced D. READ_COMMITTED_SNAPSHOT to ONView...
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:...
Which feature should you use to provide customers with the required level of access based on their service agreement?
You are evaluating the business goals. Which feature should you use to provide customers with the required level of access based on their service agreement?A . dynamic data masking B. Conditional Access in Azure C. service principals D. row-level security (RLS)View AnswerAnswer: D Explanation: Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15
