Page 1 of 38
D467 WGU Exploring Data EXAM ALL
QUESTIONS AND CORRECT ANSWERS
LATEST UPDATE THIS YEAR NEW!!
An analyst identifies that people with disabilities tend to be excluded from mainstream
health research.What does this indicate to the analyst about the research?
It is not a representative sample.
What is a benefit of open data to an analyst concerned with ethics and privacy in data
collection?
Credible databases can be used more widely.
An analyst is working with an external group to collect information about customer e-
commerce purchases on a website. The analyst is concerned about using data ethically and
understands that personally identifiable information (PII) is data that is reasonably likely to
identify a person.Which factor should this analyst consider?
The names of individuals should be kept safe.
What should an analyst consider when accessing open data to adhere to ethics and privacy
standards in data collection?
Consider the harm of using data
1
,Page 2 of 38
Which example describes the principle of ownership to ethics and privacy in data collection?
Participants can remove their data at any time.
How should an analyst apply the principle of data privacy in data collection?
By preserving a participant's right to data
What is a consequence of an analyst working in isolation on openness policies for data
collection?
Amplifying or reinforcing unfair biases
A data analyst wants to connect a revenue table and cost table by the fields they have in
common to create a table.What should this data analyst use to connect the two tables?
A common primary key to the revenue table and the cost table
How does normalization affect data in a relational database?
It will increase data integrity.
Which type of metadata indicates how a piece of data is organized?
Structural metadata
What helps an organization with issues related to data security and privacy, integrity,
usability, and internal and external data flows?
data governance
2
,Page 3 of 38
Which element of a table is uniquely identified by a primary key?
each row
A student visits Data.gov to access the data sets provided by the United States government.
Which type of data will the student find there?
open data
What is the primary role of a metadata repository?
to store metadata
Which type of metadata keeps track of the relationship between two elements of data?
Structural metadata
What is a specialized tool used by data analysts to view specific data from within a larger set?
Structured Query Language (SQL)
Which decision does an analyst make if they use existing internal data?
Which data to use
Which factor helps an analyst add context to open-access data?
Knowing how it has been generated
3
, Page 4 of 38
An analyst wants to visually represent some of the information included in a client report.
Which description accurately describes a Venn diagram the analyst might include?
A visual illustration that utilizes circles to depict relationships between accounts
Which question should an analyst ask regarding a concern about collecting primary data?
Is the sample representative?
Which type of quantitative data does an analyst use?
Purchasing amounts
Which discrete and quantitative data does an analyst use?
Product sales
An analyst needs to format a data set to identify how satisfied customers are with one
product category compared to others.
Ranking a product as number one compared to others
An analyst needs to describe subjective measures of characteristics in the fashion industry at
a given moment. Which type of data should this analyst use?
Qualitative
How should an analyst address bias in data collection?
Recognize and manage patterns of thinking
4
D467 WGU Exploring Data EXAM ALL
QUESTIONS AND CORRECT ANSWERS
LATEST UPDATE THIS YEAR NEW!!
An analyst identifies that people with disabilities tend to be excluded from mainstream
health research.What does this indicate to the analyst about the research?
It is not a representative sample.
What is a benefit of open data to an analyst concerned with ethics and privacy in data
collection?
Credible databases can be used more widely.
An analyst is working with an external group to collect information about customer e-
commerce purchases on a website. The analyst is concerned about using data ethically and
understands that personally identifiable information (PII) is data that is reasonably likely to
identify a person.Which factor should this analyst consider?
The names of individuals should be kept safe.
What should an analyst consider when accessing open data to adhere to ethics and privacy
standards in data collection?
Consider the harm of using data
1
,Page 2 of 38
Which example describes the principle of ownership to ethics and privacy in data collection?
Participants can remove their data at any time.
How should an analyst apply the principle of data privacy in data collection?
By preserving a participant's right to data
What is a consequence of an analyst working in isolation on openness policies for data
collection?
Amplifying or reinforcing unfair biases
A data analyst wants to connect a revenue table and cost table by the fields they have in
common to create a table.What should this data analyst use to connect the two tables?
A common primary key to the revenue table and the cost table
How does normalization affect data in a relational database?
It will increase data integrity.
Which type of metadata indicates how a piece of data is organized?
Structural metadata
What helps an organization with issues related to data security and privacy, integrity,
usability, and internal and external data flows?
data governance
2
,Page 3 of 38
Which element of a table is uniquely identified by a primary key?
each row
A student visits Data.gov to access the data sets provided by the United States government.
Which type of data will the student find there?
open data
What is the primary role of a metadata repository?
to store metadata
Which type of metadata keeps track of the relationship between two elements of data?
Structural metadata
What is a specialized tool used by data analysts to view specific data from within a larger set?
Structured Query Language (SQL)
Which decision does an analyst make if they use existing internal data?
Which data to use
Which factor helps an analyst add context to open-access data?
Knowing how it has been generated
3
, Page 4 of 38
An analyst wants to visually represent some of the information included in a client report.
Which description accurately describes a Venn diagram the analyst might include?
A visual illustration that utilizes circles to depict relationships between accounts
Which question should an analyst ask regarding a concern about collecting primary data?
Is the sample representative?
Which type of quantitative data does an analyst use?
Purchasing amounts
Which discrete and quantitative data does an analyst use?
Product sales
An analyst needs to format a data set to identify how satisfied customers are with one
product category compared to others.
Ranking a product as number one compared to others
An analyst needs to describe subjective measures of characteristics in the fashion industry at
a given moment. Which type of data should this analyst use?
Qualitative
How should an analyst address bias in data collection?
Recognize and manage patterns of thinking
4