CCNA Describe core data concepts Questions — Page 4 of 4

226

MCQeasy

A company stores customer records in a relational table with columns like CustomerID, Name, and Email. Product reviews are stored as JSON documents, and marketing images are stored as PNG files. Which of the following correctly orders these data types from most structured to least structured?

A.A. Product reviews, Customer records, Marketing images

B.B. Customer records, Product reviews, Marketing images

C.C. Marketing images, Customer records, Product reviews

D.D. Customer records, Marketing images, Product reviews

AnswerB

Customer records in a relational table are strictly structured (fixed schema), product reviews as JSON are semi-structured (schema-on-read), and marketing images are unstructured (binary files). This is the correct order from most to least structured.

Why this answer

Customer records in a relational table have a fixed schema with defined columns (e.g., CustomerID, Name, Email), making them the most structured. Product reviews stored as JSON documents are semi-structured because they have a flexible schema with key-value pairs but no fixed columns. Marketing images as PNG files are unstructured binary data with no inherent schema.

Option B correctly orders these from most to least structured.

Exam trap

The trap here is that candidates often confuse semi-structured JSON with unstructured data, or assume that any file format (like PNG) has inherent structure, leading them to misorder the data types by perceived complexity rather than schema rigidity.

Why the other options are wrong

Product reviews as JSON documents are semi-structured, not more structured than relational customer records. The order should be from most structured (relational) to least structured (unstructured images), so customer records must come first.

Marketing images (unstructured binary files) are the least structured, not the most. Customer records (relational table) are most structured, followed by product reviews (semi-structured JSON), then images (unstructured).

Marketing images (PNG) are unstructured binary data, not more structured than JSON product reviews. The correct order is relational (most structured) > JSON (semi-structured) > images (unstructured).

Practice this question →

227

MCQhard

A multinational corporation needs to store archival data for 10 years with the lowest possible storage cost, while still being able to retrieve it within 24 hours if needed. Which Azure storage tier should they use?

A.Archive Blob Storage

B.Cool Blob Storage

C.Premium Blob Storage

D.Hot Blob Storage

AnswerA

Archive Blob Storage is the correct choice because it offers the lowest storage cost of any Azure Blob access tier, which aligns with the archival requirement. Data is stored offline without instant access, but the service supports rehydration within up to 15 hours—well within the stated 24-hour retrieval window. The latency is acceptable here because the workload prioritizes cost minimization over immediate availability.

Why this answer

Archive Blob Storage is the correct choice because it is designed for long-term retention of data that is rarely accessed, offering the lowest storage cost among Azure blob tiers. The 10-year retention requirement and 24-hour retrieval window align perfectly with Archive's capabilities, as data can be rehydrated to a hot or cool tier within hours (typically up to 15 hours for standard priority rehydration).

Exam trap

The trap here is that candidates often confuse 'lowest storage cost' with 'lowest overall cost' and overlook the retrieval time constraint, mistakenly choosing Cool Blob Storage because it offers lower cost than Hot but still allows immediate access, ignoring that Archive is even cheaper and meets the 24-hour retrieval window.

How to eliminate wrong answers

Option B (Cool Blob Storage) is wrong because it is optimized for data accessed infrequently but with immediate retrieval needs, not for archival durations of 10 years, and its storage cost is higher than Archive. Option C (Premium Blob Storage) is wrong because it uses SSD-backed storage for low-latency, high-frequency access scenarios, making it the most expensive tier and unsuitable for archival data. Option D (Hot Blob Storage) is wrong because it is designed for data accessed frequently with millisecond latency, incurring the highest storage cost, which contradicts the requirement for lowest possible cost.

Practice this question →

228

MCQeasy

A logistics company uses an online system to process incoming delivery requests one at a time, updating the database immediately upon each transaction. They also run a weekly job that analyzes thousands of delivery records to identify average delivery times and trends. Which set of terms correctly classifies these two workloads?

A.OLTP and OLAP

B.Batch processing and real-time processing

C.Relational and non-relational

D.Structured and semi-structured

AnswerA

OLTP and OLAP are the two standard workload categories in data processing. OLTP systems handle high-volume, low-latency transactional operations such as order entry and inventory updates, emphasizing ACID guarantees and row-level integrity. OLAP systems support analytical queries that aggregate and summarize large historical datasets, often using columnar storage and multidimensional schemas for business intelligence. Together they capture the fundamental divide between running day-to-day operations and analyzing those operations afterward.

Why this answer

The first workload processes individual delivery requests with immediate database updates, which is the definition of Online Transaction Processing (OLTP). The second workload runs a weekly job analyzing thousands of records for trends and averages, which is Online Analytical Processing (OLAP). These two terms correctly classify the transactional and analytical workloads described.

