A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

A. Display the version number next to each submission on the dashboard.

B. Present a data refresh date at the top of the dashboard.

C. Confirm the dashboard is adhering to the corporate style guide.

D. Use permissions to ensure users only see certain versions of the submissions.

An analyst is building a new dashboard for a user. After an initial conversation with the user. the analyst created a mock-up of the dashboard. Which of the following best explains why the analyst created the mock-up?

A. To identify the dimensions and measures

B. To send to the client after deploying the dashboard to production

C. To confirm important details before dashboard development begins

D. To receive client approval for the final dashboard design

Given the following grocery store orders:

If a query is made to the table with the following logic:

Order_Total > 132 OR (Order Total >= 25 AND Order_Total < 74)

Which of the following is the number of orders that will be returned by the query?

A. Four

B. Five

C. Six

D. Seven

A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson. Given the table below:

Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

A. Date

B. Mathematical

C. Logical

D. Aggregate

An organization would like to add a secondary email field to its customer database in order toenrich the customer profiles. Which of the following data manipulation techniques should the analyst use to add this information?

A. Blend

B. Merge

C. Append

D. Aggregate

A data engineer is creating a database field to capture whether a customer likes vanilla ice cream. Which of the following data types is the best to capture this information?

A. Integer

B. Boolean

C. Categorical

D. Numeric

Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

A. Simple random

B. Cluster

C. Systematic

D. Stratified

A sales manager requested a report that contains the first name, last name, and phone number of all the company’s customers and employees. The data engineer needs to return all the records from several tables, even duplicates. Which of the following is the best way to join the two tables?

A. FULL OUTER JOIN

B. INNER JOIN

C. LEFT OUTER JOIN

D. CROSS JOIN

Which of the following data types best describe 4Ac1? (Select two).

A. Alphanumeric

B. Symbolic

C. Numeric

D. Float

E. Boolean

F. String

Which of the following is the most appropriate to consider when creating a schema of a central group broken into detailed subcategories?

A. Relational

B. Hierarchical

C. Snowflake

D. Star