To include an execution plan for a query during execution
1. On the SQL Server Management Studio toolbar, click Database Engine Query. You can also open an existing query and display the estimated execution plan by clicking the Open File toolbar button and locating the existing query.
2. Enter the query for which you would like to display the actual execution plan.
3. On the Query menu, click Include Actual Execution Plan or click the Include Actual Execution Plan toolbar button.

Note: Actual execution plans are generated after the Transact-SQL queries or batches execute. Because of this, an actual execution plan contains runtime information, such as actual resource usage metrics and runtime warnings (if any). The execution plan that is generated displays the actual query execution plan that the SQL Server Database Engine used to execute the queries.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/display-an-actual-execution-plan

Section: [none]
Explanation:
The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility
issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA
recommends performance and reliability improvements for your target environment and allows you to move
your schema, data, and uncontained objects from your source server to your target server.
Note: SQL Managed Instance supports the following database migration options (currently these are the only
supported migration methods):
* Azure Database Migration Service - migration with near-zero downtime.
* Native RESTORE DATABASE FROM URL - uses native backups from SQL Server and requires some
downtime.
Reference:
https://docs.microsoft.com/en-us/sql/dma/dma-overview

Azure RBAC is used to manage who can create, update, or delete the Synapse workspace and its SQL pools, Apache Spark pools, and Integration runtimes.
Define and implement network security configurations for resources related to your dedicated SQL pool with Azure Policy.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/security/synapse-workspace-synapse-rbac
https://docs.microsoft.com/en-us/security/benchmark/azure/baselines/synapse-analytics-security-baseline

Section: [none]
Explanation:
Instead restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and
the REPLACE option.
Note: REPLACE should be used rarely and only after careful consideration. Restore normally prevents
accidentally overwriting a database with a different database. If the database specified in a RESTORE
statement already exists on the current server and the specified database family GUID differs from the
database family GUID recorded in the backup set, the database is not restored. This is an important safeguard.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql

Section: [none]
Explanation:
Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary
databases of individual databases on a server in the same or different data center (region).
Incorrect Answers:
C: Availability Zones are unique physical locations within a region. Each zone is made up of one or more
datacenters equipped with independent power, cooling, and networking.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview