← Back to exam page

DP-200 – Implementing an Azure Data Solution (beta)

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (Mixed Questions)

Note: This question is a 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 an enterprise data warehouse in Azure Synapse Analytics. 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 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?

Select an option, then click Submit answer.

  • ○

    Yes
  • ○

    No
Question 14 (Mixed Questions)

You have an Azure Blob storage account.

The storage account has an alert that is configured to indicate when the Availability metric falls below 100 percent.

You receive an alert for the Availability metric. The logs for the storage account show that requests are failing because of a ServerTimeoutError error.

What does ServerTimeoutError indicate?

Select an option, then click Submit answer.

  • ○

    Read and write storage requests exceeded capacity.
  • ○

    A transient server timeout occurred while the service was moved to a different partition to load balance requests.
  • ○

    A client application attempted to perform an operation and did not have valid credentials.
  • ○

    There was excessive network latency between a client application and the storage account.
Question 15 (Mixed Questions)

A company wants to implement a solution that would perform batch processing of geospatial data.

Which of the following can be used to develop batch processing applications that use Azure HDInsight?

Select an option, then click Submit answer.

  • ○

    HDInsight Tools for Visual studio

  • ○

    Hive View

  • ○

    HDInsight REST API

  • ○

    Azure Data Factory