Free Microsoft DP-203 Exam Dumps Questions & Answers

You have an Azure subscription that contains a storage account. The account contains a blob container named blob1 and an Azure Synapse Analytics serverless SQL pool.
You need to query the CSV files stored in blob1. The solution must ensure that all the files in a folder named csv and all its subfolders are queried.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
A computer screen shot of a computer code Description automatically generated

BULK Path (first dropdown):
* Correct Option: abfs:
* Since the storage account uses Azure Data Lake Storage Gen2, the abfs:// (Azure Blob File System) protocol is the correct option for accessing the files.
Path to Query Files:
* The path 'abfs://[email protected]/blob1/' specifies the container (blob1) and the folder (csv) within the storage account.
* This ensures that all files in the csv folder and its subfolders are included in the query.
FORMAT (last dropdown):
* Correct Option: 'CSV'
* This indicates that the queried files are in the CSV format, which matches the requirement in the question.

You have an Azure Databricks workspace that contains a Delta Lake dimension table named Tablet. Table1 is a Type 2 slowly changing dimension (SCD) table. You need to apply updates from a source table to Table1.
Which Apache Spark SQL operation should you use?

• A.ALTER
• B.UPDATE
• C.MERGE
• D.CREATE

You use PySpark in Azure Databricks to parse the following JSON input.

You need to output the data in the following tabular format.

How should you complete the PySpark code? To answer, drag the appropriate values to he 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.

Correct Answer:

Explanation:

Box 1: select
Box 2: explode
Bop 3: alias
pyspark.sql.Column.alias returns this column aliased with a new name or names (in the case of expressions that return more than one column, such as explode).
Reference:
https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.Column.alias.html
https://docs.microsoft.com/en-us/azure/databricks/sql/language-manual/functions/explode

You build a data warehouse in an Azure Synapse Analytics dedicated SQL pool.
Analysts write a complex SELECT query that contains multiple JOIN and CASE statements to transform data for use in inventory reports. The inventory reports will use the data and additional WHERE parameters depending on the report. The reports will be produced once daily.
You need to implement a solution to make the dataset available for the reports. The solution must minimize query times.
What should you implement?

• A.result set chaching
• B.in ordered clustered columnstore index
• C.a materialized view
• D.a replicated table

You have an Azure subscription that contains the Azure Synapse Analytics workspaces shown in the following table.

Each workspace must read and write data to datalake1.
Each workspace contains an unused Apache Spark pool.
You plan to configure each Spark pool to share catalog objects that reference datalakel For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

Correct Answer:

Explanation: