Question 16

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1.
You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs.
What should you do first?
  • Question 17

    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.

    Question 18

    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.

    Question 19

    A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table.

    You need to recommend changes to the data types to reduce storage and improve performance.
    Which two actions should you recommend? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • Question 20

    You have an Azure SQL database.
    You are reviewing a slow performing query 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.