Unit 6: Data Analysis & Visualization; AI Model Environments & Lifecycle Basics - Practice Quiz

INT428 — Artificial Intelligence Essentials 60 Questions
0 Correct 0 Wrong 60 Left
0/60

1 Which AI tool allows users to upload files and perform data analysis using natural language prompts?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Easy
A. Windows Notepad
B. Microsoft Word
C. ChatGPT Advanced Data Analysis
D. Adobe Photoshop

2 Tableau is primarily used for which of the following tasks?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Easy
A. Editing raw video files
B. Compiling C++ code
C. Managing email accounts
D. Data visualization and dashboards

3 What is the main benefit of using data visualization tools like Tableau?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Easy
A. Encrypting network traffic
B. Increasing raw file storage size
C. Making patterns and trends easier to understand
D. Compiling machine code faster

4 Which of the following is an example of structured data?

Working with structured and unstructured data Easy
A. A table in a relational database
B. A free-form email body
C. A collection of social media images
D. A recorded voice message

5 Which of the following is considered unstructured data?

Working with structured and unstructured data Easy
A. A SQL database table
B. A spreadsheet with labeled columns
C. A CSV file of numbers
D. A video file

6 Structured data is typically stored in which format?

Working with structured and unstructured data Easy
A. Handwritten notes
B. Audio waveforms
C. Random binary blobs
D. Rows and columns

7 What is the primary purpose of a data pipeline?

Data pipelines and automation Easy
A. To manage user passwords
B. To move and process data between systems
C. To edit photos
D. To design website layouts

8 In the ETL process, what does the letter 'T' stand for?

Data pipelines and automation Easy
A. Translate
B. Transform
C. Transmit
D. Transfer

9 Why is automation useful in data pipelines?

Data pipelines and automation Easy
A. It slows down data processing
B. It permanently deletes all data
C. It reduces manual, repetitive work
D. It requires constant human input

10 Which of the following is a benefit of using cloud services for AI?

Cloud services Easy
A. Fixed unchangeable capacity
B. No internet requirement ever
C. Guaranteed offline-only access
D. Scalable computing resources on demand

11 Which of the following is a well-known cloud service provider?

Cloud services Easy
A. Adobe Reader
B. Amazon Web Services (AWS)
C. VLC Media Player
D. Microsoft Word

12 What does the term 'pay-as-you-go' mean in cloud computing?

Cloud services Easy
A. You pay a fixed lifetime fee
B. You pay only for resources you use
C. You pay before using anything
D. You pay nothing at all

13 What does edge deployment mean in AI?

Edge deployment Easy
A. Running models on local devices near data sources
B. Deleting models after training
C. Storing all data in a single server
D. Running models only in web browsers

14 Which is a key advantage of edge deployment over cloud-only processing?

Edge deployment Easy
A. Unlimited storage capacity
B. Complete elimination of software
C. Lower latency and faster local responses
D. No need for any hardware

15 Which of the following is an example of an edge device?

Edge deployment Easy
A. A remote web server farm
B. A central mainframe computer
C. A smart security camera with built-in AI
D. A large cloud data center

16 What is the first step in fixing a problem in a data workflow?

Error identification Easy
A. Ignoring the error
B. Restarting the computer randomly
C. Deleting all the data
D. Identifying the error

17 What is troubleshooting in the context of AI systems?

Troubleshooting Easy
A. Diagnosing and resolving problems
B. Increasing the file size
C. Deleting the entire system
D. Adding new features only

18 What does AI process automation aim to achieve?

AI process automation Easy
A. Removing all software tools
B. Increasing human data entry
C. Automating repetitive tasks using AI
D. Making tasks slower manually

19 What does MLOps primarily focus on?

Introduction to MLOps and lifecycle management Easy
A. Designing company logos
B. Managing the machine learning lifecycle
C. Managing office furniture
D. Writing marketing emails

20 Which stage is part of the machine learning model lifecycle?

Introduction to MLOps and lifecycle management Easy
A. Furniture ordering
B. Payroll processing
C. Logo design
D. Model deployment

21 A student uploads a CSV of monthly sales to ChatGPT Advanced Data Analysis and asks for a trend chart. Which capability makes this possible?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Medium
A. It executes Python code in a sandbox to parse and plot the data
B. It stores the file permanently in a public database
C. It converts the CSV into a spreadsheet formula engine only
D. It sends the file to Tableau servers for rendering

22 In Tableau, you want to compare sales across regions and see the magnitude at a glance using color intensity on a map. Which visualization is most appropriate?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Medium
A. A scatter plot of two measures
B. A single-value KPI card
C. A word cloud of region names
D. A filled (choropleth) map

