Exam DP-203 topic 1 question 113 discussion

Actual exam question from Microsoft's DP-203

Question #: 113
Topic #: 1

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?

A. 1
B. 2
C. 3
D. 4

Show Suggested Answer

Suggested Answer: C 🗳️

by JamieMcD at June 3, 2024, 7:47 a.m.

Comments

Submit Cancel

JamieMcD

Highly Voted 1 year ago

C - With a full fidelity schema, the analytical store will track both the data and their types accurately. This means different types for the same field will be stored in separate columns. Specifically: There will be one column for customerID as an integer. There will be another column for customerID as a string. There will be one column for customer as a string.

upvoted 10 times

Sr18

1 year ago

Answer C

upvoted 1 times

...

Sleuth

1 year ago

The above explained is correct answer must be C. 3. 12 and "14" being different datatypes will have separate columns in full fidelity schema.

upvoted 3 times

...

shinypriti23

Most Recent 6 months, 2 weeks ago

Selected Answer: C

Total Columns: customerID_Number: For the Integer type in the first document. customerID_String: For the String type in the second document. customer_String: For the consistent String type. Total columns = 3

upvoted 1 times

...

Okea

7 months, 1 week ago

Spark will manage each datatype as a column when loading into a DataFrame https://learn.microsoft.com/en-us/azure/cosmos-db/analytical-store-introduction

upvoted 1 times

...

17c5d1e

7 months, 3 weeks ago

Whats the actual answer? I thought B as two columns will be there, CustomerID and Customer. But I guess that C could be right as a third column is added for the Text "14" ??

upvoted 1 times

...

NAWRESS96

10 months, 1 week ago

Selected Answer: C

Because the customerID field appears with different data types (integer in the first and string in the second, the analytical store will treat these as separate columns to maintain the schema's fidelity.

upvoted 1 times

...

Danweo

11 months, 1 week ago

Selected Answer: C

C, a third column will be added for the change in datatype.

upvoted 1 times

...