DP-203 Practice Test

DP-203 Practice Test practice questions, page 16 of 16, with answer review and explanations.

Question 76

You have an Azure Databricks workspace and an Azure Data Lake Storage Gen2 account named storage1. New files are uploaded daily to storage1. You need to recommend a solution that configures storage1 as a structured streaming source. The solution must meet the following requirements: • Incrementally process new files as they are uploaded to storage1. • Minimize implementation and maintenance effort. • Minimize the cost of processing millions of files. • Support schema inference and schema drift. Which should you include in the recommendation?

  1. COPY INTO
  2. Azure Data Factory
  3. Auto Loader
  4. Apache Spark FileStreamSource

Question 77

You have an Azure subscription that contains the resources shown in the following table. You need to read the TSV files by using ad-hoc queries and the OPENROWSET function. The solution must assign a name and override the inferred data type of each column. What should you include in the OPENROWSET function?

  1. the WITH clause
  2. the ROWSET_OPTIONS bulk option
  3. the DATAFILETYPE bulk option
  4. the DATA_SOURCE parameter

Question 78

You have an Azure Synapse Analytics dedicated SQL pool. You plan to create a fact table named Table1 that will contain a clustered columnstore index. You need to optimize data compression and query performance for Table1. What is the minimum number of rows that Table1 should contain before you create partitions?

  1. 100,000
  2. 600,000
  3. 1 million
  4. 60 million

Question 79

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named DimSalesPerson. DimSalesPerson contains the following columns: • RepSourceID • SalesRepID • FirstName • LastName • StartDate • EndDate • Region You are developing an Azure Synapse Analytics pipeline that includes a mapping data flow named Dataflow1. Dataflow1 will read sales team data from an external source and use a Type 2 slowly changing dimension (SCD) when loading the data into DimSalesPerson. You need to update the last name of a salesperson in DimSalesPerson. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  1. Update three columns of an existing row.
  2. Update two columns of an existing row.
  3. Insert an extra row.
  4. Update one column of an existing row.