Back to CompTIA Data+ DA0-001 questions

Scenario-based practice

Refer to the Exhibit Practice Questions

Practise CompTIA Data+ DA0-001 practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

15
scenario questions
DA0-001
exam code
CompTIA
vendor

Scenario guide

How to approach refer to the exhibit practice questions

Practise exhibit-style questions that ask you to read a topology, table, command output or diagram before choosing the best answer.

Quick answer

Exhibit-style questions test whether you can read a topology, command output, diagram or table before choosing the best answer.

How to extract the relevant detail from an exhibit.

How topology, command output or routing information affects the answer.

How to avoid answering from memory before reading the evidence.

How to map the exhibit back to the exam objective.

Related practice questions

Related DA0-001 topic practice pages

Scenario questions usually connect to one or more exam topics. Use these links to review the underlying concepts behind the scenario.

Practice set

Practice scenarios

Question 1hardmultiple choice
Full question →

Based on the exhibit, what is the most likely cause of the import failure?

Exhibit

Refer to the exhibit.

Data Import Log:
[2024-03-15 10:22:34] INFO: Starting import from source 'sales_raw.csv'
[2024-03-15 10:22:35] WARN: Row 1502: 'price' field contains non-numeric value '12.5A'. Skipping row.
[2024-03-15 10:22:36] ERROR: Row 3450: 'date' field value '2024-02-30' is invalid. Import halted.
[2024-03-15 10:22:36] INFO: Import process terminated with errors.
Question 2mediummultiple choice
Full question →

Refer to the exhibit. A data analyst is troubleshooting a failed dashboard refresh. The error log shows repeated SQL syntax errors. Which of the following is the most likely cause?

Exhibit

Error Log:
2024-07-15 08:23:45, ERROR - Query execution failed: ORA-00933: SQL command not properly ended
2024-07-15 08:23:45, ERROR - Stack trace: at com.example.DataService.getData(DataService.java:42)
2024-07-15 08:23:45, WARN - Retry attempt 1 of 3
2024-07-15 08:23:47, ERROR - Retry failed: ORA-00933: SQL command not properly ended
2024-07-15 08:23:47, ERROR - Data refresh job for dashboard 'DailySummary' failed.
Question 3hardmultiple choice
Full question →

A data analyst is preparing a logistic regression model to predict customer churn. After examining the exhibit, which data quality issue should the analyst address first?

Network Topology
|Refer to the exhibit.Table: customer_churn
Question 4hardmultiple choice
Full question →

Refer to the exhibit. A data analyst is reviewing a data quality report. Which of the following actions should the analyst take first?

Exhibit

Data Quality Check Report
Table: customer_info
Check: Non-null validation on email field
Result: Failed - 1200 records have null email
Question 5easymultiple choice
Full question →

Refer to the exhibit. Which clause is used to aggregate the data by department?

Exhibit

SELECT department, COUNT(*) as employee_count FROM employees WHERE hire_year > 2020 GROUP BY department HAVING COUNT(*) > 5;
Question 6mediummultiple choice
Full question →

Refer to the exhibit. Which type of ensemble method is being used?

Exhibit

{"model_type": "random_forest", "n_estimators": 100, "max_depth": 5, "criterion": "gini"}
Question 7mediummultiple choice
Full question →

Refer to the exhibit. A data analyst notices that direct S3 access to files outside the "incoming/" prefix is blocked. Which data governance principle does this policy enforce?

Exhibit

{
  "policy": {
    "effect": "Allow",
    "action": ["s3:GetObject"],
    "resource": "arn:aws:s3:::data-bucket/*",
    "condition": {
      "StringEquals": {"s3:prefix": "incoming/"}
    }
  }
}
Question 8mediummultiple choice
Full question →

Refer to the exhibit. An analyst runs a query to count orders in June 2023 and gets 12,345. However, a dashboard shows 12,298 for the same month. What is the most likely cause?

Exhibit

SELECT COUNT(*) FROM orders WHERE order_date >= '2023-06-01' AND order_date < '2023-07-01';
Result: 12,345
Question 9mediummultiple choice
Full question →

Refer to the exhibit. What is the impact of the validation result?

Network Topology
$ validatesource=prodtarget=stagingValidation Results:- Data type mismatch: No- Duplicates found: No
Question 10hardmultiple choice
Full question →

Refer to the exhibit. An analyst sees this log during data acquisition. What action should be taken first?

Exhibit

Refer to the exhibit.
```
INFO: Starting extraction from source 'SalesDB'
INFO: Connected successfully.
WARN: Data type mismatch in column 'Price': expected NUMERIC, found VARCHAR
ERROR: Row 1523: failed to parse date '2024-02-30'
INFO: Extraction completed with 1 warning and 1 error.
```
Question 11mediummultiple choice
Full question →

Refer to the exhibit. Which data concept does this exhibit best represent?

Exhibit

Refer to the exhibit.
Exhibit:
{
  "type": "object",
  "properties": {
    "customerId": { "type": "integer" },
    "name": { "type": "string" },
    "orders": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "orderId": { "type": "integer" },
          "total": { "type": "number" }
        }
      }
    }
  }
}
Question 12easymultiple choice
Full question →

Refer to the exhibit. Which data quality dimension is compromised by the missing value for Charlie's salary?

Exhibit

ID, Name, Salary, Department
1, Alice, 60000, Sales
2, Bob, 70000, IT
3, Charlie, , IT
Question 13hardmultiple choice
Full question →

Refer to the exhibit. Which conclusion can be drawn from this data quality report?

Exhibit

Refer to the exhibit.
Exhibit:
Table: Customer_Master
Column: Email_Address
Completeness: 92%
Validity: 85%
Uniqueness: 97%
Consistency: 100%
Question 14easymultiple choice
Full question →

Refer to the exhibit. A data analyst wants to create a visualization that best shows the trend of sales over time for each department. Which chart type should be used?

Network Topology
+
Question 15mediummultiple choice
Full question →

Refer to the exhibit. A data engineer is setting up data acquisition from an S3 bucket with this policy. What does the policy enforce?

Exhibit

Refer to the exhibit.
```json
{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": "s3:GetObject",
      "Resource": "arn:aws:s3:::data-bucket/*",
      "Condition": {
        "IpAddress": {"aws:SourceIp": "10.0.0.0/8"}
      }
    }
  ]
}
```

These DA0-001 practice questions are part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style DA0-001 questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.