D467 WGU Exploring Data exam questions updated version, Exams of Advanced Education

D467 WGU Exploring Data exam questions updated version

Typology: Exams

2025/2026

Available from 06/27/2026

tizian-mwangi
tizian-mwangi šŸ‡ŗšŸ‡ø

4.1

(8)

29K documents

1 / 19

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1 / 19
D467 WGU Exploring Data exam questions updated
version
1.
To track people's online activities and interests, which method
of data col-
lection is most effective?: Cookies
2.
What
are
cookies?:
Small
files
stored
on
computers
that
contain
information
about
users
3.
Fill in the blank: For
data analytics projects,
data is typically
preferred because users know it originated within the
organization.:
first-party
4.
In data analytics, what term refers to all possible data values in a
dataset?-
:
Population
5.
A grocery store chain purchases customer data from a credit
card company. The grocer uses this data to identify its most loyal
customers and offer them special promotions and discounts. What
type of data is being used in this
scenario?: Second-party
6. What type of data is the height of a skyscraper?:
Continuous
7.
In data analytics, what is the term for data that is generated
from, and lives,
outside of an: External
8. Fill in the blank: A
data model is used to organize and how they
relate to one another.: data elements
9.
When discussing structured databases, data analysts refer to the
data con-tained in a row as a record. How do they refer to the data
contained in a
column?: Field
10.
Fill in the
blank: A data type is a specific kind of data
that tells
what
kind of value the data is.: attribute
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13

Partial preview of the text

Download D467 WGU Exploring Data exam questions updated version and more Exams Advanced Education in PDF only on Docsity!

1 / 19

D467 WGU Exploring Data exam questions updated

version

  1. To track people's online activities and interests, which method of data col-lection is most effective?: Cookies
  2. What are cookies?: Small files stored on computers that contain information about users
  3. Fill in the blank: For data analytics projects, data is typically preferred because users know it originated within the organization.: first-party
  4. In data analytics, what term refers to all possible data values in a dataset?- : Population
  5. A grocery store chain purchases customer data from a credit card company. The grocer uses this data to identify its most loyal customers and offer them special promotions and discounts. What type of data is being used in this scenario?: Second-party
  6. What type of data is the height of a skyscraper?: Continuous
  7. In data analytics, what is the term for data that is generated from, and lives, outside of an: External
  8. Fill in the blank: A data model is used to organize and how they relate to one another.: data elements
  9. When discussing structured databases, data analysts refer to the data con-tained in a row as a record. How do they refer to the data contained in a column?: Field
  10. Fill in the blank: A data type is a specific kind of data that tells what kind of value the data is.: attribute

2 / 19

  1. In a data table, where are fields contained?: Columns
  2. When using long data, each subject has data in multiple rows. This is because each row represents what?: One observation per subject
  3. Fill in the blank: The number of stars awarded to a product review is an example of data.: discrete
  4. A data analyst works on an urgent traffic study. As a result of the short time frame, which type of data might yield the best results?: Historical
  5. A political scientist needs to poll all voters in Seoul, South Korea, in order to predict the outcome of an election. Because it would be impossible to collect data from every single person in the city, the political scientist polls a part of the population that is representative of the whole. What does this scenario describe?: Using a sample
  6. A data scientist at a tech company records whether users have accepted their company's terms of service or not. What data type is being collected in this scenario?: Boolean
  7. Which of the following questions would enable a data professional to collect nominal qualitative data?: Did anyone recommend our music lessons to you?
  8. Fill in the blank: Bias is a preference in favor of or against a person, group of people, or thing.: conscious or subconscious
  9. What is the term for the tendency to search for or interpret information in a way that validates pre-existing beliefs?: Confirmation bias
  10. Fill in the blank: Data is considered when it is accurate, complete, and unbiased information that has been vetted and proven fit for use.: reliable
  11. A junior data analyst learns that the dataset they have been

4 / 19

  1. A university surveys its student-athletes about their experience in college sports. The survey only includes student- athletes with scholarships. What type of bias does this scenario describe?: Sampling
  2. Fill in the blank: The data ethics principle of states that an individual has the right to understand all of the data processing activities and algorithms used on their data.: transaction transparency
  3. A financial institution publishes data about stock prices and market trends, which any business, nonprofit, or citizen can access, reuse, or redistribute through its online databases. What type of data is described in this scenario?- : Open
  4. Fill in the blank: A relational database contains a series of that can be connected to form relationships.: tables
  5. What is the term for an identifier that references a database column in which each value is unique?: Primary key
  6. What process do data professionals use to eliminate data redundancy, increase data integrity, and reduce complexity in a database?: Normalization
  7. F ill in the blank: When using a relational database, data analysts write to request data from the related tables.: queries
  8. 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
  9. 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 num-bers?: Descriptive
  10. Fill in the blank: Data is a process data

