← Back to exam page

DP-203 – Data Engineering on Microsoft Azure

Loading demo links...

Showing 10–12 of 20 questions

Question 10 (New Update)

You have an Azure subscription that contains an Azure SQL database named DB1 and a storage account named storage1. The storage1 account contains a file named File1.txt. File1.txt contains the names of selected tables in DB1.

You need to use an Azure Synapse pipeline to copy data from the selected tables in DB1 to the files in storage1. The solution must meet the following requirements:

• The Copy activity in the pipeline must be parameterized to use the data in File1.txt to identify the source and destination of the copy.

• Copy activities must occur in parallel as often as possible.

Which two pipeline activities should you include in the pipeline? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    If Condition
  • ○

    ForEach
  • ○

    Lookup
  • ○

    Get Metadata
Question 11 (New Update)

You are designing an Azure Synapse Analytics workspace.

You need to recommend a solution to provide double encryption of all the data at rest.

Which two components should you include in the recommendation? Each coned answer presents part of the solution

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    an X509 certificate
  • ○

    an RSA key
  • ○

    an Azure key vault that has purge protection enabled
  • ○

    an Azure virtual network that has a network security group (NSG)
  • ○

    an Azure Policy initiative
Question 12 (New Update)

A company has a real-time data analysis solution that is hosted on Microsoft Azure. The solution uses Azure Event Hub to ingest data and an Azure Stream Analytics cloud job to analyze the data. The cloud job is configured to use 120 Streaming Units (SU).

You need to optimize performance for the Azure Stream Analytics job.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    Implement event ordering.
  • ○

    Implement Azure Stream Analytics user-defined functions (UDF).
  • ○

    Implement query parallelization by partitioning the data output.
  • ○

    Scale the SU count for the job up.
  • ○

    Scale the SU count for the job down.
  • ○

    Implement query parallelization by partitioning the data input.