Exam trap

The trap here is that candidates confuse the processing mode (batch vs. real-time) with the workload classification (OLTP vs. OLAP), but the question specifically asks for the terms that classify the workloads, not describe their timing.

Why the other options are wrong

The question describes two distinct workloads: immediate transaction processing (OLTP) and analytical processing of historical data (OLAP). Option B incorrectly labels these as 'batch processing' and 'real-time processing' — while the weekly job is batch, the transaction system is real-time, but the terms 'batch' and 'real-time' describe processing timing, not the workload categories (OLTP vs OLAP) that the question asks for.

The question asks about classifying two workloads (transaction processing and analytical reporting), not about data storage models. 'Relational and non-relational' refers to database types, not workload types.

The question asks about classifying two workloads (transaction processing and analytical reporting), not about data formats. 'Structured and semi-structured' refers to data types, not workload types.

Practice this question →

229

MCQhard

Your company runs a global e-commerce platform that generates over 5 TB of clickstream data daily. The data is currently stored as raw CSV files in Azure Blob Storage. The data engineering team needs to transform this data into a star schema for business intelligence reporting. They want to use a serverless, code-first approach where they can write Python or SQL transformations. The transformed data should be stored in a format that optimizes query performance for Power BI. You also need to ensure that the solution can handle variable data volumes without manual scaling. Which Azure service should you use for the transformation?

A.Azure Stream Analytics

B.Azure Databricks

C.Azure Synapse Serverless SQL

D.Azure Data Factory

AnswerB

Azure Databricks is an Apache Spark-based analytics platform that offers collaborative notebooks, autoscaling clusters, and supports Python, Scala, SQL, and R. It allows data engineers to read CSV files from Azure Data Lake Storage or Blob storage, perform complex transformations using DataFrames or SQL, and write results back — exactly the code-first, scalable batch processing required for a global e-commerce workload. Its serverless option removes infrastructure management while providing the flexibility to write custom transformation logic in Python, making it the ideal choice.

Why this answer

Azure Databricks is the correct choice because it provides a serverless, code-first environment where data engineers can write Python or SQL transformations using Apache Spark. It can handle variable data volumes without manual scaling, and it can output transformed data in optimized formats like Parquet, which significantly improves query performance for Power BI. This aligns perfectly with the requirement for a serverless, code-first approach and star schema transformation.

Exam trap

The trap here is that candidates often confuse Azure Data Factory as a transformation service, but it is actually an orchestration tool that requires a separate compute engine (like Databricks or Synapse) to perform the actual data transformations.

How to eliminate wrong answers

Option A is wrong because Azure Stream Analytics is designed for real-time stream processing, not batch transformations of large CSV files in Blob Storage, and it does not support writing Python transformations. Option C is wrong because Azure Synapse Serverless SQL is a SQL-only query engine that cannot execute Python transformations, and it is not a code-first transformation service. Option D is wrong because Azure Data Factory is primarily an orchestration and ETL/ELT pipeline service that uses visual pipelines or code snippets, but it is not designed for writing custom Python or SQL transformations on large datasets; it relies on compute engines like Databricks or Synapse for actual data processing.

Practice this question →

230

MCQhard

A data engineer loads raw log files into a storage system. The structure of the data is interpreted at the time of reading, allowing queries to apply schema on the fly without preprocessing. This approach is best described as:

A.Schema-on-write

B.Schema-on-read

C.Data warehouse

D.Data virtualization

AnswerB

Schema-on-read applies a logical structure to data only when it is accessed by a query engine, such as Azure Synapse Serverless SQL, Spark, or a metastore catalog that overlays schema metadata on raw files. Raw log files can be stored as-is in a data lake in open formats like JSON, CSV, or Parquet, and the schema is interpreted or inferred at read time. This is the correct answer because it matches the data engineer's workflow of loading raw files into storage without imposing structure until analysis.

Why this answer

Schema-on-read means the data is stored in its raw, unstructured form, and the schema is applied dynamically when the data is queried. This is exactly what happens when raw log files are loaded into a storage system like Azure Data Lake Storage and queried with tools like Azure Synapse Serverless SQL or Apache Spark, which infer the schema at query time without requiring preprocessing.

Exam trap

The trap here is confusing schema-on-read with data virtualization, as both involve querying data without moving it, but schema-on-read specifically refers to interpreting the structure at read time from raw files, not abstracting multiple sources.

How to eliminate wrong answers

