Question 46

You configure backup for an Azure SQL database as shown in the following exhibit.

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

Question 47

You have an Azure SQL Database managed instance.
The instance starts experiencing performance issues.
You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort.
What should you use?
  • Question 48

    You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1.
    You need to protect the contents of Column1 at rest, in transit, and in use.
    How should you protect the contents of Column1? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 49

    You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
    The database role membership for a user named User1 is 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.

    Question 50

    You are designing a streaming data solution that will ingest variable volumes of data.
    You need to ensure that you can change the partition count after creation.
    Which service should you use to ingest the data?