D467 EXPLORING DATA (Computer Graphics)
EXAM QUESTIONS AND ANSWERS WESTERN
GOVERNORS’ UNIVERSITY
An analyst wants to present a high-level summarized version of the data at
the end of data cleansing. Which spreadsheet functionality should the
analyst use?
Conditional formatting
Pivot table
Find and replace
Filters
✔✔Pivot table
What is the definition of verification in the data cleaning process?
A process of ensuring the degree to which a set of measures is equivalent
across systems
A process of chronologically listing the modifications made to a set of data
files during the data cleansing process
A process to confirm how accurate and reliable a data set is following data
cleaning
A process to report on the results of data cleansing efforts to help build
trust in the data and cleansing
✔✔A process to confirm how accurate and reliable a data set is following
data cleaning
,What is an outcome of the verification step of data cleansing?
Compares dirty data with clean data
Ensures the data collected and cleansed will address the original purpose
Chronologically documents how the data set evolved during the project
Helps build trust in the cleansing process and data
✔✔Ensures the data collected and cleansed will address the original
purpose
An analyst used a column of a table to uniquely identify each record within
a table. Which tool did they use?
Normalization
Field
Foreign key
Primary key
✔✔Primary key
Which tool is used by data analysts to store and organize data, making it
easier for them to manage and access information?
Primary key
Table
Database
,Foreign key
✔✔Database
Which element of a Notepad file would be considered data as opposed to
underlying metadata?
File contents
File description
FIle date
File size
✔✔File contents
What is an example of administrative metadata for a digital file?
File size
File name
File contents
File permission
✔✔File permission
What is an acceptable syntax for the SELECT keyword in MySQL?
"select"
select
, SELECT_Keyword
'select'
✔✔select
An expert in query languages searched for month_name = DEC using
Vertica. The data set contains variations of the word December, such as
dec, Dec, etc. What will the output of this search query be?
It will return all entries that match DEC only.
It will return all entries that match dec only.
It will return all entries such as dec, Dec, DEC.
It will return all entries that match Dec only.
✔✔It will return all entries that match DEC only.
What is the general rule regarding the suggested length of each line in a
query to maintain indentation best practices?
Less than or equal to 50 characters
Greater than or equal to 100 characters
Less than or equal to 100 characters
Greater than or equal to 50 characters
✔✔Less than or equal to 100 characters
What is a feature of the filtering process when applied to spreadsheets?
EXAM QUESTIONS AND ANSWERS WESTERN
GOVERNORS’ UNIVERSITY
An analyst wants to present a high-level summarized version of the data at
the end of data cleansing. Which spreadsheet functionality should the
analyst use?
Conditional formatting
Pivot table
Find and replace
Filters
✔✔Pivot table
What is the definition of verification in the data cleaning process?
A process of ensuring the degree to which a set of measures is equivalent
across systems
A process of chronologically listing the modifications made to a set of data
files during the data cleansing process
A process to confirm how accurate and reliable a data set is following data
cleaning
A process to report on the results of data cleansing efforts to help build
trust in the data and cleansing
✔✔A process to confirm how accurate and reliable a data set is following
data cleaning
,What is an outcome of the verification step of data cleansing?
Compares dirty data with clean data
Ensures the data collected and cleansed will address the original purpose
Chronologically documents how the data set evolved during the project
Helps build trust in the cleansing process and data
✔✔Ensures the data collected and cleansed will address the original
purpose
An analyst used a column of a table to uniquely identify each record within
a table. Which tool did they use?
Normalization
Field
Foreign key
Primary key
✔✔Primary key
Which tool is used by data analysts to store and organize data, making it
easier for them to manage and access information?
Primary key
Table
Database
,Foreign key
✔✔Database
Which element of a Notepad file would be considered data as opposed to
underlying metadata?
File contents
File description
FIle date
File size
✔✔File contents
What is an example of administrative metadata for a digital file?
File size
File name
File contents
File permission
✔✔File permission
What is an acceptable syntax for the SELECT keyword in MySQL?
"select"
select
, SELECT_Keyword
'select'
✔✔select
An expert in query languages searched for month_name = DEC using
Vertica. The data set contains variations of the word December, such as
dec, Dec, etc. What will the output of this search query be?
It will return all entries that match DEC only.
It will return all entries that match dec only.
It will return all entries such as dec, Dec, DEC.
It will return all entries that match Dec only.
✔✔It will return all entries that match DEC only.
What is the general rule regarding the suggested length of each line in a
query to maintain indentation best practices?
Less than or equal to 50 characters
Greater than or equal to 100 characters
Less than or equal to 100 characters
Greater than or equal to 50 characters
✔✔Less than or equal to 100 characters
What is a feature of the filtering process when applied to spreadsheets?
