INGEST STREAMING DATA USING AZURE STREAM
ANALYTICS AND AZURE SYNAPSE ANALYTICS EXAM
What is the storage service typically included in an Azure Synapse Analytics
workspace? - ANSWER Data lake.
Where is the data lake commonly hosted? - ANSWER In an Azure Storage
account.
What is the most commonly used container configuration for Azure Data Lake
Storage Gen2? - ANSWER Azure Storage account.
How are files organized in the data lake? - ANSWER Hierarchically in directories
(folders).
What are the multiple file formats that can be used to store files in the data lake? -
ANSWER Delimited text (CSV), Parquet, and JSON.
What is Azure Stream Analytics? - ANSWER A service for real-time data
ingestion and processing.
What is a data lake? - ANSWER A storage repository that holds a vast amount of
raw data.
What is Azure Data Lake Gen2? - ANSWER A storage solution that combines the
capabilities of a data lake and a file system.
What is an output in Azure Stream Analytics? - ANSWER A location in Azure
Data Lake Gen2 where query results are saved.
How can data in a data lake be processed? - ANSWER By running code in an
Apache Spark pool or running SQL queries using a serverless SQL pool.
What are the two common approaches to large-scale data analytics? - ANSWER
Data warehouses and data lakes.
What is a data warehouse? - ANSWER A relational database optimized for
, distributed storage and query processing.
What is a data lake? - ANSWER Distributed file storage where data is stored as
files.
What are the runtimes that can be used to process and query data in a data lake? -
ANSWER Apache Spark and SQL.
What are dedicated SQL pools in Azure Synapse Analytics? - ANSWER
Enterprise-scale relational data warehouses based on MPP instance of Microsoft
SQL Server.
How is data stored and queried in dedicated SQL pools? - ANSWER Data is stored
and queried in tables using SQL.
What must an Azure Stream Analytics query do to ingest real-time data into a
relational data warehouse? - ANSWER Write its results to an output that references
the table where the data should be loaded.
What is the typical storage service used as a data lake in Azure Synapse Analytics?
- ANSWER Azure Storage account.
What is the most common configuration for the data lake in Azure Synapse
Analytics? - ANSWER Azure Data Lake Storage Gen2.
How are files organized in the data lake? - ANSWER Hierarchically in directories
(folders).
What are the file formats that can be used in the data lake? - ANSWER Delimited
text (e.g., CSV), Parquet, and JSON.
What is Azure Stream Analytics? - ANSWER A service for real-time data
ingestion and processing.
What is a data lake? - ANSWER A storage repository that holds a vast amount of
raw data.
What is Azure Data Lake Gen2? - ANSWER A storage solution that combines the
capabilities of a data lake and a file system.
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 luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.