Analytics and Azure Synapse Analytics
UPDATED Exam Questions and
CORRECT Answers
What is the storage service typically included in an Azure Synapse Analytics workspace? -
CORRECT ANSWER - Data lake.
Where is the data lake commonly hosted? - CORRECT ANSWER - In an Azure Storage
account.
What is the most commonly used container configuration for Azure Data Lake Storage Gen2? -
CORRECT ANSWER - Azure Storage account.
How are files organized in the data lake? - CORRECT ANSWER - Hierarchically in
directories (folders).
What are the multiple file formats that can be used to store files in the data lake? - CORRECT
ANSWER - Delimited text (CSV), Parquet, and JSON.
What is Azure Stream Analytics? - CORRECT ANSWER - A service for real-time data
ingestion and processing.
What is a data lake? - CORRECT ANSWER - A storage repository that holds a vast
amount of raw data.
What is Azure Data Lake Gen2? - CORRECT ANSWER - A storage solution that
combines the capabilities of a data lake and a file system.
, What is an output in Azure Stream Analytics? - CORRECT ANSWER - A location in
Azure Data Lake Gen2 where query results are saved.
How can data in a data lake be processed? - CORRECT 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? - CORRECT
ANSWER - Data warehouses and data lakes.
What is a data warehouse? - CORRECT ANSWER - A relational database optimized for
distributed storage and query processing.
What is a data lake? - CORRECT 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? - CORRECT
ANSWER - Apache Spark and SQL.
What are dedicated SQL pools in Azure Synapse Analytics? - CORRECT ANSWER -
Enterprise-scale relational data warehouses based on MPP instance of Microsoft SQL Server.
How is data stored and queried in dedicated SQL pools? - CORRECT 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? - CORRECT 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? - CORRECT
ANSWER - Azure Storage account.