5 / 19 professionals use to ensure the formal management of their organization's data assets.: governance

  1. What type of file saves data in a table format?: Comma-separated values (.csv)
  2. Bringing data from a .csv file into a spreadsheet is an example of what process?: Importing data
  3. In Google Sheets, what function enables a data analyst to specify a range of cells in one spreadsheet to be duplicated in another?: IMPORTRANGE
  4. What is the process for arranging data into a meaningful order to make it easier to understand, analyze, and visualize?: Sorting
  5. 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?: Filter out non-condominium sales
  6. 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 descending order
  7. Fill in the blank: To keep a header row at the top of a spreadsheet, highlight the row and select from the View menu.: freeze
  8. Fill in the blank: When using SQL, the clause can be used to filter a dataset of customers to only include people who have made a purchase in the past month.: WHERE
  9. A database table is named WebTrafficAnalytics. What type of case is this?: - Camel case
  10. What can be removed from the following query without preventing it from running? SELECT * FROM Uni_dataset.new_table

7 / 19 protected

  1. What data-security practice enables all collaborators within a file to track changes, such as who made what edits to the file, when they were made, and why?: Version control
  2. You are in charge of your company's weekly accounting spreadsheet. It has 15 sheets, each containing a different employee's purchases. You add restrictions to the spreadsheet to make sure employees can only edit their own sheets. What practice does this scenario describe?: Data security
  3. A data analytics team uses data about data to indicate consistent naming conventions for a project. What type of data is involved in this scenario?: Meta-data
  4. A data analyst uses to organize multiple files for a given project so they can be found and accessed in an efficient manner.: foldering
  5. Fill in the blank: To keep files organized, use a logical to organize folders and subfolders.: hierarchy
  6. Which example shows the use of primary data?: A company's survey data of its customers' satisfaction
  7. What is the difference between raw data and information?: Raw data is unorga-nized, while information is structured.
  8. Which role does an analyst have in collecting second-party data?: Contracts with an external entity
  9. An analyst needs to show the geographic distribution of customers in the United States by region. Which visual representation should this analyst use?: Charts
  10. Which type of structured data does an analyst use?: Store inventory
  11. What is an example of conceptual data modeling that an analyst uses?: Defin-ing the business requirements for a new database
  12. What leads to confirmation bias in data collection?: People search to

8 / 19 verify preexisting beliefs.

  1. How does an analyst ensure that a data source is reliable?: It is accurate, complete, and unbiased information.
  2. What should an analyst consider at the start of data collection to reduce errors?: Bias and fairness
  3. How does an analyst apply data ethics to privacy and collection?: By using the collected data responsibly
  4. How does an analyst apply the principle of ownership to ethics and privacy in data collection?: Individuals who create the data should own it.
  5. How does an analyst apply the principle of consent to ethics and privacy in data collection?: By disclosing how and why the data will be used before the survey
  6. An analyst used a column of a table to uniquely identify each record within a table. Which tool did they use?: Primary key
  7. Which tool is used by data analysts to store and organize data, making it easier for them to manage and access information?: Database
  8. Which element of a Notepad file would be considered data as opposed to underlying metadata?: File contents
  9. What is an example of administrative metadata for a digital file?: File permission
  10. What is an acceptable syntax for the SELECT keyword in MySQL?: select
  11. An expert in query languages searched for month_name = 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.
  12. 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 100 characters
  13. What is a feature of the filtering process when applied to

10 / 19

  1. A research team conducts an experiment to determine if a new cybersecu-rity tool is more effective than the previous version. What type of results are required for the experiment to be statistically significant?: Results that are real and not caused by random chance
  2. In order to have a high confidence level in a customer survey, what should the sample size accurately reflect?: The entire population
  3. Fill in the blank: Typically, a data professional aims to achieve a statistical power of at least to consider their results statistically significant.: 0.8, or 80%
  4. Fill in the blank: Margin of error is the amount that the sample results are expected to differ from those of the actual population.: maximum
  5. In a survey about a new gardening product, 80% of respondents report they would buy the product again. The margin of error for the survey is 5%. Based on that margin of error, what range reflects the population's true response?: 75-85%
  6. In an employee satisfaction survey, 60% of respondents report that they prefer commuting to work via train. The margin of error for the survey is 4%. Based on that margin of error, what range reflects the population's true response?: 56-64%
  7. Fill in the blank: If a test is statistically , the results are less likely to be due to random chance and more likely to be due to a real difference between the groups being compared.: significant
  8. As an analyst downloads a dataset from the internet to their local drive, their internet connection goes down. This interrupts the download, causing them to have an incomplete copy of the dataset on their computer. What data integrity problem does this scenario describe?: Transfer
  9. A delivery company stores customer data in a delivery

