CCNA Ai Models Data Engineering Questions — Page 2 of 2

Multi-Selecthard

A data engineer is designing a data pipeline for a real-time recommendation system. The pipeline must handle high velocity streams and ensure data quality. Which three components should be included in the pipeline? (Select THREE).

Select 3 answers

A.A stream processing engine like Apache Kafka Streams

B.A data validation step to check schema compliance

C.A data warehouse for historical analysis

D.A batch processing framework like Apache Spark

E.A message queue for buffering

AnswersA, B, E

Stream processing engines process data in real-time with low latency.

Why this answer

Apache Kafka Streams is a correct choice because it is a stream processing library specifically designed for building real-time applications and microservices that process data in motion. For a high-velocity recommendation pipeline, it provides exactly-once semantics, stateful processing (e.g., windowed joins, aggregations), and seamless integration with Kafka topics, enabling low-latency transformations without requiring an external cluster.

Exam trap

CompTIA often tests the distinction between stream processing and batch processing, and the trap here is that candidates mistakenly select a batch framework like Apache Spark or a data warehouse because they associate 'data pipeline' with traditional ETL, overlooking the strict real-time and low-latency requirements of the scenario.

Practice this question →

MCQhard

An engineer is training a neural network and observes the output shown. Which conclusion is most likely correct?

A.The gradients are vanishing.

B.The model is overfitting after epoch 2.

C.The model is underfitting.

D.The learning rate is too high.

AnswerB

Training loss decreases, validation loss increases.

Why this answer

The output shows training loss decreasing while validation loss increases after epoch 2, which is a classic sign of overfitting. The model begins to memorize the training data rather than generalize, leading to poor performance on unseen data. This pattern confirms that overfitting starts after epoch 2, making option B correct.

Exam trap

CompTIA often tests the distinction between overfitting and underfitting by presenting a loss curve where training loss decreases but validation loss increases, leading candidates to mistakenly attribute the issue to vanishing gradients or a high learning rate.

How to eliminate wrong answers

Option A is wrong because vanishing gradients typically cause slow or stalled learning across all epochs, not a sudden divergence between training and validation loss after epoch 2. Option C is wrong because underfitting would show high training loss and high validation loss throughout, not a decreasing training loss with increasing validation loss. Option D is wrong because a learning rate that is too high would cause the loss to oscillate or diverge from the start, not show a clear overfitting pattern after epoch 2.

Practice this question →

MCQmedium

A data scientist is training a deep learning model for image classification. The training loss decreases steadily but the validation loss starts increasing after 10 epochs. Which technique should the scientist apply to address this issue?

A.Add more dropout layers

B.Reduce the learning rate

C.Implement early stopping

D.Increase the number of training epochs

AnswerC

Early stopping halts training when validation loss stops improving, preventing overfitting.

Why this answer

The scenario describes overfitting: the model memorizes training data (loss decreases) but fails to generalize to unseen validation data (validation loss increases). Early stopping (Option C) halts training when validation performance degrades, preventing overfitting while preserving the best model weights. This is a standard regularization technique in deep learning frameworks like TensorFlow and PyTorch.

Exam trap

CompTIA often tests the distinction between preventive regularization (dropout, L2) and reactive overfitting control (early stopping), leading candidates to choose dropout or learning rate reduction when the scenario explicitly describes overfitting that has already begun.

How to eliminate wrong answers

Option A is wrong because adding more dropout layers can help regularize the model, but it is not the direct solution for the described symptom of validation loss increasing after a certain epoch; dropout is a preventive measure applied before training, not a reactive fix for overfitting that has already occurred. Option B is wrong because reducing the learning rate may slow down convergence or help escape local minima, but it does not address the core issue of overfitting; a lower learning rate can even exacerbate overfitting by allowing the model to fit noise more precisely. Option D is wrong because increasing the number of training epochs would worsen the overfitting problem, as the model would continue to memorize training data and further diverge from validation performance.

Practice this question →

MCQmedium

During model deployment, a data engineer notices that the model's predictions are consistently lower than expected due to a shift in the distribution of one feature between training and production. Which technique should be used to detect and quantify this shift?

A.Compute the root mean square error (RMSE)

B.Calculate the population stability index (PSI)

