DP-300 Exam Question 36
You have an Azure Data Factory that contains 10 pipelines.
You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.
What should you add to each pipeline?
You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.
What should you add to each pipeline?
DP-300 Exam Question 37
Your company has an Azure SQL database named pass4testdb. This is on an Azure SQL Server called whizlabserver1000. You have to create a contained database user in the database based on an Azure AD user.
Which of the following would you execute for this requirement? (Choose 3 answers)
Which of the following would you execute for this requirement? (Choose 3 answers)
DP-300 Exam Question 38
Drag and Drop Question
You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures.
You need to ensure that SQL Server Agent jobs running on SQL1 can notify administrators when a failure occurs.
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.
You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures.
You need to ensure that SQL Server Agent jobs running on SQL1 can notify administrators when a failure occurs.
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.
DP-300 Exam Question 39
You have an on-premises, 20-TB Microsoft SQL Server database named DB1 that is used by a web app named App1.
You have an Azure subscription that contains a storage account named storage1.
You need to migrate DB1 to an Azure SQL database. The solution must minimize downtime for App1.
What should you use to perform the migration?
You have an Azure subscription that contains a storage account named storage1.
You need to migrate DB1 to an Azure SQL database. The solution must minimize downtime for App1.
What should you use to perform the migration?
DP-300 Exam Question 40
Drag and Drop Question
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.
Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.
Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
