- All Exams Instant Download
What should you do first in Microsoft SQL Server Management Studio (SSMS)?
You have an Azure SQL database named DB1. You run a query while connected to DB1. You review the actual execution plan for the query, and you add an index to a table referenced by the query. You need to compare the previous actual execution plan for the query to...
What should you include in the migration plan?
Topic 1, Litware Existing Environment Network Environment The manufacturing and research datacenters connect to the primary datacenter by using a VPN. The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet. Identity Environment Litware...
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...
You have SQL Server on an Azure virtual machine
HOTSPOT You have SQL Server on an Azure virtual machine. You review the query plan shown in the following exhibit. For each of the following statements, select yes if the statement is true. Otherwise, select no. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Reference: https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store
Which column returned by the query represents the free space in each file?
You have the following Transact-SQL query. Which column returned by the query represents the free space in each file?A . ColumnAB . ColumnBC . ColumnCD . ColumnDView AnswerAnswer: C Explanation: Example: Free space for the file in the below query result set will be returned by the FreeSpaceMB column. SELECT...
What are two results of the configuration?
You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic. What are two results...
What should you use to migrate the PostgreSQL database?
What should you use to migrate the PostgreSQL database?A . Azure Data BoxB . AzCopyC . Azure Database Migration ServiceD . Azure Site RecoveryView AnswerAnswer: C Explanation: Reference: https://docs.microsoft.com/en-us/azure/dms/dms-overview
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...
Which format should you use for the tables in DB1?
You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1. You plan to create a database named DB1 in Pool1. You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless...
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:...
