DP-300 Administering Relational Databases on Microsoft Azure (beta)

Loading demo links...

Showing 1–3 of 15 questions

Question 1 (Mixed Questions)

DRAG DROP

You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a user named [email protected] and an Azure SQL managed instance named SQLMI1.

You need to ensure that [email protected] can create logins in SQLMI1 that map to Azure AD service principals.

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.

Select and Place:

Answer is in the explanation below.

Question 2 (New Update)

You have a database named db1.

The log for db1 contains the following entry.

You need to ensure That db1 can process transactions.

Answer is in the explanation below.

Question 3 (Mixed Questions)

HOTSPOT

You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.

You execute the Transact-SQL query 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.

Hot Area:

Answer is in the explanation below.