23 Which of the following is the best example of unstructured data?

Working with structured and unstructured data Medium
A. A relational table of order IDs and prices
B. A spreadsheet of employee salaries
C. A collection of customer support call audio recordings
D. A CSV file of temperature readings

24 A team must analyze thousands of scanned invoices to extract totals into a database. Which preprocessing step is essential to convert this unstructured input into structured data?

Working with structured and unstructured data Medium
A. Optical Character Recognition (OCR)
B. Applying a JOIN operation
C. Indexing an existing SQL table
D. Normalizing a relational schema

25 In an ETL pipeline, which stage is responsible for cleaning and reshaping raw data before it is stored?

Data pipelines and automation Medium
A. Extract
B. Load
C. Ingest
D. Transform

26 A company's data pipeline reprocesses the entire dataset every night even when only a few rows change. Which improvement best reduces wasted compute?

Data pipelines and automation Medium
A. Remove all data validation steps
B. Increase the batch window to weekly
C. Duplicate the pipeline for redundancy
D. Switch to incremental (delta) processing

27 A startup wants to run ML training without managing servers, paying only for the compute time used per function call. Which cloud model fits best?

Cloud services Medium
A. Colocation hosting
B. On-premises data center
C. Serverless (Function-as-a-Service)
D. Bare-metal hosting

28 Which cloud service model gives a data science team the most control over the operating system and installed libraries while still avoiding physical hardware management?

Cloud services Medium
A. Software as a Service (SaaS)
B. Platform as a Service (PaaS)
C. Infrastructure as a Service (IaaS)
D. Function as a Service (FaaS)

29 A smart camera must detect defects on a factory line with sub-second latency and no internet dependency. Why is edge deployment preferred over cloud inference here?

Edge deployment Medium
A. It processes data locally, reducing latency and network reliance
B. It removes the need to train any model
C. It guarantees unlimited compute power on the device
D. It automatically encrypts all cloud storage

30 Which technique is most commonly used to make a large neural network fit and run efficiently on a resource-constrained edge device?

Edge deployment Medium
A. Increasing batch size
B. Model quantization
C. Adding more hidden layers
D. Storing weights in the cloud

31 A model shows 99% accuracy on training data but 62% on test data. What error is most likely occurring?

Error identification Medium
A. Underfitting
B. Overfitting
C. Class balance improvement
D. Data leakage from test to train

32 While analyzing a dataset, you notice a column of ages contains the value and another value . What type of data issue is this?

Error identification Medium
A. Out-of-range (invalid) values
B. Correct outliers to keep
C. Missing values
D. Duplicate records

33 A Python data script fails with a KeyError when accessing a column named 'Sales'. What is the most effective first troubleshooting step?

Troubleshooting Medium
A. Delete the dataset and start over
B. Increase the machine's RAM
C. Reinstall the Python interpreter
D. Print the DataFrame's actual column names to check spelling and whitespace

34 A deployed model's predictions have gradually become less accurate over several months, though the code is unchanged. What should you investigate first?

Troubleshooting Medium
A. A syntax error in the training loop
B. The version of the text editor used
C. The color scheme of the dashboard
D. Data drift in the incoming data distribution

35 An insurance firm wants to automate reading emailed claim forms and routing them to the right department. Which combination best describes this AI-driven automation?

AI process automation Medium
A. A single static SQL query
B. Intelligent Document Processing combined with rule-based routing
C. A one-time batch export to CSV
D. Manual data entry by staff

36 Which scenario is the LEAST suitable candidate for AI process automation?

AI process automation Medium
A. A rare, one-off creative negotiation requiring human judgment
B. Classifying thousands of incoming support tickets
C. Flagging duplicate records in a large dataset
D. Extracting totals from repetitive invoices

37 In the ML lifecycle, which MLOps practice ensures you can reproduce exactly which dataset and code produced a given model?

Introduction to MLOps and lifecycle management Medium
A. Deleting old experiments regularly
B. Increasing the learning rate
C. Versioning of data, code, and models
D. Disabling logging in production

38 Why is continuous monitoring considered essential after a model is deployed to production?

Introduction to MLOps and lifecycle management Medium
A. To permanently freeze the model from any updates
B. To detect performance degradation and trigger retraining
C. To eliminate the need for version control
D. To reduce the training dataset size automatically

39 A team wants every code commit to automatically train, test, and validate a model before deployment. Which MLOps concept does this describe?

