A data analyst wants to find the mean score that students received in science classes. Given the following tables:

Which of the following will produce the desired results?

• A.COUNT and GROUP
• B.SUM and GROUP
• C.AVERAGE and WHERE
• D.CONCAT and WHERE

Comment: *

Name: *

Email: *

Verification: *

A data analyst receives the following sales data for a convenience store:

The analyst needs to provide information on the products that contain chocolate.
Which of the following RegEx should the analyst use to filter the chocolate products?

• A.Chocolate!
• B.Chocolate$
• C.%Chocolate&
• D.#Chocolate#$

Comment: *

Name: *

Email: *

Verification: *

Which of the following explains the purpose of UAT?

• A.To begin the software application development process to enhance user experience
• B.To ensure all parts of the software application work together after each sprint
• C.To review software application crashes, create patches, and deploy to users
• D.To validate and verify that a software application meets the needs and requirements of users

Comment: *

Name: *

Email: *

Verification: *

A data analyst is creating a user sentiment analysis for a new product. Which of the following is the best method to acquire the data?

• A.Surveying customers
• B.Sampling sources
• C.Querying databases
• D.Downloading open data

Comment: *

Name: *

Email: *

Verification: *

A business intelligence analyst is creating an employee retention dashboard that looks at data from the last five years. The analyst is interested in identifying patterns that can be studied further. Which of the following is the best method to apply to the dashboard?

• A.Predictive
• B.Prescriptive
• C.Diagnostic
• D.Descriptive

Comment: *

Name: *

Email: *

Verification: *