FREE Data Engineering on Microsoft Azure (DP-203) Questions and Answers

Question 1

You are creating a container's folder structure for Azure Data Lake Storage Gen2.
Several services, such as Azure Databricks and Azure Synapse Analytics serverless SQL pools, will be used by users to query data. Subject area will secure the data. The majority of inquiries will contain information from the current month or year.
Which folder organization would you suggest supporting quick queries and streamlined folder security?

Accepted Answer

/{SubjectArea}/{DataSource}/{YYYY}/{MM}/{DD}/{FileData}_{YYYY}_{MM}_{DD}.csv

Answer

/{DD}/{MM}/{YYYY}/{SubjectArea}/{DataSource}/{FileData}_{YYYY}_{MM}_{DD}.csv

Answer

/{SubjectArea}/{DataSource}/{DD}/{MM}/{YYYY}/{FileData}_{YYYY}_{MM}_{DD}.csv

Answer

/{YYYY}/{MM}/{DD}/{SubjectArea}/{DataSource}/{FileData}_{YYYY}_{MM}_{DD}.csv

Question 2

You must create a specific SQL pool for Azure Synapse Analytics that complies with the following criteria:
✑ can provide a record of an employee from a specific time.
✑ keeps up with employee details.
✑ reduces the complexity of the query.
How should the personnel data be modeled

Accepted Answer

as a Type 2 slowly changing dimension (SCD) table

Answer

as a SQL graph table

Answer

as a degenerate dimension table

Answer

as a temporal table

Question 3

Your Azure Data Lake Storage Gen2 account is corporate-wide. The only way to reach the data lake in Azure is through the virtual network VNET1.
In Azure Synapse, you are creating a SQL pool that will take advantage of the data lake.
Your business has a sales force. The Sales group in Azure Active Directory contains each and every member of the sales team. The Sales group is given access to the files in the data lake through POSIX controls.
Every hour, you intend to load data into the SQL pool.
The SQL pool has to be able to load the sales data from the data lake.
What steps should you take?

Accepted Answer

All of the above

Answer

Create a managed identity

Answer

Add the managed identity to the Sales group

Answer

Use the managed identity as the credentials for the data load process

Question 4

100 TB of data are present in an Azure Data Lake Storage Gen2 container that you have.
If there is a problem with the primary region, you must make sure that the data in the container is accessible for read workloads in a backup region. The answer must reduce expenses.
What kind of data redundancy ought to you employ?

Accepted Answer

read-access geo-redundant storage (RA-GRS)

Answer

locally-redundant storage (LRS)

Answer

geo-redundant storage (GRS)

Answer

zone-redundant storage (ZRS)

Question 5

You want to set up a Gen 2 storage account for Azure Data Lake.
You must make sure that the data lake will still be accessible if a data center in the main Azure region fails. The answer must reduce expenses.
Which replication type ought to be applied to the storage account?

Accepted Answer

zone-redundant storage (ZRS)

Answer

locally-redundant storage (LRS)

Answer

geo-zone-redundant storage (GZRS)

Answer

geo-redundant storage (GRS)

Question 6

In a special SQL pool for Azure Synapse Analytics, you create a data warehouse.
To modify data for use in inventory reports, analysts create an intricate SELECT query that includes numerous JOIN and CASE expressions. Depending on the report, the inventory reports will use the data and extra WHERE parameters. Once every day, the reports will be generated.
You must put a plan in place to make the dataset accessible for reporting. The answer must reduce query times.
What actions should you take?

Accepted Answer

a materialized view

Answer

a replicated table

Answer

result set caching

Answer

an ordered clustered columnstore index

Question 7

You have an Apache Spark pool called Pool1 in your WS1 Azure Synapse Analytics workspace.
You want to set up a database in Pool1 called DB1.
You must make sure that when tables are created in DB1, they become instantly accessible to the internal serverless SQL pool as external tables.
Which format ought to be applied to the DB1 tables?

Accepted Answer

Parquet

Answer

CSV

Answer

ORC

Answer

JSON