CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-203

Free DP-203 Exam Braindumps (page: 22)

Page 21 of 94
PDF with 397 Questions

You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named account1 and an Azure Synapse Analytics workspace named workspace1.

You need to create an external table in a serverless SQL pool in workspace1. The external table will reference CSV files stored in account1. The solution must maximize performance.

How should you configure the external table?

  1. Use a native external table and authenticate by using a shared access signature (SAS).
  2. Use a native external table and authenticate by using a storage account key.
  3. Use an Apache Hadoop external table and authenticate by using a shared access signature (SAS).
  4. Use an Apache Hadoop external table and authenticate by using a service principal in Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra.

Answer(s): A



HOTSPOT (Drag and Drop is not supported)
You have an Azure Synapse Analytics serverless SQL pool that contains a database named db1. The data model for db1 is shown in the following exhibit.



Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the exhibit.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



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

Answer(s): C



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

Answer(s): A






Post your Comments and Discuss Microsoft DP-203 exam with other Community members:

DP-203 Exam Discussions & Posts