Option A is wrong because schema-on-write requires defining and enforcing a schema before data is written, which contradicts the scenario of interpreting structure at read time. Option C is wrong because a data warehouse typically uses schema-on-write with a predefined, optimized schema for structured data, not raw log files with on-the-fly interpretation. Option D is wrong because data virtualization provides a unified view of data from multiple sources without moving it, but it does not specifically describe the schema-on-read approach where the structure is interpreted at query time from raw storage.

Practice this question →

231

MCQeasy

A company operates an online store where customers place orders and the system immediately updates inventory and records payments. This workload is best described as:

A.OLAP (Online Analytical Processing)

B.OLTP (Online Transaction Processing)

C.Batch processing

D.Data warehousing

AnswerB

OLTP (Online Transaction Processing) is the correct workload because order placement involves multiple concurrent, short-duration transactions—inserting the order, adjusting inventory, and recording payment—that must each be executed atomically and with ACID guarantees. These systems use row-based, normalized storage to provide fast writes, strict data integrity, and very low response times even under heavy user concurrency. This directly matches the operational need for immediate, reliable processing of each customer action.

Why this answer

This workload is best described as OLTP because it involves real-time, high-frequency transactions that immediately update inventory and record payments. OLTP systems are designed for concurrent, atomic operations that maintain data integrity, which is exactly what an online store's order processing requires.

Exam trap

The trap here is that candidates confuse OLTP with batch processing because both involve data updates, but OLTP requires immediate, row-level transactions while batch processing defers updates to a scheduled window.

How to eliminate wrong answers

Option A is wrong because OLAP is used for complex analytical queries and aggregations over large historical datasets, not for real-time transactional updates. Option C is wrong because batch processing involves delayed, scheduled processing of data in bulk, whereas the scenario requires immediate updates. Option D is wrong because data warehousing is a repository for structured, historical data used for reporting and analysis, not for handling live transactional workloads.

Practice this question →

232

MCQeasy

You are designing a data pipeline for a social media analytics platform. The pipeline needs to ingest posts from multiple sources (Twitter, Facebook) in real time, transform the data by adding sentiment scores, and store the results in a data store for later analysis. The transformation logic is simple and can be expressed as a SQL query. You want to minimize coding effort. Which Azure service should you use for the transformation step?

A.Azure Data Factory

B.Azure Databricks

C.Azure Functions

D.Azure Stream Analytics

AnswerD

Azure Stream Analytics is a fully managed stream-processing service that queries live data using a SQL-like language without requiring custom code. It reads from high-throughput sources such as Event Hubs or IoT Hub, applies temporal windows, filters, joins, and aggregates, and writes results to Power BI, Azure SQL, Cosmos DB, or Data Lake Storage. Its declarative model and built-in time handling make it the natural choice for low-latency social media analytics, letting you continuously compute metrics like mentions, sentiment, or trending hashtags in near-real time.

Why this answer

Azure Stream Analytics is the correct choice because it is designed for real-time data processing with SQL-like query language, allowing you to transform streaming data (e.g., from Twitter and Facebook) by adding sentiment scores using simple SQL expressions without writing custom code. It integrates natively with Azure Event Hubs or IoT Hub for ingestion and outputs to Azure SQL Database, Cosmos DB, or Blob Storage for analysis, minimizing coding effort.

Exam trap

The trap here is that candidates often confuse Azure Data Factory (batch ETL) with real-time stream processing, or assume Azure Functions is simpler for SQL-like transformations, but Stream Analytics is the only service that combines real-time ingestion, SQL-based transformation, and minimal coding effort.

How to eliminate wrong answers

