DP-203 practice questions 11–20

1. Question 11 · 370 in bank

   HOTSPOT - You have an Azure Databricks workspace. You read data from a CSV file by using a notebook, and then load the data to a DataFrame. You need to add rows from the DataFrame to an existing Delta table by using Python code. How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   References

   • Microsoft Learn

   

   Next question

2. Question 12 · 370 in bank

   DRAG DROP - You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1. The account1 account contains a container named Container1 that has the following configurations: • Analytical store: On • TTL: 3600 You need to remove analytical store support from Container1. The solution must meet the following requirements: • Minimize the impact on the apps that reference Container1. • Minimize storage usage. Which four 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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   

   Next question

3. Question 13 · 370 in bank

   DRAG DROP - You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: DISTRIBUTION - Table distribution options include DISTRIBUTION = HASH ( distribution_column_name ), assigns each row to one distribution by hashing the value stored in distribution_column_name. Box 2: PARTITION - Table partition options. Syntax: PARTITION ( partition_column_name RANGE [ LEFT | RIGHT ] FOR VALUES ( [ boundary_value [,...n] ] )) Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-azure-sql-data-warehouse ?

   Source: Adapted from community discussion — Sasha_in_San_Francisco

   References

   • Microsoft Learn

   

   Next question

4. Question 14 · 370 in bank

   DRAG DROP - You have an Azure Synapse Analytics dedicated SQL pool named SQL1 that contains a hash-distributed fact table named Table1. You need to recreate Table1 and add a new distribution column. The solution must maximize the availability of data. Which four 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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   References

   • Microsoft Learn

   

   Next question

5. Question 15 · 370 in bank

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure subscription that contains an Azure data factory named ADF1. From Azure Data Factory Studio, you build a complex data pipeline in ADF1. You discover that the Save button is unavailable, and there are validation errors that prevent the pipeline from being published. You need to ensure that you can save the logic of the pipeline. Solution: You disable all the triggers for ADF1. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   Agreed with the others: Git is needed to save the changes, and triggers have nothing to do with saving the pipeline logic. Answer is NO.

   Source: Adapted from community discussion — vernillen

   Next question

6. Question 16 · 370 in bank

   Select 2

   You have an Azure subscription that contains the resources shown in the following table.

   

   You need to implement Azure Synapse Link for Azure SQL Database. Which two actions should you perform on sql1? Each correct answer presents a part of the solution. NOTE: Each correct selection is worth one point.

   • AUpdate the firewall rules to allow Azure services to access sql1.
   • BEnable the system-assigned managed identity.
   • CFrom the Access control (IAM) settings, assign the Contributor role to the system-assigned managed identity of workspace1.
   • DDisable Transparent Data Encryption (TDE).

   Show answer

   Answer: AB

   References

   • Microsoft Learn

   Next question

7. Question 17 · 370 in bank

   You have an Azure subscription that contains an Azure Cosmos DB database. Azure Synapse Link is implemented on the database. You configure a full fidelity schema for the analytical store. You perform the following actions: • Insert {"customerID": 12, "customer": “Tailspin Toys"} as the first document in the container. • Insert {"customerID": "14", "customer": "Contoso"} as the second document in the container. How many columns will the analytical store contain?

   • A1
   • B2
   • C3
   • D4

   Show answer

   Answer: C

   Explanation

   C - With a full fidelity schema, the analytical store will track both the data and their types accurately. This means different types for the same field will be stored in separate columns. Specifically: There will be one column for customerID as an integer. There will be another column for customerID as a string. There will be one column for customer as a string.

   Source: Adapted from community discussion — JamieMcD

   References

   • Microsoft Learn

   Next question

8. Question 18 · 370 in bank

   HOTSPOT - You have an Azure Data Lake Storage account that contains CSV files. The CSV files contain sales order data and are partitioned by using the following format. /data/salesorders/year=xxxx/month=y You need to retrieve only the sales orders from January 2023 and February 2023. How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   SELECT r.filepath() AS filepath ,r.filepath(1) AS [year] ,r.filepath(2) AS [month] ,COUNT_BIG(*) AS [rows] FROM OPENROWSET( BULK 'csv/taxi/yellow_tripdata_*-*.csv', DATA_SOURCE = 'SqlOnDemandDemo', FORMAT = 'CSV', PARSER_VERSION = '2.0', FIRSTROW = 2 ) WITH ( vendor_id INT ) AS [r] WHERE r.filepath(1) IN ('2017') AND r.filepath(2) IN ('10', '11', '12') GROUP BY r.filepath() ,r.filepath(1) ,r.filepath(2) ORDER BY filepath;

   Source: Adapted from community discussion — CezarioAbrantesPP

   References

   • Microsoft Learn

   

   Next question

9. Question 19 · 370 in bank

   HOTSPOT - You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named adlsv2. adlsv2 contains a container named logs and an Azure Synapse Analytics dedicated SQL pool named Sqlpool. You plan to use PolyBase to load external data into Sqlpool. You need to define the external data source. How should you complete the script? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   

   Next question

10. Question 20 · 370 in bank

    You are developing a solution that will stream to Azure Stream Analytics. The solution will have both streaming data and reference data. Which input type should you use for the reference data?

    • AAzure Service Bus
    • BAzure Blob storage
    • CAzure IoT Hub
    • DAzure Event Hubs

    Show answer

    Answer: B

    Explanation

    Azure Stream Analytics supports reference data from Azure Blob Storage, and the reference data is typically stored in CSV, JSON, or Parquet format.

    Source: Adapted from community discussion — Pey1nkh

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-203 practice, question 11. 370 questions available.