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 require a predefined schema.
Key/value stores do not support complex queries or joins.
Relational databases are designed for structured data.
Question 70
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: Database administrators apply data cleansing routines and turn data into useful information.
No
Data engineers manage databases, store backup copies of data, and restore data in the event of a failure.
No
Data analysts create data visuals and enable companies to make data-driven decisions.
Yes
Explanation: Data cleansing and turning data into insights is primarily a data analyst role, not a DBA. Database management, backups, and recovery are DBA responsibilities, not data engineers. Creating visualizations and supporting data-driven decisions is a core responsibility of data analysts.
Question 71
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: pre-aggregated
Explanation: OLAP systems store data in aggregated forms (e.g., cubes) so analytical queries can be answered quickly without performing heavy calculations at query time.
Question 72
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 supports multiple APIs, each optimized for a specific data model. The Gremlin API is designed specifically for graph databases, supporting vertices, edges, and graph traversal queries. The Table, Cassandra, and NoSQL (Core/SQL) APIs are not intended for graph data models.
Question 73
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Microsoft Power BI Desktop
Explanation: Power BI Desktop provides the complete set of data modeling, transformation, and report editing features, unlike the service or mobile app.
Question 74
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 models and reports, and publishing makes them available online for sharing and collaboration through the cloud-based Power BI service.
Question 75
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: keys
Explanation: Relational databases use primary and foreign keys to define and enforce relationships between tables.
Question 76
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: dimensions
Explanation: In a star schema, measures (facts) are analyzed by slicing or aggregating them using descriptive entities called dimensions, such as time, product, or customer.
Question 77
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: structured data
Explanation: Relational databases use predefined schemas with tables, rows, and columns, which are designed to store and query structured data efficiently.
Question 78
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
No
Explanation: Azure File Storage is created within a storage account. Premium Azure Files uses SSD-based hardware, not HDDs. Standard Azure Files is backed by HDD-based storage, not SSDs.
$19
Get all 282 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.
