Discovering Data Wgu questions with verified answers
A business analyst is using Microsoft Excel to determine the total sales for a
region.
Which basic Excel formula should the analyst use to calculate this figure?
Ans✓✓✓ Sum
A business wants to see which locations sold a particular product.
Which conditional SQL (Structured Query Language) query should an analyst
apply to conduct this search? Ans✓✓✓ Where, Narrows the search
A client is worried about long wait lines at their retail store.
Which question would be effective for a better understanding of the problem?
Ans✓✓✓ Which hours have the most customer visits?
A company has experienced a sharp decline in sales due to product recalls. The
vice president of operations is interested in determining which supplier may have
provided the part that caused the product recall but is busy and unable to serve
as the analyst's direct contact.
Which best practice should the analyst apply to manage communication?
Ans✓✓✓ Update the project manager regularly
A company is assessing where and when they should start the advertising process.
They asked the analyst to propose a solution to the problem of advertisement
timing.
,What is the first thing the analyst needs to ask in order to understand the
customer's challenge? Ans✓✓✓ The nature of the problem
A cosmetics subscription service sets a goal to increase sales in Quarter 1 and
again in Quarter 2.
Which SMART goal metric does this satisfy? Ans✓✓✓ Time-bound
A data analyst is working with a diverse team that includes managers,
administrators, and other analysts who have competing needs and opinions.
Which best practice should the analyst apply to balance these stakeholders' needs
while collaborating on the project? Ans✓✓✓ Focus on the project objectives to
solve a specific problem
A small, local boutique bakery is looking to grow and improve sales.
What is a measurable business goal for the bakery according to SMART?
Ans✓✓✓ Spend three hours per week on marketing activities
An analyst communicates a requested change to the milestones and current
project timeline based on manager expectations. The analyst learns that the
project manager is anxious about missing the final deadline and would like to
discuss their concerns.
, Which best practice should the analyst apply to their communication with the
project manager? Ans✓✓✓ Schedule a meeting with the project manager
An analyst decides to ask for support from other analytics team members for
further data collection needs.
How should the analyst begin the conversation with the analytics team?
Ans✓✓✓ Discuss project details and potential solutions
An analyst encounters restrictions on certain employee data that they need for
analysis.
Who can the analyst meet with to request access to the data? Ans✓✓✓ Project
manager
An analyst has been assigned to serve as the project manager for a new project
team.
What will the analyst's role entail? Ans✓✓✓ Planning and executing
An analyst has been gathering insight on consumer buying trends and wants to
present the complex data to stakeholders using easily understood storytelling
techniques.
Which tool should be used for the presentation? Ans✓✓✓ Tableau
A business analyst is using Microsoft Excel to determine the total sales for a
region.
Which basic Excel formula should the analyst use to calculate this figure?
Ans✓✓✓ Sum
A business wants to see which locations sold a particular product.
Which conditional SQL (Structured Query Language) query should an analyst
apply to conduct this search? Ans✓✓✓ Where, Narrows the search
A client is worried about long wait lines at their retail store.
Which question would be effective for a better understanding of the problem?
Ans✓✓✓ Which hours have the most customer visits?
A company has experienced a sharp decline in sales due to product recalls. The
vice president of operations is interested in determining which supplier may have
provided the part that caused the product recall but is busy and unable to serve
as the analyst's direct contact.
Which best practice should the analyst apply to manage communication?
Ans✓✓✓ Update the project manager regularly
A company is assessing where and when they should start the advertising process.
They asked the analyst to propose a solution to the problem of advertisement
timing.
,What is the first thing the analyst needs to ask in order to understand the
customer's challenge? Ans✓✓✓ The nature of the problem
A cosmetics subscription service sets a goal to increase sales in Quarter 1 and
again in Quarter 2.
Which SMART goal metric does this satisfy? Ans✓✓✓ Time-bound
A data analyst is working with a diverse team that includes managers,
administrators, and other analysts who have competing needs and opinions.
Which best practice should the analyst apply to balance these stakeholders' needs
while collaborating on the project? Ans✓✓✓ Focus on the project objectives to
solve a specific problem
A small, local boutique bakery is looking to grow and improve sales.
What is a measurable business goal for the bakery according to SMART?
Ans✓✓✓ Spend three hours per week on marketing activities
An analyst communicates a requested change to the milestones and current
project timeline based on manager expectations. The analyst learns that the
project manager is anxious about missing the final deadline and would like to
discuss their concerns.
, Which best practice should the analyst apply to their communication with the
project manager? Ans✓✓✓ Schedule a meeting with the project manager
An analyst decides to ask for support from other analytics team members for
further data collection needs.
How should the analyst begin the conversation with the analytics team?
Ans✓✓✓ Discuss project details and potential solutions
An analyst encounters restrictions on certain employee data that they need for
analysis.
Who can the analyst meet with to request access to the data? Ans✓✓✓ Project
manager
An analyst has been assigned to serve as the project manager for a new project
team.
What will the analyst's role entail? Ans✓✓✓ Planning and executing
An analyst has been gathering insight on consumer buying trends and wants to
present the complex data to stakeholders using easily understood storytelling
techniques.
Which tool should be used for the presentation? Ans✓✓✓ Tableau
