Which language is used to define queries in Azure Synapse Data Explorer?
A. Bash
B. PowerShell
C. KQL
D. SQL
Show Answer
Correct Answer: C
Explanation: Azure Synapse Data Explorer uses Kusto Query Language (KQL) to define and run queries. KQL is the native query language for Azure Data Explorer and Synapse Data Explorer, optimized for interactive analysis of large volumes of telemetry, log, and time-series data.
Question 52
HOTSPOT
-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Yes
No
Yes
Explanation: Relational databases use a predefined schema before inserting data. Key/value stores are optimized for simple key-based access, not multi-join queries. Relational databases are designed for structured data and SQL querying.
Question 53
HOTSPOT
-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: No
No
Yes
Explanation: DBAs manage databases, backups, and recovery. Data engineers build and maintain data pipelines, while data analysts create visualizations and support data-driven decisions.
Question 54
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: pre-aggregated.
Explanation: OLAP systems are optimized for analytical queries by storing data in aggregated forms (such as cubes/materialized aggregates), enabling fast analysis rather than transaction processing.
Question 55
Which Azure Cosmos DB API should you use for a graph database?
A. Table
B. Cassandra
C. NoSQL
D. Gremlin
Show Answer
Correct Answer: D
Explanation: Azure Cosmos DB provides multiple APIs for different data models. The Gremlin API is specifically designed for graph databases and supports the Apache TinkerPop Gremlin graph traversal language. Table is for key-value, Cassandra for wide-column, and NoSQL (Core/SQL) for document data.
Question 56
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Microsoft Power BI Desktop
Explanation: Power BI Desktop provides the full set of data modeling, transformation, and report authoring features. The Power BI service focuses on publishing, sharing, and collaboration, while the phone app is for viewing and interacting with reports.
Question 57
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: the Power BI service.
Explanation: Power BI Desktop is used to create data models and reports. You publish them to the Power BI service for sharing, collaboration, and online access.
Question 58
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: keys
Explanation: Relational databases enforce relationships between tables using primary keys and foreign keys. Rows are records, collections are NoSQL concepts, and partitions are for data distribution.
Question 59
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: dimensions
Explanation: In a star schema, measures are stored in fact tables and are analyzed, aggregated, and sliced by dimension tables (such as time, product, or customer).
Question 60
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: structured data
Explanation: Relational databases organize information into tables with predefined schemas, making them primarily suited for storing and querying structured data.
$19
Get all 284 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
