1)How can cards, such as multicards, provide you with cleaner visuals?

Select an answer:

• They remove irrelevant data and display the most relevant data.
• They provide summary data and an easier way of sorting through data.
• They provide step-by-step instructions for applying filters.

2)You are compiling the top 50 customers from last year. You run a query in Access for Customers along with an asterisk (*). What will be returned?

Select an answer:

3)Your sales manager asks you to pull out the top 25 customers based on order amount. You are allowed to set the business rule. Which business rule makes the most sense with this ask?

Select an answer:

• Noise will be removed from the customer order data before ranking.
• The customer will not be included in the top 25 if they have an outstanding invoice.
• Customers will be ranked by the highest single order amount.

4)You do not want your soft filters to affect a particular visual on your dashboard. How will you prevent this from happening?

Select an answer:

• Use hard filters.
• Edit the interactions.
• Turn off slicers.

5)You create both Wage Survey Reference and Wage Survey Duplicate data sets from your Wage Survey data set. If you make changes to the Wage Survey data set, where else will the changes occur?

Select an answer:

• in the Wage Survey Duplicate data set
• in the Wage Survey Reference data set
• in the underlying data table

6)You want to explore your data after you append a folder with the latest data. Which load option will you select?

Select an answer:

• Combine and Load
• Combine and Load To
• Combine and Transform Data

7)Your company recently moved to a new data storage system. As part of your monthly work, you check for any invoices that do not have a CustomerOrderID. You find 10. What does this most likely mean?

Select an answer:

• Some data from the old system did not move to the new system.
• The old system did not have a verification system for invoices and orders.
• Ten customers were invoiced even though they did not place orders.

9)What is the first step in doing a custom sort in Power BI?

Select an answer:

• Define the columns to sort.
• Choose Ascending or Descending.
• Create custom table.

10)You build a line total based on the Order Details table of OrderID, UnitPrice, and Qty. If you add your Customer List table, can you run a query for the top 50 customer orders?

Select an answer:

• Yes, because OrderID bridges the join line gap.
• No, because there is no join line between the two tables.
• Yes, if the two tables cover the same time period.

11)2020 sales for Product A are piquing your curiosity. How can pivots enable you to gain more insight into the data?

Select an answer:

Pivots let you filter your data to display just the data you want.

Pivots let you drill-down into the underlying data.

Your data continually refreshes while you are working with pivots.