Q1.Select the most appropriate term to correctly complete the following statement.
A JSON document is an example of （ ）.
Show answer
A JSON document is made up of key-value pairs and has a certain amount of structure, but its rows and columns are not strictly fixed.
Data with these characteristics is called semi-structured data.
Whereas structured data has a strict schema (column definitions) like a relational database, JSON allows the items to differ from one record to another.
Unstructured data, on the other hand, refers to data with no data structure at all, such as images, video, or free-form text.
Therefore, JSON is classified as semi-structured data.
Model semi-structured data
Q2.Match each Azure service to the requirement it satisfies.
Drag each option to the matching requirement’s drop zone, or tap to place it. Click a filled zone to send it back. (The same option may be used more than once.)
Azure Data Lake Storage
Azure SQL Database
Azure Synapse Analytics
Show answer
Azure Data Factory is a service that handles data extract, transform, and load (ETL/ELT), and you can specify Parquet as the output format.
Azure Data Lake Storage is well suited to storing Parquet files at large scale, and is used as a data lake foundation for analytics.
In addition, Azure Synapse Analytics provides a table representation of the Parquet data on the data lake using external tables and SQL, enabling analytical processing.
Azure SQL Database, by contrast, is a relational database that stores structured data in rows and columns, and is not suited to working with Parquet files directly.
Parquet format in Azure Data Factory and Azure Synapse Analytics
What is Azure Data Factory?
Introduction to Azure Data Lake Storage
Use external tables with Synapse SQL
Q3.Select the option that correctly completes the following statement.
Typical examples of aggregate functions in a SQL statement are （ ）.
Show answer
Aggregate functions in SQL are functions that combine data from multiple rows and return a single value.
Typical examples include MAX, which returns the maximum value, MIN, which returns the minimum, COUNT, which counts rows, SUM, which totals values, and AVG, which computes the average.
FROM, WHERE, ORDER BY, GROUP BY, JOIN, and MERGE are all clauses or statements, not functions.
Therefore, the examples that qualify as aggregate functions are MAX and MIN.
Aggregate Functions (Transact-SQL)
Q4.Which file format defines a name and data type for each column and uses compressed, column-oriented (columnar) storage?
Show answer
Apache Parquet is a file format that uses column-oriented (columnar) storage, and it clearly defines a name and data type (schema) for each column.
Because it stores and compresses data column by column, it achieves a high compression ratio and fast analytical queries, and is widely used in analytics platforms such as data lakes and data warehouses.
CSV is row-oriented and carries no type information, while JSON is semi-structured data and is not columnar.
HTML is markup for display.
Therefore, the format that meets the requirements is Parquet.
Read Parquet files using Azure Databricks
Q5.Select the term that correctly completes the following statement.
The pipeline engine used by Azure Data Factory is also available in （ ）.
Show answer
The pipeline engine used by Azure Data Factory (ADF) is also available in Azure Synapse Analytics.
Synapse combines data integration (equivalent to the former Data Factory) and analytics (SQL / Spark) in a single workspace, and Synapse Pipelines shares the same engine as ADF.
Therefore, the design concepts and capabilities of pipelines built in ADF can be used directly in Synapse.
Azure Databricks and HDInsight, by contrast, are processing platforms, and Azure SQL Database is a data store; none of them are services that use the ADF pipeline engine itself.
What is Azure Synapse Analytics?
Q6.Select the term that correctly completes the following statement.
When you use Azure Cosmos DB for Apache Gremlin, the resource type called a container is projected as （ ）.
Show answer
Azure Cosmos DB for Apache Gremlin is an API that provides a graph data model.
When you use this API, a Cosmos DB container is projected as a graph, and data is represented with nodes (vertices) and edges (relationships).
The Gremlin query language specializes in traversing the relationships between vertices, and does not treat the data as a table or a document.
A partition key is a concept for scaling, not a resource type.
Therefore, the correct answer is a graph.
What is Azure Cosmos DB for Apache Gremlin?
Databases, containers, and items in Azure Cosmos DB
Q7.A manufacturing company is designing a data store for internet-connected temperature sensors.
The collected data will be used to analyze temperature changes and trends over time.
Which type of data store should be adopted for this purpose?
Show answer
Data collected from internet-connected temperature sensors is numeric data generated continuously as time passes.
Because the main goal is to analyze the relationship between the timestamp and the measured value, it is best handled as time-series data.
A time-series data store is strong at trend analysis, capturing seasonality, and anomaly detection, and is widely used to analyze sensor and IoT data.
Relational and columnar stores are for general-purpose analytics, and graph is for relationship analysis, so neither is optimal for this scenario.
Design a database architecture
Q8.You are about to deploy a Software as a Service (SaaS) application that requires a relational database for online transaction processing (OLTP).
Which Azure service should you choose as the foundation to support this application?
Show answer
For a SaaS application that requires a relational database for online transaction processing (OLTP), Azure SQL Database is the best choice.
Azure SQL Database is a fully managed relational database service optimized for transaction processing, and it supports high concurrency, low latency, and ACID transactions.
It also has backup, high availability, and scaling built in, and is widely used as the foundation for SaaS applications.
Azure Cosmos DB is for NoSQL, and Azure Synapse Analytics and HDInsight are for analytics, so they are not suited to OLTP workloads.
What is Azure SQL Database?
Online transaction processing (OLTP)
Q9.Select the term that correctly completes the following statement.
Using the （ ） feature of Microsoft Power BI, you can create precisely formatted, fixed-layout reports optimized for printing and archiving.
Show answer
A paginated report in Microsoft Power BI lets you create fixed-layout reports optimized for printing and archiving.
You can strictly control page size, margins, and page-break positions, and the layout is preserved even when exported to PDF or Word.
Interactive reports and dashboards emphasize on-screen interaction and exploration, so they use a flexible layout that adapts to the display size.
A paginated report, by contrast, is suited to producing high-volume tabular output and standardized reports, which matches the requirement in this question.
What are paginated reports in Power BI?
Q10.Compared with Azure SQL Database, which is an advantage of hosting a database in Azure SQL Managed Instance?
Show answer
Azure SQL Managed Instance is a PaaS service with high compatibility with on-premises SQL Server, and it natively supports cross-database queries and transactions across multiple databases within the same instance.
In Azure SQL Database (single database / elastic pool), by contrast, direct queries and transactions across databases are generally restricted.
Options A (automatic backup), B (high availability), and D (encryption at rest) are also provided as standard in Azure SQL Database, so they are not advantages unique to Managed Instance.
Therefore, the most appropriate advantage is C.
What is Azure SQL Managed Instance?