Skip to main content

Data+ Practice Test (V2)

Dive into practice questions

Question 1

Which of the following supports capabilities such as automatic versioning, corruption checks, KPIs, and user authentication?

A. Notebook

B. REST API

C. Pipeline

D. Source control

Question 2

Which of the following is a NoSQL database?

A. PostgreSQL

B. MySQL

C. Oracle

D. MongoDB

Question 3

A data analyst receives a set of requirements to create an analytical report that focuses on locations and distances as they relate to a city. Which of the following visual elements is the most appropriate for this task?

A. Gantt chart

B. Infographic

C. Map

D. Storyboard

Question 4

A data analyst receives the following sales data for a convenience store:

Item Quantity Price
Chocolate Bars 7 $1.99
Vanilla Ice 2 $4.99
Chocolate Wafers 6 $0.99
Peanut Butter Cups 2 $2.99
Strawberry Jam 3 $4.99
Chocolate Cake 9 $6.99
Milk Chocolate Almonds 2 $2.99
The analyst needs to provide information on the products that contain chocolate. Which of the following RegEx should the analyst use to filter for the chocolate products?

A. Chocolate!

B. Chocolate%

C. %Chocolate&

D. %Chocolate%

Question 5

An administrator needs to design a table that will include foreign words. Which of the following is the best option for storing non-native language characters?

A. varchar

B. nvarchar

C. CLOB

D. char

Question 6

A data analyst is combining data from these two tables:
  
 Sales

Company Region Sales ($)
Company 1 West 200000
Company 2 West 400000
Company 2 East 500000
Company 3 South 300000
 Headcount
Company Headcount
Company 1 50
Company 2 40
Company 4 10
 Which of the following queries should the analyst use to produce a final data set consisting of five rows? 

A. SELECT *
  FROM SALES
       INNER JOIN HEADCOUNT
 WHERE SALES.COMPANY = HEADCOUNT.COMPANY

B. SELECT *
  FROM SALES
       FULL JOIN HEADCOUNT
 WHERE SALES.COMPANY = HEADCOUNT.COMPANY

C. SELECT *
  FROM SALES
       RIGHT OUTER JOIN HEADCOUNT
 WHERE SALES.COMPANY = HEADCOUNT.COMPANY

D. SELECT *
  FROM SALES
       LEFT OUTER JOIN HEADCOUNT
 WHERE SALES.COMPANY = HEADCOUNT.COMPANY

Question 7

Which of the following is the best place to store digital documents?

A. Dimensional table

B. Data warehouse

C. Container

D. Non-relational database

Question 8

The sales department wants to include the composition of total sales amounts across all three sales channels in a report. Given the following sample sales table:

Sales channel Month Sales amount (million $)
Digital January 135
Store February 145
Online March 165
Store April 200
Store May 125
Store June 155
Online July 120
Digital August 145
Store September 160
 Which of the following visualizations is the most appropriate?

A. Pivot table

B. Pie chart

C. KPI card

D. Box plot

Question 9

An analyst must use the same data to create reports for police patrol supervisors, the city council, and a public website. Which of the following is the best way to differentiate the reports?

A. Persona type

B. Detail levels

C. Accessibility

D. Sensitivity

Question 10

A data analyst has been given the following dataset:

Name B-Day Date of Birth Termination Date
Kimberly 11/4 Nov 4th  
Blake 11/18 Nov 18th 5/15/2024
Camaron 12/14 Dec 14th 8/2/2023
Craig 7/17 July 17th  
 Which of the following would best describe the quality issue with the dataset?

A. Redundancy

B. Outliers

C. Missing Values

D. Duplication

Answer key

Question 1: D (Source control)

Question 2: D (MongoDB)
Question 3: C (Map)
Question 4: D (%Chocolate%)
Question 5: B (nvarchar)
Question 6: B (SELECT *
  FROM SALES
       FULL JOIN HEADCOUNT
 WHERE SALES.COMPANY = HEADCOUNT.COMPANY)
Question 7: D (Non-relational database)
Question 8: B (Pie chart)
Question 9: A (Persona type)

Question 10: A (Redundancy)