WGU D467 EXAM EXPLORING DATA OBJECTIVE
ASSESSMENT | ALL QUESTIONS AND CORRECT
ANSWERS | ALREADY GRADED A+ | VERIFIED
ANSWERS | LATEST EXAM
A large company has several databases across its many departments.
What kind of metadata describes how many locations contain a certain
piece of data?
Structural
Administrative
Descriptive
Representative ---------CORRECT ANSWER-----------------Structural
A large metropolitan high school gives each of its students an ID number to
differentiate them in its database. What kind of metadata are the ID
numbers?
Administrative
Structural
Descriptive
Representative ---------CORRECT ANSWER-----------------Descriptive
An international nonprofit organization wants to merge third-party data with
its own data. Which of the following actions will help make this process
successful? Select all that apply.
Use metadata to standardize the datasets.
Replace the incoming data's metadata with its own company metadata.
Use metadata to evaluate the third-party data's quality and credibility.
Alter the internal metadata to more closely reflect the incoming metadata. --
-------CORRECT ANSWER-----------------Use metadata to standardize the
datasets
Use metadata to evaluate the third-party data's quality and credibility
,Fill in the blank: Data _____ is a process data professionals use to ensure
the formal management of their organization's data assets.
sourcing
governance
organization
storage ---------CORRECT ANSWER-----------------governance
What are some key benefits of open-data initiatives? Select all that apply.
Limit opportunities for collaboration
Make government activities more transparent
Support innovation and economic growth
Help educate citizens about important issues ---------CORRECT ANSWER--
---------------Make government activities more transparent
Support innovation and economic growth
Help educate citizens about important issues
What type of file saves data in a table format?
Calculated spreadsheet values (.csv)
Comma-separated values (.csv)
Cell-structured variables (.csv)
Compatible scientific variables (.csv) ---------CORRECT ANSWER-------------
----Comma-separated values (.csv)
Bringing data from a .csv file into a spreadsheet is an example of what
process?
Filing data
Importing data
,Editing data
Normalizing data ---------CORRECT ANSWER-----------------Importing data
In Google Sheets, what function enables a data analyst to specify a range
of cells in one spreadsheet to be duplicated in another?
SPECIFY
DUPLICATE
IMPORTRANGE
CELLRANGE ---------CORRECT ANSWER-----------------IMPORTRANGE
What is the process for arranging data into a meaningful order to make it
easier to understand, analyze, and visualize?
Filtering
Prioritizing
Reframing
Sorting ---------CORRECT ANSWER-----------------Sorting
A data analyst is reviewing a national database of real estate sales. They
are only interested in sales of condominiums. How can the analyst narrow
their scope?
Sort by condominium sales
Filter out non-condominium sales
Filter out condominium sales
Sort by non-condominium sales ---------CORRECT ANSWER-----------------
Filter out non-condominium sales
A data analyst works for a rental car company. They have a spreadsheet
that lists car ID numbers and the dates cars were returned. How should
they sort the spreadsheet to find the most recently returned cars?
, By return date, in ascending order
By return date, in descending order
By car numerical ID, in ascending order
By car numerical ID, in descending order ---------CORRECT ANSWER-------
----------By return date, in descending order
Fill in the blank: To keep a header row at the top of a spreadsheet, highlight
the row and select _____ from the View menu.
set
lock
freeze
pin ---------CORRECT ANSWER-----------------freeze
Which statement is true about sampling, irrespective of sample size?
The sample standard deviation (Stdev) is the same as the population
Stdev.
The sample distribution approximates to normal distribution.
The sample bias is reduced if the sample being selected is representative
of the population.
The sample mean approaches the population mean ---------CORRECT
ANSWER-----------------The sample bias is reduced if the sample being
selected is representative of the population.
A data analyst is performing analysis on data stored in a big data platform
with state-of-the-art analysis tools. Insufficient sample size is rendering the
current analysis ineffective. What is the primary challenge of a larger
sample size?
Collecting a larger sample size is more expensive.
Analyzing a larger sample size is complex.
Storing a larger sample size is difficult.
ASSESSMENT | ALL QUESTIONS AND CORRECT
ANSWERS | ALREADY GRADED A+ | VERIFIED
ANSWERS | LATEST EXAM
A large company has several databases across its many departments.
What kind of metadata describes how many locations contain a certain
piece of data?
Structural
Administrative
Descriptive
Representative ---------CORRECT ANSWER-----------------Structural
A large metropolitan high school gives each of its students an ID number to
differentiate them in its database. What kind of metadata are the ID
numbers?
Administrative
Structural
Descriptive
Representative ---------CORRECT ANSWER-----------------Descriptive
An international nonprofit organization wants to merge third-party data with
its own data. Which of the following actions will help make this process
successful? Select all that apply.
Use metadata to standardize the datasets.
Replace the incoming data's metadata with its own company metadata.
Use metadata to evaluate the third-party data's quality and credibility.
Alter the internal metadata to more closely reflect the incoming metadata. --
-------CORRECT ANSWER-----------------Use metadata to standardize the
datasets
Use metadata to evaluate the third-party data's quality and credibility
,Fill in the blank: Data _____ is a process data professionals use to ensure
the formal management of their organization's data assets.
sourcing
governance
organization
storage ---------CORRECT ANSWER-----------------governance
What are some key benefits of open-data initiatives? Select all that apply.
Limit opportunities for collaboration
Make government activities more transparent
Support innovation and economic growth
Help educate citizens about important issues ---------CORRECT ANSWER--
---------------Make government activities more transparent
Support innovation and economic growth
Help educate citizens about important issues
What type of file saves data in a table format?
Calculated spreadsheet values (.csv)
Comma-separated values (.csv)
Cell-structured variables (.csv)
Compatible scientific variables (.csv) ---------CORRECT ANSWER-------------
----Comma-separated values (.csv)
Bringing data from a .csv file into a spreadsheet is an example of what
process?
Filing data
Importing data
,Editing data
Normalizing data ---------CORRECT ANSWER-----------------Importing data
In Google Sheets, what function enables a data analyst to specify a range
of cells in one spreadsheet to be duplicated in another?
SPECIFY
DUPLICATE
IMPORTRANGE
CELLRANGE ---------CORRECT ANSWER-----------------IMPORTRANGE
What is the process for arranging data into a meaningful order to make it
easier to understand, analyze, and visualize?
Filtering
Prioritizing
Reframing
Sorting ---------CORRECT ANSWER-----------------Sorting
A data analyst is reviewing a national database of real estate sales. They
are only interested in sales of condominiums. How can the analyst narrow
their scope?
Sort by condominium sales
Filter out non-condominium sales
Filter out condominium sales
Sort by non-condominium sales ---------CORRECT ANSWER-----------------
Filter out non-condominium sales
A data analyst works for a rental car company. They have a spreadsheet
that lists car ID numbers and the dates cars were returned. How should
they sort the spreadsheet to find the most recently returned cars?
, By return date, in ascending order
By return date, in descending order
By car numerical ID, in ascending order
By car numerical ID, in descending order ---------CORRECT ANSWER-------
----------By return date, in descending order
Fill in the blank: To keep a header row at the top of a spreadsheet, highlight
the row and select _____ from the View menu.
set
lock
freeze
pin ---------CORRECT ANSWER-----------------freeze
Which statement is true about sampling, irrespective of sample size?
The sample standard deviation (Stdev) is the same as the population
Stdev.
The sample distribution approximates to normal distribution.
The sample bias is reduced if the sample being selected is representative
of the population.
The sample mean approaches the population mean ---------CORRECT
ANSWER-----------------The sample bias is reduced if the sample being
selected is representative of the population.
A data analyst is performing analysis on data stored in a big data platform
with state-of-the-art analysis tools. Insufficient sample size is rendering the
current analysis ineffective. What is the primary challenge of a larger
sample size?
Collecting a larger sample size is more expensive.
Analyzing a larger sample size is complex.
Storing a larger sample size is difficult.
