Microsoft DP-300 Exam - Topic 5 Question 47 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 47
Topic #: 5

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 Synapse Analytics dedicated SQL pool that contains a table named Table1.

You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.

You plan to insert data from the files into Table1 and transform the dat

a. Each row of data in the files will produce one row in the serving layer of Table1.

You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.

Solution: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files.

Does this meet the goal?

AYes

BNo

Show Suggested Answer

Suggested Answer: B

Instead use a serverless SQL pool to create an external table with the extra column.

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables

by Casie at May 05, 2022, 08:47 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sharan

4 months ago

I agree, but what about time zone issues?

upvoted 0 times

...

Trina

4 months ago

Definitely a good approach for tracking!

upvoted 0 times

...

Casie

4 months ago

Wait, can you really get the DateTime like that?

upvoted 0 times

...

Malika

5 months ago

I don't think that's enough for the goal.

upvoted 0 times

...

Georgeanna

5 months ago

Yes, that makes sense!

upvoted 0 times

...

Markus

5 months ago

I’m uncertain about this one. I thought we needed to use a Copy Data activity to actually load the data along with the DateTime.

upvoted 0 times

...

Alexia

5 months ago

I feel like we might need an additional step after getting the metadata to actually insert the DateTime into the table.

upvoted 0 times

...

Louvenia

5 months ago

This seems similar to a practice question where we had to ensure data was transformed correctly. I think just getting the metadata might not be enough for the goal.

upvoted 0 times

...

Sue

5 months ago

I remember we discussed using Get Metadata to retrieve file properties, but I'm not sure if it actually inserts the DateTime into Table1.

upvoted 0 times

...

Pa

5 months ago

Hmm, I'm not sure about this one. I'll have to think it through carefully. Maybe I should review my notes on contract types again.

upvoted 0 times

...

Art

5 months ago

Okay, let's see. The question is asking about the best account model to associate the residence hall address to the international student. I'm thinking Person Account might be the way to go, since it's focused on individual contacts.

upvoted 0 times

...

Cammy

5 months ago

I think I remember that in some states, pharmacists need to get the prescriber's approval before substituting generics.

upvoted 0 times

...

Armanda

5 months ago

I remember practicing a question about fractional factorials, and this kind of seems similar, but I can't recall the differences clearly.

upvoted 0 times

...