NEW
Font size
WorksheetsDP 203 M1
Total questions: 10
Worksheet time: 5mins
Which type of analytics answers the question “What is likely to happen in the future based on previous trends and patterns?
Descriptive.
Diagnostic.
Predictive.
You have a requirement to occasionally prepare data for ad hoc data exploration and analysis. Which resource model in Azure Synapse Analytics is the most effective to use to meet this requirement?
Serverless.
Dedicated
Pipelines.
Where can you develop TSQL scripts and notebooks in Azure Synapse Analytics?
Azure portal
Azure Synapse Studio.
Data Lake.
What is a lambda architecture and what does it try to solve?
An architecture that defines a data processing pipeline whereby microservices act as compute resources
for efficient large-scale data processing
An architecture that splits incoming data into two paths - a batch path and a streaming path. This
architecture helps address the need to provide real-time processing in addition to slower batch
computations.
An architecture that employs the latest Scala runtimes in one or more Databricks clusters to provide
the most efficient data processing platform available today
What command should be issued to view the list of active streams?
What is required to specify the location of a checkpoint directory when defining a Delta Lake streaming query?
.writeStream.format("delta").checkpoint("location", checkpointPath) ...
.writeStream.format("delta").option("checkpointLocation", checkpointPath) ...
.writeStream.format("parquet").option("checkpointLocation", checkpointPath) ...
Mike is creating an Azure Data Lake Storage Gen2 account. He must configure this account to be able to process analytical data workloads for best performance. Which option should he configure when creating the storage account?
On the Basic tab, set the Performance option to Standard.
On the Basic Tab, set the Performance option to ON.
On the Advanced tab, set the Hierarchical Namespace to Enabled.
In which phase of big data processing is Azure Data Lake Storage located?
Ingestion
Store
Model & Serve
Which of the following technologies typically provide an ingestion point for data streaming in an event processing solution that uses static data as a source?
Azure IoT Hub
Azure Blob storage
Azure Event Hub
To consume processed event streaming data in near-real-time to produce dashboards containing rich visualizations, which of the following services should You use?
Azure Cosmos DB
Event Hubs
Power BI
