You have an Azure Data Factory that contains 10 pipelines.
You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.
What should you add to each pipeline?

• A.a resource tag
• B.a correlation ID
• C.a run group ID
• D.an annotation

Comment: *

Name: *

Email: *

Verification: *

You develop data engineering solutions for a company.
A project requires the deployment of data to Azure Data Lake Storage.
You need to implement role-based access control (RBAC) so that project members can manage the Azure Data Lake Storage resources.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Assign Azure AD security groups to Azure Data Lake Storage.
• B.Configure end-user authentication for the Azure Data Lake Storage account.
• C.Configure service-to-service authentication for the Azure Data Lake Storage account.
• D.Create security groups in Azure Active Directory (Azure AD) and add project members.
• E.Configure access control lists (ACL) for the Azure Data Lake Storage account.

Comment: *

Name: *

Email: *

Verification: *

You are building an Azure Synapse Analytics dedicated SQL pool that will contain a fact table for transactions from the first half of the year 2020.
You need to ensure that the table meets the following requirements:
Minimizes the processing time to delete data that is older than 10 years Minimizes the I/O for queries that use year-to-date values How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-partition-function-transact-sql

Comment: *

Name: *

Email: *

Verification: *

You create an Azure Databricks cluster and specify an additional library to install.
When you attempt to load the library to a notebook, the library in not found.
You need to identify the cause of the issue.
What should you review?

• A.notebook logs
• B.cluster event logs
• C.global init scripts logs
• D.workspace logs

Comment: *

Name: *

Email: *

Verification: *

You are designing an Azure Synapse Analytics dedicated SQL pool.
You need to ensure that you can audit access to Personally Identifiable information (PII).
What should you include in the solution?

• A.dynamic data masking
• B.row-level security (RLS)
• C.sensitivity classifications
• D.column-level security

Comment: *

Name: *

Email: *

Verification: *