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: 31)

Page 30 of 94
PDF with 397 Questions

DRAG DROP (Drag and Drop is not supported)
You have an Azure Synapse Analytics dedicated SQL pool named SQL1 that contains a hash-distributed fact table named Table1.

You need to recreate Table1 and add a new distribution column. The solution must maximize the availability of data.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



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 disable all the triggers for ADF1.

Does this meet the goal?

  1. Yes
  2. No

Answer(s): B



You have an Azure subscription that contains the resources shown in the following table.



You need to implement Azure Synapse Link for Azure SQL Database.

Which two actions should you perform on sql1? Each correct answer presents a part of the solution.
NOTE: Each correct selection is worth one point.

  1. Update the firewall rules to allow Azure services to access sql1.
  2. Enable the system-assigned managed identity.
  3. From the Access control (IAM) settings, assign the Contributor role to the system-assigned managed identity of workspace1.
  4. Disable Transparent Data Encryption (TDE).

Answer(s): A,B



You have an Azure subscription that contains an Azure Cosmos DB database. Azure Synapse Link is implemented on the database.

You configure a full fidelity schema for the analytical store.

You perform the following actions:

•Insert {"customerID": 12, "customer": “Tailspin Toys"} as the first document in the container.
•Insert {"customerID": "14", "customer": "Contoso"} as the second document in the container.

How many columns will the analytical store contain?

  1. 1
  2. 2
  3. 3
  4. 4

Answer(s): C






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

Exam Discussions & Posts