Option A is wrong because Azure Data Factory is an orchestration and ETL service for batch data movement and transformation, not designed for real-time stream processing; it cannot handle sub-second latency or continuous SQL-based transformations on live streams. Option B is wrong because Azure Databricks is a big data analytics platform that requires writing Spark code (Python, Scala, or SQL) and managing clusters, which involves more coding effort than a simple SQL query on a stream. Option C is wrong because Azure Functions is a serverless compute service for event-driven code execution, but it requires writing custom code (e.g., C#, JavaScript) for each transformation, and it lacks native SQL-based stream processing capabilities, making it less efficient for simple SQL transformations on real-time data.

Practice this question →

233

MCQhard

A manufacturing company collects sensor data from thousands of IoT devices. Each reading contains a device ID, timestamp, value, and device-specific measurement fields. The company needs to analyze the data in real time to detect anomalies and trigger alerts. They also need to store the same data for historical batch analysis to identify long-term trends. Which architecture pattern best describes this combination of data processing approaches?

A.Batch processing only

B.Stream processing only

C.Lambda architecture

D.Data lake

AnswerC

Lambda architecture is correct because it deliberately combines a batch layer for accurate, comprehensive historical processing and a speed layer for real-time stream processing over the same sensor data. The batch layer computes precise trends and baseline models from all collected data, while the speed layer provides low-latency anomaly detection and feeds both results into a serving layer for unified querying. This design satisfies both the real-time alerting and historical analysis requirements, with the tradeoff of maintaining two separate code paths.

Why this answer

The Lambda architecture is the correct pattern because it combines both stream processing for real-time anomaly detection and alerting, and batch processing for historical analysis of long-term trends. This architecture uses a speed layer for low-latency stream processing (e.g., Apache Kafka, Azure Stream Analytics) and a batch layer for comprehensive, accurate historical computations (e.g., Azure Data Lake, Apache Spark). The serving layer then merges results from both paths to provide a unified view.

Exam trap

The trap here is that candidates confuse a storage architecture (data lake) with a processing architecture pattern, or mistakenly think that either stream or batch processing alone can satisfy both real-time and historical requirements.

How to eliminate wrong answers

Option A is wrong because batch processing alone cannot handle real-time anomaly detection and alerting, as it processes data in large, scheduled intervals with high latency. Option B is wrong because stream processing alone is not designed for efficient historical batch analysis over long periods, as it focuses on low-latency, in-memory computations and typically does not retain full historical data for reprocessing. Option D is wrong because a data lake is a storage repository for raw data in its native format, not a processing architecture pattern that combines real-time and batch analytics.

Practice this question →

234

Multi-Selecthard

A globally distributed online auction platform uses a replicated database system across multiple Azure regions. The system must continue accepting bids (writes) even if a network partition occurs between regions, because auctions cannot be interrupted. The business decides that during a partition, some users might see slightly outdated item prices (read inconsistency) but all bids must be recorded. According to the CAP theorem, which two properties is this system prioritizing?

Select 1 answer

A.Availability (A) and Partition Tolerance (P)

B.Consistency (C) and Partition Tolerance (P)

C.Consistency (C) and Availability (A)

D.Durability and Availability

AnswersA

Correct. The system must accept writes during partitions (Partition Tolerance) and ensure every request gets a response (Availability), even if read inconsistency occurs.

Why this answer

The CAP theorem defines three properties: Consistency (C), Availability (A), and Partition Tolerance (P). The system continues accepting bids during network partitions, prioritizing Availability (every request receives a response) and Partition Tolerance (system operates despite network splits). Option A (Availability and Partition Tolerance) directly describes this AP trade-off.

Option D (Durability and Availability) is incorrect because Durability is not a CAP property; it belongs to ACID. The question specifically asks for CAP properties, so only A is correct.

Exam trap

The trap is that candidates often focus only on CAP properties and forget that other properties like Durability are also essential in practice. Also, they may confuse CAP's Consistency with ACID consistency. The correct answers include both a CAP pair and an additional non-CAP property.

Practice this question →

235

MCQeasy

A logistics company stores shipping waybill data as JSON documents. Each document contains fields like 'shipmentId', 'destination', and 'items', but the number of items and the fields within each item can vary between shipments. Which category best describes this type of data?

A.Operational data

B.Semi-structured data

C.Unstructured data

D.Structured data

AnswerB

JSON documents consist of key-value pairs, nested objects, and arrays, but each waybill may have a different set of fields—some optional, some nested. This self-describing format provides inherent organization through keys and hierarchical structure, yet it does not enforce a rigid, predefined schema. That combination of organizational properties without a fixed tabular schema is the defining characteristic of semi-structured data, which is why this is the correct classification.

Why this answer

JSON documents with varying fields and nested structures like 'items' that differ between shipments are a classic example of semi-structured data. Unlike structured data with a fixed schema, semi-structured data uses tags or markers (like JSON key-value pairs) to separate data elements, allowing for flexibility in the number and type of fields per record. This aligns with the DP-900 definition of semi-structured data, which includes formats such as JSON, XML, and Parquet.

Exam trap

The trap here is that candidates confuse 'semi-structured' with 'unstructured' because JSON appears flexible, but JSON is still structured with key-value pairs, unlike truly unstructured data like audio or video files.

Why the other options are wrong

Operational data refers to data used in day-to-day business operations, not a data format category. The question asks about data structure (structured, semi-structured, unstructured), not its purpose.

Unstructured data lacks a predefined data model or schema, but JSON documents have a structure with fields like 'shipmentId', 'destination', and 'items', even if fields vary. The data is semi-structured because it uses tags and keys to organize data, not completely unstructured.

Structured data requires a fixed schema with consistent fields and data types, but the JSON documents here have varying fields and nested structures, making them semi-structured.

Practice this question →