C.Generate a confusion matrix

D.Perform a t-test on the means

AnswerB

PSI quantifies the degree of distribution shift, commonly used in monitoring.

Why this answer

The Population Stability Index (PSI) is specifically designed to detect and quantify shifts in the distribution of a feature or score between two populations, such as training and production datasets. It measures the stability of the feature by comparing the proportion of observations in each bin across the two time periods, making it the correct choice for diagnosing distribution drift in model deployment.

Exam trap

CompTIA often tests the distinction between performance metrics (like RMSE or confusion matrix) and distribution monitoring metrics (like PSI), trapping candidates who confuse model accuracy evaluation with data drift detection.

How to eliminate wrong answers

Option A is wrong because RMSE measures the average magnitude of prediction errors, not distribution shifts between datasets. Option C is wrong because a confusion matrix evaluates classification performance against ground truth labels, not feature distribution changes. Option D is wrong because a t-test on the means only checks for a difference in central tendency, not the full distributional shift that PSI captures, and it is sensitive to sample size rather than bin-wise stability.

Practice this question →

MCQmedium

A data engineer is building a pipeline to ingest streaming data from IoT sensors. Which data storage solution is best suited for real-time analytics on timestamped sensor readings?

A.Data warehouse

B.Relational database

C.Data lake

D.Time-series database

AnswerD

Time-series databases provide specialized indexing, compression, and query capabilities for timestamped data.

Why this answer

Time-series databases (TSDBs) are optimized for high-ingest rates of timestamped data and provide efficient downsampling, retention policies, and time-based aggregation functions. For IoT sensor streaming, a TSDB like InfluxDB or TimescaleDB delivers sub-second query performance on time-range scans, which is essential for real-time analytics.

Exam trap

CompTIA often tests the misconception that 'any database can handle time-series data if you add a timestamp column,' ignoring the fundamental architectural differences in storage engines, indexing, and write optimization that make TSDBs the only viable choice for real-time streaming analytics.

How to eliminate wrong answers

Option A is wrong because data warehouses (e.g., Snowflake, Redshift) are designed for batch-oriented, structured querying of historical data and cannot sustain the high write throughput or low-latency time-range scans required for streaming sensor data. Option B is wrong because relational databases (e.g., PostgreSQL, MySQL) use row-based storage and B-tree indexes that degrade under continuous time-series inserts, leading to write contention and slow time-range queries. Option C is wrong because data lakes (e.g., S3, ADLS) store raw data in object storage with no indexing or time-ordering, making real-time analytics impossible due to high read latency and lack of native time-series functions.

Practice this question →

MCQeasy

A team is using a pre-trained language model for sentiment analysis. They want to adapt it to a specific domain with limited labeled data. Which approach is most efficient?

A.Fine-tune the pre-trained model on domain data

B.Use the pre-trained model as is

C.Train a new model from scratch

D.Ensemble multiple pre-trained models

AnswerA

Fine-tuning updates the model weights slightly on domain data, achieving good performance with few examples.

Why this answer

Fine-tuning a pre-trained language model on domain-specific labeled data is the most efficient approach because it leverages the general language understanding learned from large corpora while adapting to the target domain with minimal additional data. This process uses transfer learning, where only the final layers or a subset of parameters are updated, significantly reducing the amount of labeled data and compute required compared to training from scratch.

Exam trap

The AI0-001 exam often tests the misconception that a pre-trained model can be used directly for any domain without adaptation, leading candidates to choose Option B, but the trap here is that domain-specific tasks require fine-tuning to align the model's representations with the target data distribution.

How to eliminate wrong answers

Option B is wrong because using the pre-trained model as-is (zero-shot inference) typically yields poor performance on domain-specific sentiment analysis due to vocabulary and context mismatches, as the model was not exposed to domain-specific jargon or sentiment nuances. Option C is wrong because training a new model from scratch requires a massive labeled dataset (often millions of examples) and extensive computational resources, which contradicts the constraint of limited labeled data. Option D is wrong because ensembling multiple pre-trained models without fine-tuning them on domain data does not address the domain adaptation problem; it merely averages their general predictions, which may still be inaccurate for domain-specific sentiment.

Practice this question →