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.Use permissions to ensure users only see certain versions of the submissions.
• C.Confirm the dashboard is adhering to the corporate style guide.
• D.Present a data refresh date at the top of the dashboard.

Comment: *

Name: *

Email: *

Verification: *

Which of the following database schemas features normalized dimension tables?

• A.Flat
• B.Snowflake
• C.Hierarchical
• D.Star

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?

• A.$2,667.60
• B.$12,330.88
• C.$3,082.72
• D.$2,466.18

Comment: *

Name: *

Email: *

Verification: *

An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

• A.Aggregate
• B.Logical
• C.Date
• D.Sort

Correct Answer: B

This is because a logical function is a type of function that returns a value based on a condition or a set of conditions. A logical function can be used to generate the data in the Sales_indicator column by comparing the values in the Sales column with a threshold of $50,000 and returning either "Exceeded $50,000" or "Not exceeded $50,000" accordingly. For example, a logical function in Excel that can achieve this is:

The other functions are not suitable for generating the data in the Sales_indicator column. Here is why:
Aggregate is a type of function that performs a calculation on a group of values, such as sum, average, count, etc. An aggregate function cannot generate the data in the Sales_indicator column because it does not compare the values in the Sales column with a threshold or return a text value based on a condition.
Date is a type of function that manipulates or extracts information from dates, such as year, month, day, etc. A date function cannot generate the data in the Sales_indicator column because it does not use the values in the Sales column or return a text value based on a condition.
Sort is a type of function that arranges the values in a column or a range in ascending or descending order. A sort function cannot generate the data in the Sales_indicator column because it does not create a new column or return a text value based on a condition.

Comment: *

Name: *

Email: *

Verification: *