You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.
How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database.
You identify a long running query.
You need to identify which operation in the query is causing the performance issue.
What should you use to display the query execution plan in Microsoft SQL Server Management Studio
(SSMS)?

• A.Live Query Statistics
• B.an estimated execution plan
• C.an actual execution plan
• D.Client Statistics

Correct Answer: C

Section: [none]
Explanation:
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

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Synapse Analytics Apache Spark pool named Pool1.
You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables in Pool1. The structure and data types vary by file.
You need to load the files into the tables. The solution must maintain the source data types.
What should you do?

• A.Load the data by using PySpark.
• B.Load the data by using the OPENROWSET Transact-SQL command in an Azure Synapse Analytics
  serverless SQL pool.
• C.Use a Get Metadata activity in Azure Data Factory.
• D.Use a Conditional Split transformation in an Azure Synapse data flow.

Comment: *

Name: *

Email: *

Verification: *

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 clause
• B.CREATE USER and the FROM CERTIFICATE clause
• C.CREATE USER and the FROM LOGIN clause
• D.CREATE USER and the ASYMMETRIC KEY clause
• E.CREATE USER and the FROM EXTERNAL PROVIDER clause

Comment: *

Name: *

Email: *

Verification: *

From a website analytics system, you receive data extracts about user interactions such as downloads, link clicks, form submissions, and video plays.
The data contains the following columns:

You need to design a star schema to support analytical queries of the dat a. The star schema will contain four tables including a date dimension.
To which table should you add each column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Comment: *

Name: *

Email: *

Verification: *