Online Access Free DP-200 Practice Test

Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You develop a data ingestion process that will import data to a Microsoft Azure SQL Data Warehouse. The data to be ingested resides in parquet files stored in an Azure Data Lake Gen 2 storage account.
You need to load the data from the Azure Data Lake Gen 2 storage account into the Azure SQL Data Warehouse.
Solution:
1. Create a remote service binding pointing to the Azure Data Lake Gen 2 storage account
2. Create an external file format and external table using the external data source
3. Load the data using the CREATE TABLE AS SELECT statement
Does the solution meet the goal?

• A.No
• B.Yes

A company has a Microsoft Azure HDInsight solution that uses different cluster types to process and analyze dat a. Operations are continuous.
Reports indicate slowdowns during a specific lime window.
You need to determine a monitoring solution to track down the issue in the least amount of time.
What should you use?

• A.Azure Monitor Metrics
• B.HDInsight .NET SDK
• C.Azure Log Analytics alert rule query
• D.Ambari REST API
• E.Azure Log Analytics log search query

Use the following login credentials as needed:
Azure Username: xxxxx
Azure Password: xxxxx
The following information is for technical support purposes only:
Lab Instance: 10543936

Your company's security policy states that administrators must be able to review a list of the failed logins to an Azure SQL database named db1 during the previous 30 days.
You need to modify your Azure environment to meet the security policy requirements.
To complete this task, sign in to the Azure portal.

Correct Answer:

Set up auditing for your database
The following section describes the configuration of auditing using the Azure portal.
1. Go to the Azure portal.
2. Navigate to Auditing under the Security heading in your SQL database db1/server pane

3. If you prefer to enable auditing on the database level, switch Auditing to ON.

Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing

You are building an Azure Stream Analytics job to identify how much time a user spends interacting with a feature on a webpage.
The job receives events based on user actions on the webpage. Each row of data represents an event. Each event has a type of either 'start' or 'end'.
You need to calculate the duration between start and end events.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-stream-analytics-query-patterns

You need to ensure that phone-based poling data can be analyzed in the PollingData database.
How should you configure Azure Data Factory?

• A.Use a schedule trigger
• B.Use manual execution
• C.Use a tumbling schedule trigger
• D.Use an event-based trigger