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

Free DP-203 Exam Braindumps (page: 29)

Page 28 of 94
PDF with 397 Questions

You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool.
You execute the following query.



Where will the rows returned by the query be stored?

  1. in a file in a data lake
  2. in a relational database
  3. in a global temporary table
  4. in a session temporary table

Answer(s): A



You are deploying a lake database by using an Azure Synapse database template.

You need to add additional tables to the database. The solution must use the same grouping method as the template tables.

Which grouping method should you use?

  1. partition style
  2. business area
  3. size
  4. facts and dimensions

Answer(s): B



You have an Azure data factory connected to a Git repository that contains the following branches:

•main: Collaboration branch
•abc: Feature branch
•xyz: Feature branch

You save changes to a pipeline in the xyz branch.

You need to publish the changes to the live service.

What should you do first?

  1. Publish the data factory.
  2. Create a pull request to merge the changes into the main branch.
  3. Create a pull request to merge the changes into the abc branch.
  4. Push the code to a remote origin.

Answer(s): B



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 enable Git integration for ADF1.

Does this meet the goal?

  1. Yes
  2. No

Answer(s): A






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

Exam Discussions & Posts