CompTIA DA0-001 Practice Test - Questions Answers, Page 22

Refer to the exhibit.

An analyst must obtain the average daily sales for the following week:

Which of the following must the analyst perform to obtain this value?

A sales analyst needs to report how the sales team is performing to target. Which of the following files will be important in determining 2019 performance attainment?

A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

A Chief Executive Officer (CEO) is requesting more up-to-date sales data for improved visibility prior to month-end. An analyst must determine the frequency of a sales report that was previously distributed on an as-needed basis. Which of the following would be the most appropriate frequency for this report?

A financial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does il with, some account information is not shown.

Which of the following fields should be masked?

A collections manager has a team calling customers who are past due on their accounts in an attempt to collect payments. The manager receives the call list in the form of a printed report that is generated by the accounting department at the beginning of each week. Consequently, the collections team calls some customers who have made payments in the time since the report was last printed. Which of the following reporting enhancements could the accounting department implement to best reduce the number of calls on current accounts?

Which of the following report types is most appropriate for a high-level, year-end report requested by a Chief Executive Officer?

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

A customer's telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?