DP-203 practice questions 351–360

1. Question 351 · 370 in bank

   You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to monitor Pool1. The solution must ensure that you capture the start and end times of each query completed in Pool1. Which diagnostic setting should you use?

   • ASql Requests
   • BRequest Steps
   • CDms Workers
   • DExec Requests

   Show answer

   Answer: D

   Explanation

   D seems correct, I was wondering if B could also be correct but apparently it only gives start and end times for the steps of a query and not for the query itself. Following link for reference : https://learn.microsoft.com/en-us/azure/azure-monitor/reference/supported-logs/microsoft-synapse-workspaces-sqlpools-logs

   Source: Adapted from community discussion — [Removed]

   References

   • Microsoft Learn

   Next question

2. Question 352 · 370 in bank

   Select 2

   You have an Azure Stream Analytics job named Job1. The metrics of Job1 from the last hour are shown in the following table.

   

   The late arrival tolerance for Job1 is set to five seconds. You need to optimize Job1. Which two actions achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

   • AIncrease the number of SUs.
   • BParallelize the query.
   • CResolve errors in output processing.
   • DResolve errors in input processing.

   Show answer

   Answer: AB

   Next question

3. Question 353 · 370 in bank

   You have an Azure subscription that contains an Azure data factory named ADF1 and a Log Analytics workspace named Workspace1. You need to configure ADF1 to send execution information for pipelines to Workspace1. What should you configure?

   • Adiagnostic settings
   • Bmetrics
   • Clogs
   • Dalerts

   Show answer

   Answer: A

   Explanation

   To send execution information (such as activity runs, pipeline runs, and trigger runs) from Azure Data Factory (ADF) to a Log Analytics workspace, you need to configure diagnostic settings in Azure Data Factory. Diagnostic settings allow you to stream logs and metrics to external services such as Log Analytics, Event Hub, or Azure Storage for monitoring and analysis.

   Source: Adapted from community discussion — aca357f

   Next question

4. Question 354 · 370 in bank

   You have an Azure Blob storage account named storage1 and an Azure Synapse Analytics serverless SQL poo1 named Pool1. From Pool1, you plan to run ad-hoc queries that target storage1. You need to ensure that you can use shared access signature (SAS) authorization without defining a data source. What should you create first?

   • Aa stored access policy
   • Ba server-level credential
   • Ca managed identity
   • Da database scoped credential

   Show answer

   Answer: D

   Explanation

   D. a database scoped credential When querying Azure Blob Storage (storage1) from Azure Synapse Analytics serverless SQL pool (Pool1) using Shared Access Signature (SAS) authorization, you need a way for Synapse to authenticate to the storage without explicitly defining a data source. To achieve this, you must: Create a database-scoped credential that stores the SAS token. Use OPENROWSET or external tables to query the data.

   Source: Adapted from community discussion — imatheushenrique

   Next question

5. Question 355 · 370 in bank

   You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1. Several users execute ad hoc queries to DW1 concurrently. You regularly perform automated data loads to DW1. You need to ensure that the automated data loads have enough memory available to complete quickly and successfully when the adhoc queries run. What should you do?

   • AHash distribute the large fact tables in DW1 before performing the automated data loads.
   • BAssign a smaller resource class to the automated data load queries.
   • CAssign a larger resource class to the automated data load queries.
   • DCreate sampled statistics for every column in each table of DW1.

   Show answer

   Answer: C

   Explanation

   Assigning a larger resource class to the automated data load queries prioritizes their resource allocation, allowing them to complete without being heavily impacted by the concurrent ad hoc queries. This helps avoid contention and ensures that the data loads can utilize the necessary resources to complete successfully.

   Source: Adapted from community discussion — vctrhugo

   References

   • Microsoft Learn

   Next question