Introduction to MLOps and lifecycle management Medium
A. Static feature storage only
B. CI/CD pipelines for machine learning
C. Manual model handoff
D. One-time exploratory analysis

40 You want to show the relationship between advertising spend and revenue and check whether higher spend correlates with higher revenue. Which chart type is most appropriate?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Medium
A. A scatter plot with a trend line
B. A gauge chart of one value
C. A pie chart of total spend
D. A single bar showing average revenue

41 You upload a 2 GB CSV to ChatGPT Advanced Data Analysis and ask it to compute a rolling 30-day average grouped by region. The tool returns partial results and warns about memory. What is the most robust fix within the tool's execution sandbox?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Hard
A. Re-upload the file multiple times so the sandbox caches it across sessions
B. Convert the CSV to JSON first because JSON is more memory-efficient than CSV
C. Read the file in chunks with pandas.read_csv(chunksize=...) and aggregate incrementally before computing the rolling average
D. Ask the model to increase its context window so it can hold the full file

42 In Tableau, a LOD expression {FIXED [Region] : SUM([Sales])} produces different values than a table calculation of the same aggregation. Why?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Hard
A. FIXED expressions are evaluated only on the Tableau Server, so local previews are unreliable
B. FIXED LOD computes before dimension filters are applied and ignores viz-level dimensions not listed, while table calcs operate on the aggregated result in the view
C. FIXED LOD and table calculations are mathematically identical and any difference indicates corrupted data
D. Table calculations always sum at the row level whereas LOD expressions sum at the extract level

43 A pipeline ingests customer emails (unstructured) and CRM records (structured). To join them for churn analysis, which approach best bridges the modality gap?

Working with structured and unstructured data Hard
A. Convert all CRM records to free text so both sources share the same unstructured format
B. Extract entities and embeddings from emails, then key them to CRM records via a resolved customer ID
C. Discard the emails since unstructured data cannot be joined with structured tables
D. Store the raw emails as a single BLOB column in the CRM table and query with SQL LIKE

44 A data lake stores JSON logs with inconsistent schemas across days. A query engine using schema-on-read fails on new fields. What is the correct interpretation?

Working with structured and unstructured data Hard
A. The failure proves the data must be migrated to a strict relational database immediately
B. Schema-on-read tolerates schema drift, but the query itself must handle missing or new fields gracefully
C. Schema-on-read enforces a fixed schema at write time, so the new fields were rejected on ingestion
D. Schema-on-read requires all files to be identical, so any drift halts all queries permanently

45 An ETL DAG has a task that occasionally succeeds after retry due to a flaky upstream API. To keep the pipeline both reliable and idempotent, which combination is best?

Data pipelines and automation Hard
A. Cache the first response permanently and never call the API again to avoid flakiness
B. Disable retries and let the on-call engineer manually rerun failed tasks each time
C. Configure retries with exponential backoff and design the write step to upsert on a natural key
D. Increase the retry count to 100 and append every result so nothing is lost

46 In a streaming pipeline, you must guarantee that each event affects downstream aggregates exactly once even if the source redelivers messages. Which mechanism directly enables this?

Data pipelines and automation Hard
A. Deduplication using a unique event ID combined with transactional checkpointing of offsets and state
B. Increasing the number of partitions so redelivered messages land elsewhere
C. Processing events in a single thread to serialize all writes
D. Setting the consumer to at-most-once delivery so no message is ever processed twice

47 A model inference service on the cloud has spiky, unpredictable traffic and strict cost limits during idle periods. Which deployment model minimizes idle cost while handling spikes?

Cloud services Hard
A. Reserved instances purchased for three years to lock in low rates
B. A single small VM that queues all requests during spikes
C. A fixed fleet of large GPU instances running 24/7 to guarantee capacity
D. Serverless functions or scale-to-zero container services that scale on demand

48 You notice cross-region data transfer charges dominating your cloud bill for an analytics pipeline. The compute is in region A but the data lake is in region B. What is the most cost-effective architectural change?

Cloud services Hard
A. Switch to a smaller instance type in region A to reduce compute cost
B. Co-locate compute and storage in the same region to eliminate inter-region egress
C. Compress the data before every transfer but keep compute and storage in separate regions
D. Enable multi-region replication so the data exists everywhere at once

49 You must deploy a vision model to battery-powered edge devices with 512 MB RAM and no reliable network. Which optimization set best fits these constraints?

Edge deployment Hard
A. Quantize to int8, prune, and run inference locally with an on-device runtime
B. Increase model size for accuracy since edge devices cache weights efficiently
C. Rely on federated learning to train on-device in real time during inference
D. Deploy the full FP32 model and stream every frame to the cloud for inference

