ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 1 question 99 discussion

Actual exam question from Microsoft's DP-203
Question #: 99
Topic #: 1
[All DP-203 Questions]

You have an Azure Synapse Analytics workspace.

You plan to deploy a lake database by using a database template in Azure Synapse.

Which two elements are included in the template? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

  • A. relationships
  • B. data formats
  • C. linked services
  • D. table permissions
  • E. table definitions
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
by metiii at Nov. 6, 2023, 12:45 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
metiii
Highly Voted 1 year ago
Selected Answer: AE
Correct, AE. Only table definition and their relationship is included in the template. The rest of the options should be configured Ref: https://learn.microsoft.com/en-us/azure/synapse-analytics/database-designer/create-lake-database-from-lake-database-templates
upvoted 9 times
moneytime
9 months, 2 weeks ago
Please can you explain this part of the template requirements. Prerequisites At least Synapse User role permissions are required for exploring a lake database template from Gallery. Synapse Administrator, or Synapse Contributor permissions are required on the Synapse workspace for creating a lake database. Storage Blob Data Contributor permissions are required on data lake when using the create table From data lake option. .I copied directly from the link you dropped .
upvoted 1 times
...
...
Dusica
Most Recent 6 months, 2 weeks ago
B and E 100% Relationships you have to define
upvoted 2 times
...
Dusica
6 months, 3 weeks ago
B E ; relationships have to be added in the designer after tables are added
upvoted 2 times
...
Charley92
9 months, 2 weeks ago
Selected Answer: AE
According to the Microsoft Learn documentation1, a lake database template in Azure Synapse includes the following elements: Table definitions: These are the schemas for the tables that store the data in the lake database. They include the table name, column names, data types, and descriptions. Relationships: These are the associations between the tables that define how they are related to each other. They include the primary and foreign keys, cardinality, and referential integrity rules. Data formats: These are the specifications for how the data is stored and accessed in the lake database. They include the file format, compression type, delimiter, encoding, and schema inference options. Therefore, the correct answers are A and E.
upvoted 1 times
...
ELJORDAN23
10 months ago
Selected Answer: AE
Correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago