Question 46

A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:
  • Question 47

    Which of the following best describes an exploratory analysis?
  • Question 48

    A financial analyst is creating a daily billing report for a company. One night, the company's data warehouse did not update the data, which caused the data to be reported incorrectly the next day. Which of the following documentation elements should the analyst add to catch this error?
  • Question 49

    Samantha needs to share a list of her organization's top 50 customers with the VP of sales.
    She would like to include the name of the customer, the business they represent, their contact information, and their total sales over the past year.
    The VP does not have any specialized analytics skills or software but would like to make some personal notes on the dataset.
    What would be the best tool for Samantha to use to share this information?
  • Question 50

    An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

    Which of the following types of charts should be considered to best display the data?