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.Sort
• B.Date
• C.Aggregate
• D.Logical

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements would be used to append two tables that have the same number of columns?

• A.UNION ALL
• B.MERGE
• C.GROUP BY
• D.JOIN

Comment: *

Name: *

Email: *

Verification: *

Which of the following types of dashboards should a business intelligence engineer develop in order to provide information about failed data pipelines?

• A.Referencing
• B.Strategic
• C.Operational
• D.Technical

Comment: *

Name: *

Email: *

Verification: *

A report is scheduled to run and be distributed at the end of business each day. On Mondays, one of the recipients opens the previous week's reports and combines them to calculate the weekly totals and projections for the coming week. This is a tedious process, and the recipient asks an analyst for help. Which of the following should the analyst recommend?

• A.Add calculation fields to the daily report so the totals are built in.
• B.Provide a daily summary to the report with totals to save the user the effort of manual calculations.
• C.Create a new report with weekly totals set to run at the end of business on Friday.
• D.Reduce the frequency of the report to once a week and change the date range.

Comment: *

Name: *

Email: *

Verification: *

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

• A.To prevent SQL injections
• B.To return a subset of records
• C.To insert a temporary table
• D.To increase the query speed

Comment: *

Name: *

Email: *

Verification: *