Exam DP-203 topic 2 question 89 discussion

Actual exam question from Microsoft's DP-203

Question #: 89
Topic #: 2

You are designing a folder structure for the files in an Azure Data Lake Storage Gen2 account. The account has one container that contains three years of data.
You need to recommend a folder structure that meets the following requirements:
✑ Supports partition elimination for queries by Azure Synapse Analytics serverless SQL pools
✑ Supports fast data retrieval for data from the current month
✑ Simplifies data security management by department
Which folder structure should you recommend?

A. \Department\DataSource\YYYY\MM\DataFile_YYYYMMDD.parquet
B. \DataSource\Department\YYYYMM\DataFile_YYYYMMDD.parquet
C. \DD\MM\YYYY\Department\DataSource\DataFile_DDMMYY.parquet
D. \YYYY\MM\DD\Department\DataSource\DataFile_YYYYMMDD.parquet

Show Suggested Answer

Suggested Answer: A 🗳️

by anks84 at Sept. 7, 2022, 1:19 a.m.

Comments

Submit Cancel

anks84

Highly Voted 2 years, 3 months ago

Selected Answer: A

Answer is Correct !

upvoted 9 times

...

dmitriypo

Highly Voted 2 years, 1 month ago

Selected Answer: A

Of course A

upvoted 5 times

...

Dusica

Most Recent 7 months, 2 weeks ago

Partition elimination > date is the main here so it is D

upvoted 1 times

...

kkk5566

1 year, 3 months ago

Selected Answer: A

A is correct

upvoted 1 times

...

auwia

1 year, 5 months ago

Selected Answer: B

The raw zone may be organised by source system, then entity. Here is an example folder structure, optimal for folder security: \Raw\DataSource\Entity\YYYY\MM\DD\File.extension Typically each source system will be granted write permissions at the DataSource folder level with default ACLs (see section on ACLs below) specified. This will ensure permissions are inherited as new daily folders and files are created. Whilst many use time based partitioning there are a number of options which may provide more efficient access paths. ->this justify the YYYYMM to get easily the current month. Correct answer for me is B.

upvoted 4 times

MarkJoh

1 year ago

Except is contradicts the requirement "Simplifies data security management by department". You need minimum (#DataSource) * (#Department) ACLs with option B Whereas with option A, you need just minimum #Department ACLs. Also, Option A allows you to have additional datasource specific ACLs within a particular department, if that is so desired.

upvoted 1 times

...

rzeng

2 years, 1 month ago

A is right

upvoted 4 times

...