DP-300 Dumps

DP-300 Free Practice Test

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

QUESTION 56

- (Exam Topic 1)
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.
DP-300 dumps exhibit
Solution:
Scenario: Authenticate database users by using Active Directory credentials.
The configuration steps include the following procedures to configure and use Azure Active Directory authentication.
DP-300 dumps exhibit Create and populate Azure AD.
DP-300 dumps exhibit Optional: Associate or change the active directory that is currently associated with your Azure Subscription.
DP-300 dumps exhibit Create an Azure Active Directory administrator. (Step 1)
DP-300 dumps exhibit Configure your client computers.
DP-300 dumps exhibit Create contained database users in your database mapped to Azure AD identities. (Step 2)
DP-300 dumps exhibit Connect to your database by using Azure AD identities. (Step 3)
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview

Does this meet the goal?

Correct Answer: A

QUESTION 57

- (Exam Topic 5)
You are designing an anomaly detection solution for streaming data from an Azure IoT hub. The solution must meet the following requirements:
DP-300 dumps exhibit Send the output to an Azure Synapse.
DP-300 dumps exhibit Identify spikes and dips in time series data.
DP-300 dumps exhibit Minimize development and configuration effort. Which should you include in the solution?

Correct Answer: C
Anomalies can be identified by routing data via IoT Hub to a built-in ML model in Azure Stream Analytics Reference:
https://docs.microsoft.com/en-us/learn/modules/data-anomaly-detection-using-azure-iot-hub/ https://docs.microsoft.com/en-us/azure/stream-analytics/azure-synapse-analytics-output