You configure version control for an Azure Data Factory instance as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/source-control

Comment: *

Name: *

Email: *

Verification: *

You have an Azure subscription that contains the resources shown in the following table.

You need to back up db1 to mysqlbackups, and then restore the backup to a new database named db2 that is hosted on SQL1. The solution must ensure that db1 is backed up to a stripe set.
Which three Transact-SQL statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

Correct Answer:

1 - CREATE CREDENTIAL ,,,,,,,,
2 - BACKUP DATABASE db1,,,,,,
3 - RESTORE DATABASE db2 FROM URL=,,,,,,,
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver15

Comment: *

Name: *

Email: *

Verification: *

You have a burstable Azure virtual machine named VMI that hosts an instance of Microsoft SQL Server.
You need to attach an Azure ultra disk to VMI. The solution must minimize downtime on VMI.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation

Comment: *

Name: *

Email: *

Verification: *

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 order.

Correct Answer:

1 - Create an Azure AD administrator for the logical server
2 - Create contained database users
3 - Connect to the database by using an Azure AD account
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview

Comment: *

Name: *

Email: *

Verification: *

D18912E1457D5D1DDCBD40AB3BF70D5D
You need to identify the cause of the performance issues on SalesSQLDb1.
Which two dynamic management views should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.sys.dm_pdw_nodes_tran_locks
• B.sys.dm_exec_compute_node_errors
• C.sys.dm_exec_requests
• D.sys.dm_cdc_errors
• E.sys.dm_pdw_nodes_os_wait_stats
• F.sys.dm_tran_locks

Comment: *

Name: *

Email: *

Verification: *