11 / 19 database and a customer relationship database. When a customer changes their shipping address, the change is not reflected in the delivery database. This leads to the shipments being delivered to the wrong address. What data integrity problem does this scenario describe?: Replication

  1. Fill in the blank: Hypothesis testing is a process to determine whether a survey or has meaningful results.: experiment
  2. Fill in the blank: Data is a cleaning feature to check the accuracy and quality of data before adding or importing it.: validation
  3. Which data professionals are most often responsible for ensuring that data is available, secure, and backed up to prevent loss?: Data warehousing specialists
  4. Fill in the blank: If a dataset contains , this is an indication that those values do not exist in the dataset.: nulls
  5. A data professional works in a spreadsheet column that can only contain six-digit customer ID numbers. They ensure the data points in the column are always exactly six-digits long using which data analytics tool?: Field length
  6. Fill in the blank: Data validation is a tool for checking the of data before adding or importing it.: accuracy and quality
  7. To create a clean and consistent visual appearance for a spreadsheet, which tool ensures all font types, sizes, and colors are uniform?: Clear formats
  8. What is the process of combining two or more datasets into a single dataset?: Data merging
  9. Fill in the blank: In data analytics, describes how well two or more datasets are able to work together.: compatibility

13 / 19

  1. Which spreadsheet tool searches for matches to a specified value in one column, returning a corresponding piece of information from another loca-tion?: vlookup
  2. Fill in the blank: When typing a LEN function, the correct to follow is =LEN(range).: syntax
  3. Fill in the blank: In a VLOOKUP function, the value of the third argument tells VLOOKUP to return the value in the row from the specified column.- : same
  4. A data analyst wants to make sure their dataset contains only numbers below 500 from cell G2 through cell G100. Which of the following COUNTIF statements could they use? Select all that apply.: =COUNTIF(G2:G100,"<500")
  5. A data analyst suspects that there are some nulls in their spreadsheet. In order to identify those missing values, they use a spreadsheet tool that changes how cells appear when values meet specific conditions. What tool do they use?: Conditional formatting
  6. Which SQL function cleans string variables by extracting a substring from a string variable?: SUBSTR
  7. You are working with a database table that contains data about playlists, and you discover there are duplicate entries. What SQL clause will remove the duplicates from the playlist_id column?: SELECT DISTINCT playlist_id
  8. You are working with a database table that contains data about turtles. What SQL clause will return any turtle ages that are less than three digits long from the turtle_age column?: LENGTH(turtle_age) < 3
  9. You are working with a database table that contains data about cookbooks. What SQL clause will retrieve the first eight letters of each data point in the recipe_name column, then store the result in

14 / 19 a new column called recipe_list-ing?: SUBSTR(recipe_name, 1, 8) AS recipe_listing

  1. A data analyst knows there are some nulls in their database table. They want to save time when making calculations by excluding these nulls. Which SQL function syntax can they use in their query to return non-null values for one or more fields?: COALESCE (product, product_code)

16 / 19

  1. A team is tasked with determining how many customers have made a pur-chase in the past month. Using a pivot table in Google Sheets, what function will total the number of non-empty sales in the purchase_date column of its customer database?: CountA

17 / 19

  1. Fill in the blank: A data analyst keeps important code in a , enabling other developers on the team to access the most current version of the code and collaborate effectively.: version control system
  2. Which SQL clause will consider the condition 'Florida' and return the value 'East' when that condition is met?: CASE WHEN us_states = 'Florida' THEN 'East' END
  3. Which statement is true about sampling, irrespective of sample size?: The sample bias is reduced if the sample being selected is representative of the population.
  4. 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.
  5. In the next six months, an analyst is expected to analyze and present the effects of monthly promotions on sales of a new product released one month ago. Which solution for insufficient data should this analyst pursue?: Wait for more data
  6. A team leader is assigned the task of evaluating the schema of a data set as part of data cleansing. How would the team leader define a schema to the analyst collaborating on the project prior to commencing cleansing?: A way of describing how something is organized
  7. An analyst performing data cleansing on invoice data would like to select and view rows that have an amount paid that is greater than $100. Which spreadsheet functionality should the analyst use?: Filter
  8. Why is clean data critical for data analysis?: It ensures data used for analysis reflects operational reality.
  9. What does an UPDATE statement do after execution in Structured Query Language (SQL)?: Modifies values in certain cells of a table based on conditions

19 / 19

  1. An analyst wants to combine the fields for city and state into a single field prior to extraction for data cleansing. Which Structured Query Language (SQL) statement will perform this function?: CONCAT statement
  2. 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?: Pivot table
  3. What is the definition of verification in the data cleaning process?: A process to confirm how accurate and reliable a data set is following data cleaning
  4. What is an outcome of the verification step of data cleansing?: Ensures the data collected and cleansed will address the original purpose