An analyst reviews the following table:

Which of the following data types is represented in the values in the RefNo column?

A. Numeric

B. Real Number

C. Currency

D. Alphanumeric

A data analyst is building a closed won quarter-over-quarter report for the sales team.
Which of the following will be needed to complete this request?

A. The report create date and closed dollar amount

B. The closed won quarter and the closed dollar amount

C. The segment and closed dollar amount

D. The closed won year and sales leader name

Which one of the following is a common data warehouse schema?

A. Snowflake.

B. Square.

C. Spiral.

D. Sphere.

After a merger, an analyst needs to enhance a very complicated quarterly report so that it is more user friendly for new team members. Which of the following elements would help reduce questions?

A. Version details

B. Appendix

C. Reference data sources

D. FAQs

A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

A. Create multiple reports, one for each needed date range.

B. Build calculations into the report so they are done automatically.

C. Add macros to the report to speed up the filtering and calculations process.

D. Create a dashboard with a date range picker and calculations built in.

Given the following report:

Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)

A. A control group for the phrases

B. A summary of the KPIs

C. Filter buttons for the status

D. The date when the report was last accessed

E. The time period the report covers

F. The date on which the report was run

Which of the following types of data manipulation functions should a data analyst use to implement a YES/NO condition in a spreadsheet?

A. Text

B. Statistical

C. Financial

D. Logical

While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

A. Delete any of the responses that do not have “January” written out.

B. Replace any of the responses that have “01”.

C. Filter on any of the responses that do not say “January” and update them to “January”.

D. Sort any of the responses that say “Jan” and update them to “01”.

An analyst notices changes in sales ratios when analyzing a quarterly report. Which of the following is the analyst conducting?

A. A gap analysis

B. A link analysis

C. A trend analysis

D. A statistical analysis

Which of the following data protection methods provides confidentiality for data in transit?

A. De-identification

B. Encryption

C. Masking

D. Anonymization

Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?

A. To return a subset of records

B. To insert a temporary table

C. To prevent SQL injections

D. To increase the query speed

Given the following table:

Which of the following describes the data quality issues with the age data?

A. Completeness

B. Consistency

C. Accuracy

D. Manipulation