Exam (elaborations)
DP-203 Azure Data Engineer exam questions with correct answers
- Course
- Institution
DP-203 Azure Data Engineer exam questions with correct answers
[Show more]
Content preview
DP-203 Azure Data Engineer exam questionswith correct answers
What type of Databricks cluster can be created using the UI, CLI, or REST API and can be
x x x x x x x x x x x x x x x x x
manually terminated and restart? - ANSWER: ➡ all-purpose cluster
x x x x x x xx x x
What type of Databricks cluster is created by job scheduler when you run a job and is
x x x x x x x x x x x x x x x x
automatically terminated when the job is complete? - ANSWER: ➡ job cluster
x x x x x x x x x xx x x
What type of Databricks cluster consists of an Apache Spark driver and no Spark workers? -
x x x x x x x x x x x x x x x
ANSWER: ➡ single node cluster
x xx x x x
What type of Databricks cluster is recommended for a single user that can run workloads
x x x x x x x x x x x x x x
developed in Python, SQL, R, and Scala? - ANSWER: ➡ standard cluster
x x x x x x x x x xx x x
What type of Databricks cluster provides fine-grained sharing for maximum resource
x x x x x x x x x x
utilization and minimum query latencies? - ANSWER: ➡ high concurrency clusters
x x x x x x x xx x x x
What is a shell script that runs during startup of each cluster node before the Apache Spark
x x x x x x x x x x x x x x x x
driver or worker JVM starts? - ANSWER: ➡ init script
x x x x x x x xx x x
What is the distributed file systems mounted into an Azure Databricks workspace and
x x x x x x x x x x x x
available on Azure Databricks cluster? - ANSWER: ➡ Databricks File System (DBFS)
x x x x x x x xx x x x x
How to access data in an Azure Data Lake Gen2 (ADLS Gen2) account with Azure Databricks? -
x x x x x x x x x x x x x x x x
ANSWER: ➡ Use OAuth 2.0 with an Azure Active Directory (Azure AD) application service
x xx x x x x x x x x x x x x
principal for authentication
x x x
,What are the steps to creating an Azure AD application and service principal to mount or
x x x x x x x x x x x x x x x
directly access data in an ADLS Gen2 storage account? - ANSWER: ➡ 1. Create an Azure AD
x x x x x x x x x x x xx x x x x x
application (this will create an associated service principal used to access the storage account)
x x x x x x x x x x x x x x
2. Create an Azure Key Vault-backed secret scope. (the secret scope will securely store the
x x x x x x x x x x x x x x
client secret associated with the Azure AD application)
x x x x x x x x
3. Save the client secret associated with the Azure AD application in the Azure key vault
x x x x x x x x x x x x x x x
4. Assign roles to the application to provide the service principal with the required
x x x x x x x x x x x x x
permissions to access the ADLS Gen2 storage account
x x x x x x x x
5. Create one or more containers inside the storage account.
x x x x x x x x x
6. Authenticate and access the ADLS Gen2 storage account through a mount point or direct
x x x x x x x x x x x x x x
access
x
In which scenarios should you use Azure Stream Analytics? - ANSWER: ➡ 1. Dashboards for
x x x x x x x x x x xx x x x
data visualization
x x
2. Real-time alerts from temporal and spatial patterns or anomalies
x x x x x x x x x
3. Extract, Transform, Load (ETL)
x x x x
4. Event Sourcing pattern
x x x
5. IoT edge
x x
In which scenarios should you NOT use Azure Stream Analytics? - ANSWER: ➡ 1. You want to
x x x x x x x x x x x xx x x x x
write UDF, UDAs, and custom deserializers in a language other than JavaScript or C#
x x x x x x x x x x x x x x
2. Your solution is in a multi-cloud or on-premises environment
x x x x x x x x x
What Apache Spark API lets you express computation on streaming data in the same way you
x x x x x x x x x x x x x x x
express a batch computation on static data? - ANSWER: ➡ Structured Streaming
x x x x x x x x x xx x x
Which functions in Azure Stream Analytics can be used for anomaly detection? - ANSWER: ➡
x x x x x x x x x x x x x xx
1. AnomalyDetection_SpikeAndDip
x x x
2. AnomalyDetection_ChangePoint
x
, Which block blob storage tier has a minimum storage duration of 180 days and a latency in
x x x x x x x x x x x x x x x x
hours? - ANSWER: ➡ Archive tier
x x x xx x x
Which block blob storage tier has a minimum storage duration of 30 days and a latency in
x x x x x x x x x x x x x x x x
milliseconds? - ANSWER: ➡ Cool tier
x x x xx x x
Which block blob storage tier has no minimum storage duration and a latency in milliseconds?
x x x x x x x x x x x x x x
- ANSWER: ➡ Hot Tier
x x xx x x
Which block blob storage tier has no minimum storage duration and a latency in single-digit
x x x x x x x x x x x x x x
milliseconds? - ANSWER: ➡ Premium Performance Tier
x x x xx x x x
What are the two options for rehydrating a blob that is stored in the archive tier? - ANSWER: ➡
x x x x x x x x x x x x x x x x x xx
1. Copy an archived blob to an online tier: You can rehydrate an archived blob by copying it to a
x x x x x x x x x x x x x x x x x x x x
new blob in the hot or cool tier with the Copy Blob or Copy Blo from URL operation. (Microsoft
x x x x x x x x x x x x x x x x x x x
recommends this approach in most scenarios)
x x x x x x
2. Change a blob's access tier to an online tier: You can rehydrate an archived blob to hot or cool
x x x x x x x x x x x x x x x x x x x
by changing its tier using the Set Blob Tier operation
x x x x x x x x x x
What are the two Rehydration priority options - ANSWER: ➡ 1. Standard priority: the
x x x x x x x x xx x x x x
rehydration request will be processed in the order it was received and may take up to 15 hours
x x x x x x x x x x x x x x x x x x
2. High priority: The rehydration request will be prioritized over standard priority requests
x x x x x x x x x x x x
and may complete in under one hour for objects under 10 GB in size
x x x x x x x x x x x x x x
Which T-SQL statements allows you to specify both the distribution of the table data as well as
x x x x x x x x x x x x x x x x
the table structure type? - ANSWER: ➡ CTAS
x x x x x x xx x
What T-SQL statement allows you to create an external table in a dedicated SQL pool or
x x x x x x x x x x x x x x x
serverless SQL pool? - ANSWER: ➡ CETAS
x x x x x xx x
Which GROUP BY options are supported in dedicated SQL pool? - ANSWER: ➡ 1. GROUP BY
x x x x x x x x x x x xx x x x
with ROLLUP
x x
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Fordenken. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
74735 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now