Exam (elaborations)
WGU D467 Study Exam Questions and Answers 2024/2025( A+ GRADED 100% VERIFIED).
- Course
- Institution
WGU D467 Study Exam Questions and Answers 2024/2025( A+ GRADED 100% VERIFIED).
[Show more]
Seller
Follow
Content preview
WGU D467 StudyFill in the blank: A business is determining who should be responsible for the data in their
current data analysis project. This means that the company is in the ______ stage of the data
life cycle.
plan
capture
analyze
manage - ANS plan
A data analyst is working at a small tech startup. They've just completed an analysis project,
which involved private company information about a new product launch. In order to keep the
information safe, the analyst uses secure data-erasure software for the digital files and a
shredder for the paper files. Which state of the data life cycle does this describe?
Plan
Destroy
Archive
Manage - ANS Destroy
In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.
Use spreadsheets to aggregate data
Chooses the format of their spreadsheet headings
Create a report from their data
Use a formula to perform calculations - ANS Use spreadsheets to aggregate data
Create a report from their data
Use a formula to perform calculations
Fill in the blank: Data analysis has six parts that are divided into distinct _____.
data analytics tools
process steps
key questions
stages - ANS process steps?
What actions might a data analytics team take in the act phase of the data analysis process?
Select all that apply.
,Validating insights provided by analysts
Sharing analysis results using data visualization
Putting a plan into action to help solve the original business problem
Finalizing a strategy based on the analysis - ANS Validating insights provided by analysts
Putting a plan into action to help solve the original business problem
Finalizing a strategy based on the analysis
Fill in the blank: A formula is a set of instructions used to perform a specified calculation;
whereas a function is _____.
a preset command
a particular value
a question written by the user
a computer programming language - ANS a preset command
Which of the following is an example of why a data analyst may generate a query?
Visualizing data
Requesting data
Collecting data
Recording data - ANS Requesting data
Fill in the blank: Structured query language (SQL) enables data analysts to _____ information
from a database. Select all that apply.
retrieve
update
visualize
request - ANS retrieve
request
?
In a spreadsheet, what is text wrapping used for?
To clip text within a cell so it doesn't overflow into an adjacent cell
To allow text to overflow into an adjacent cell
To allow all of the text to fit inside a cell
To remove text that is too long to fit in a cell - ANS To allow all of the text to fit inside a cell
By default the columns in a spreadsheet are ordered by letter, and the rows are ordered by
number.
True
False - ANS True
,Fill in the blank: In a data table, a row is called an observation. An observation includes all of the
_____ for what is contained in the row.
names
attributes
commonalities
diagnostics - ANS attributes
What does the asterisk (*) after SELECT tell the database to do in this query?
Select the LastName column from the employee table
Select all data that meets the criteria as stated in the query, then multiply it
Select all columns from the employee table
Select all data that meets the criteria as stated in the query - ANS Select all columns from the
employee table
Fill in the blank: A data visualization is the _____ representation of information.
attributed
graphical
contextual
tabulated - ANS graphical
When would a pie chart be an effective visualization?
When showing the relationship between age and income
When showing a change in someone's age over time
When showing a class broken down by age
When showing the ages of males versus females - ANS When showing a class broken down by
age
What are the key benefits of data visualizations? Select all that apply.
They can ensure that you get fewer questions about your analysis
They can illustrate relationships between data points
They can help stakeholders understand complex data more quickly
They can clearly demonstrate patterns and trends - ANS They can illustrate relationships
between data points
They can help stakeholders understand complex data more quickly
They can clearly demonstrate patterns and trends
Fill in the blank: In the following spreadsheet, the column labels in row 1, population, and
county, are called ________?
, descriptors
attributes
criteria
characteristics - ANS attributes
Fill in the blank: In the following spreadsheet, the feature sort range can be used to ________
the city names in column B?
randomize
delete
change
alphabetize - ANS alphabetize
Fill in the blank: Suppose you wanted to determine the average population of the cities in the
following spreadsheet. The correct function syntax to use would be ________ .
=AVERAGE(C2:C11)
AVERAGE(C2:C11)
=AVERAGE(C2-C11)
AVERAGE(D2:D11) - ANS =AVERAGE(C2:C11)
Fill in the blank: A data analyst creates a table, but they realize this isn't the best visualization
for their data. To fix the problem, they decide to use the ____ feature to change it to a column
chart.
filter view
rename
chart editor
image - ANS chart editor
What steps do data analysts take to ensure fairness when collecting data? Select all that apply.
Include data self-reported by individuals
Use an inclusive sample population
Clean the data provided
Understand the social context - ANS Include data self-reported by individuals
Use an inclusive sample population
Understand the social context
Avens Engineering needs more engineers, so they purchase ads on a job search website. The
website's data reveals that 86% of engineers are men. Based on that number, an analyst
decides that men are more likely to be successful applicants, so they target the ads to male job
seekers. What should the analyst have done instead?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller KINGJAY. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
78140 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now