Data Engineering on Microsoft Azure Free Sample Questions

Description

Covers implementing partition strategies and data exploration layers, ingesting and transforming batch and streaming data, and securing, monitoring and optimizing data processing.

11 free sample questions61 in the full practice test Other versions: DP-700(167),DP-201(74)

Try simulator

DP-203 Sample Questions

  1. Question 1

    Intermediate

    You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement.You need to alter the table to meet the following requirements:✑ Ensure that users can identify the current manager of employees.✑ Support creating an employee reporting hierarchy for your entire company.✑ Provide fast lookup of the managers' attributes such as name and job title.Which column should you add to the table?

    Question 1 image
    Answer and explanation

    Correct answer: C

  2. Question 2

    Intermediate

    You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark database named mytestdb.You run the following command in an Azure Synapse Analytics Spark pool in MyWorkspace.CREATE TABLE mytestdb.myParquetTable(EmployeeID int,EmployeeName string,EmployeeStartDate date)USING Parquet -You then use Spark to insert a row into mytestdb.myParquetTable. The row contains the following data.One minute later, you execute the following query from a serverless SQL pool in MyWorkspace.SELECT EmployeeID -FROM mytestdb.dbo.myParquetTableWHERE EmployeeName = 'Alice';What will be returned by the query?

    Question 2 image
    Answer and explanation

    Correct answer:

  3. Question 3

    Intermediate

    You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit.You create an external table named ExtTable that has LOCATION='/topfolder/'.When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned?

    Question 3 image
    Answer and explanation

    Correct answer: B

  4. Question 4

    Intermediate

    You are designing the folder structure for an Azure Data Lake Storage Gen2 container.Users will query data by using a variety of services including Azure Databricks and Azure Synapse Analytics serverless SQL pools. The data will be secured by subject area. Most queries will include data from the current year or current month.Which folder structure should you recommend to support fast queries and simplified folder security?

    Answer and explanation

    Correct answer: D

  5. Question 5

    Intermediate

    You need to design an Azure Synapse Analytics dedicated SQL pool that meets the following requirements:✑ Can return an employee record from a given point in time.✑ Maintains the latest employee information.✑ Minimizes query complexity.How should you model the employee data?

    Answer and explanation

    Correct answer: D

Register free for 6 more questions

Or unlock all 61 DP-203 questions with explanations, timed mode and flashcards.