50 An edge fleet runs a quantized model, but field accuracy is lower than in the lab. Logs show input images have different lighting than training data. What is the root cause and fix?

Edge deployment Hard
A. Network latency degraded predictions; add more bandwidth to the devices
B. The edge runtime is too fast; throttle inference to improve accuracy
C. Quantization corrupted the weights; revert to FP32 permanently on all devices
D. Data distribution shift at the edge; retrain or fine-tune on representative field data and monitor drift

51 A model reports 99% training accuracy but 62% validation accuracy, and validation loss rises while training loss keeps falling. What does this pattern indicate?

Error identification Hard
A. Vanishing gradients preventing any learning
B. Underfitting; the model is too simple to learn the patterns
C. Overfitting; the model memorizes training data and fails to generalize
D. Data leakage from validation into training set

52 During analysis you find a feature perfectly predicts the target in training but is unavailable at prediction time in production. This is an example of:

Error identification Hard
A. Class imbalance in the target variable
B. Multicollinearity among input features
C. Target leakage caused by using information not available at inference
D. Concept drift over time in the production stream

53 A batch scoring job intermittently produces NaN predictions for a small subset of records. The model and code are unchanged. What is the most systematic first troubleshooting step?

Troubleshooting Hard
A. Isolate and inspect the failing records for out-of-range or missing feature values that produce NaN after transformation
B. Restart the entire cluster to clear any transient state
C. Retrain the model from scratch assuming the weights became corrupted
D. Switch the model to a different algorithm that never outputs NaN

54 After a deployment, inference latency at p99 spiked while p50 stayed flat. Throughput is unchanged. What does this most likely indicate?

Troubleshooting Hard
A. A model accuracy regression affecting speed
B. A drop in request volume overloading the server
C. The entire service is uniformly slower for all requests
D. Tail latency from a subset of slow requests, often due to GC pauses, cold caches, or resource contention

55 You automate an approval workflow with an AI classifier that routes low-risk cases automatically and escalates uncertain ones. Which design best balances automation and safety?

AI process automation Hard
A. Route by prediction confidence with a human-in-the-loop threshold for low-confidence or high-impact cases
B. Automate only cases the model rates as uncertain, escalating confident ones
C. Automate 100% of decisions to maximize throughput regardless of confidence
D. Send every case to a human and use the model only for logging

56 An RPA bot that scrapes a web portal breaks whenever the site's HTML layout changes. Which strategy most durably reduces this fragility?

AI process automation Hard
A. Run the bot more frequently so failures are noticed sooner
B. Use a stable API or semantic selectors and add change-detection with alerting instead of brittle positional XPaths
C. Add longer wait times before each scrape to let the page fully load
D. Hard-code more specific absolute XPath positions so selectors are precise

57 Your production model's accuracy slowly degrades over months even though the code is frozen. Monitoring shows input feature distributions drifting from training. Which MLOps practice directly addresses this?

Introduction to MLOps and lifecycle management Hard
A. Adding more logging to the inference API without changing the model
B. Increasing unit test coverage on the training code
C. Locking the model version permanently to preserve reproducibility
D. Continuous monitoring for data/concept drift with automated retraining triggers on representative recent data

58 A team wants to safely release a new model version while limiting blast radius if it underperforms. Which deployment strategy fits best?

Introduction to MLOps and lifecycle management Hard
A. Canary or shadow deployment routing a small traffic slice while comparing metrics before full rollout
B. Keeping both models but randomly picking one per request with no metric comparison
C. Deploying the new model only to the training environment indefinitely
D. Big-bang replacement of all traffic to the new model at once

59 For reproducible ML experiments, which combination of artifacts must be versioned together to guarantee a result can be regenerated exactly?

Introduction to MLOps and lifecycle management Hard
A. Only the hyperparameters, since the framework handles the rest automatically
B. Only the trained model weights, since they encode everything learned
C. Only the source code, because data can always be re-downloaded fresh
D. Code, data snapshot, dependencies/environment, and hyperparameters/random seeds

60 A stakeholder claims a Tableau dashboard shows sales "trending up," but the line uses a dual axis with two independently scaled measures. Why is this visualization misleading?

Data analysis and visualization using AI tools (ChatGPT Advanced Data Analysis, Tableau) Hard
A. Tableau cannot render two measures on one chart, so the data is fabricated
B. Independent axis scaling can make unrelated magnitudes appear correlated or exaggerate trends, distorting comparison
C. Dual axes always average the two measures, hiding the real values
D. Dual-axis charts automatically apply a moving average that inflates trends