6. Question 356 · 370 in bank

   You have an Azure subscription that contains an Azure Synapse Analytics workspace named Workspace1, a Log Analytics workspace named Workspace2, and an Azure Data Lake Storage Gen2 container named Container1. Workspace1 contains an Apache Spark job named Job1 that writes data to Container1. Workspace1 sends diagnostics to Workspace2. From Synapse Studio, you submit Job1. What should you use to review the LogQuery output of the job?

   • Athe files in the result subfolder of Container1
   • Bthe Spark monitoring URL returned after Job1 is submitted
   • Ca table in Workspace2
   • Dthe Apache Spark applications option on the Monitor tab

   Show answer

   Answer: D

   Explanation

   Within Synapse Studio Monitoring, you can check the Spark Application logs under Monitor → Apache Spark applications. Defintely not A: This would contain output data, not log queries or diagnostic logs. Not B: There is returned URL that provides live monitoring but is not the best choice for reviewing past logs after execution. Not C: While Log Analytics in Workspace2 stores logs, there is no direct "table" for Spark logs without running KQL queries manually.

   Source: Adapted from community discussion — EnigmaOracle

   Next question

7. Question 357 · 370 in bank

   You have an Azure subscription that contains an Azure Data Lake Storage Gen2 container named Container1 and an Azure Synapse Analytics workspace named Workspace1. Workspace1 contains multiple Apache Spark jobs that reference a large dataset in Container1. You need to optimize the run times of the jobs. What should you do?

   • AFor Container1, disable hierarchical namespaces.
   • BCache the dataset.
   • CIncrease the spark.sql.autoBroadcastJoinThreshold value.
   • DUse Resilient Distributed Datasets (RDDs).

   Show answer

   Answer: B

   Next question

8. Question 358 · 370 in bank

   HOTSPOT - You need to collect application metrics, streaming query events, and application log messages for an Azure Databrick cluster. Which type of library and workspace should you implement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   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

   You can send application logs and metrics from Azure Databricks to a Log Analytics workspace. It uses the Azure Databricks Monitoring Library, which is available on GitHub. Reference: https://docs.microsoft.com/en-us/azure/architecture/databricks-monitoring/application-logs

   References

   • Microsoft Learn

   

   Next question

9. Question 359 · 370 in bank

   HOTSPOT - You need to design a data storage structure for the product sales transactions. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   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: Hash - Scenario: Ensure that queries joining and filtering sales transaction records based on product ID complete as quickly as possible. A hash distributed table can deliver the highest query performance for joins and aggregations on large tables. Box 2: Set the distribution column to the sales date. Scenario: Partition data that contains sales transaction records. Partitions must be designed to provide efficient loads by month. Boundary values must belong to the partition on the right. Reference: https://rajanieshkaushikk.com/2020/09/09/how-to-choose-right-data-distribution-strategy-for-azure-synapse/

   Source: Adapted from community discussion — Julia01

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

10. Question 360 · 370 in bank

    DRAG DROP - You need to ensure that the Twitter feed data can be analyzed in the dedicated SQL pool. The solution must meet the customer sentiment analytics requirements. Which three Transact-SQL DDL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. 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

    Scenario: Allow Contoso users to use PolyBase in an Azure Synapse Analytics dedicated SQL pool to query the content of the data records that host the Twitter feeds. Data must be protected by using row-level security (RLS). The users must be authenticated by using their own Azure AD credentials. Box 1: CREATE EXTERNAL DATA SOURCE External data sources are used to connect to storage accounts. Box 2: CREATE EXTERNAL FILE FORMAT CREATE EXTERNAL FILE FORMAT creates an external file format object that defines external data stored in Azure Blob Storage or Azure Data Lake Storage. Creating an external file format is a prerequisite for creating an external table. Box 3: CREATE EXTERNAL TABLE AS SELECT When used in conjunction with the CREATE TABLE AS SELECT statement, selecting from an external table imports data into a table within the SQL pool. In addition to the COPY statement, external tables are useful for loading data. Incorrect Answers: CREATE EXTERNAL TABLE - The CREATE EXTERNAL TABLE command creates an external table for Synapse SQL to access data stored in Azure Blob Storage or Azure Data Lake Storage. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables

    Source: Adapted from community discussion — AzureJobsTillRetire

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    

    Next question

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

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