Exit
Data Engineering Fundamentals Exam | Playfair+ | Playfair Data
Data Prep Fundamentals Exam
What to know:
Only Playfair+
Core
and
Premium
members are eligible
You will need the
Proxy
dataset
This test is designed to take 60 – 90 minutes
You must answer 20 of 25 questions correctly to pass
Following the exam, we’ll review your answers and respond within 3 – 5 business days.
Get Started
Step
1
of
26
3%
The questions in this exam are from Playfair Data's Proxy dataset. Download the latest version here
What does the acronym DBMS stand for?
A. Database Matching Software
B. Database Management System
C. Durable Basic Memory Storage
D. Double Binary Metric System
Which of the following do data engineers not traditionally support?
A. Visual Analytics
B. Data Management
C. User Experience & Design
D. Data Governance
What does the acronym API stand for?
A. Application Programming Interface
B. Application Project Information
C. Administrative Planning Interface
D. Application Programming Information
Which of these tasks would not fall under Data Engineering?
A. Transform raw data into accurate data in a readable format.
B. Build data pipelines that quickly deliver data to a central storage location.
C. Set backup and privacy settings for databases.
D. Design a user interface for end users to view data insights.
Which of the following is true about null values?
A. Nulls can have functions called on them.
B. Nulls retain the metadata.
C. Nulls are a string value of " ".
D. None of the above
In which of these situations would it make sense to replace null values with 0s?
A. A column of numbers where the null values represent pending lab results.
B. A column of customer names where the null values represent no discount applied.
C. A column of numbers where the null values represent months with no total orders.
D. A column of temperatures where the null values represent unreported data.
Which of these is a SQL clause? (Filter, Keep, From, Skip)
A. Filter
B. From
C. Keep
D. Skip
Put the SQL clauses in the appropriate order:
A. Group By, Having, Where, Order By
B. Where, Order By, Group By, Having
C. Where, Group By, Having, Order By
D. Order By, Where, Having, Group By
Which of these data formats are unstructured data?
A. Tables
B. Media files (images, videos, audio)
C. JSON files
D. Relational Databases
What character is used as a delimiter in csv files?
A. Pipe: “|”
B. A single space: “ “
C. Comma: “,”
D. Colon: “:”
How many rows would an inner join between these tables generate?
A. 3
B. 4
C. 5
D. 6
How many rows would a left join generate?
A. 4
B. 5
C. 3
D. 6
How many rows would an outer join generate?
A. 6
B. 4
C. 3
D. 5
How many rows would we generate if we filtered out key = A from Table A?
A. 2
B. 4
C. 5
D. 6
If you union Table A to Table B, how many columns would the resulting table have?
A. Four: Key A, Value, Key B, Fruit
B. Three: Key, Value, Fruit
C. Two: Key, Value + Fruit
D. Two: Key, Value
How many null values would exist in the Fruit column after unioning Table A with Table B?
A. None
B. Three
C. Four
D. Twelve
Which table contains a unique ID?
A. Neither
B. Table A
C. Table B
D. Both tables
How many rows would result after an inner join of the Sales and Usage tables using Customer ID?
A. 12,967
B. 1,021,737
C. 1,022,315
D. 1,034,704
If you wanted to transform the Parent Flag column into a new data type, which would be the best option?
A. Boolean
B. Date
C. Float
D. String
How many rows are left if the Sales table is filtered on campaign ID = pf+-aff-1223?
A. 1
B. 10,565
C. 48
D. 1,021,737
How many unique customers are in the Sales and Usage tables?
A. 6,876
B. 12,959
C. 1,034,704
D. 9,880,911
What delimiter is used in the Customer ID?
A. Backslash
B. Comma
C. Dash
D. Pipe
Which column in the sample dataset contains Ordinal data?
A. Product
B. Sales
C. Date
D. None of the Above
If I have two distinct datasets with 3 unique columns each, how many columns would my output have if I unioned these datasets together?
A. 3
B. 9
C. 6
D. Not enough information to tell.
If I am trying to determine if I have duplicates, which field would be a good place to start?
A. Numeric Fields
B. String Fields
C. Secondary Key
D. Primary Key
Let us know who is taking the test:
First Name
(Required)
Last Name
(Required)
Playfair+ Email
(Required)
Phone
Company Name
Δ
0% Completed!
Previous
Next
Cookie Settings
Cookie Settings
