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.

12)After you append data for missing orders to your invoices table, you notice 136 orders that were not invoiced. What is the most likely reason?

Select an answer:

• They are recent orders that have not yet been invoiced.
• You did not construct your Append query properly.
• The invoice data in your database is incomplete.

13)Why is it often beneficial to unpivot data?

Select an answer:

• to create new pivot tables
• to have easy-to-read data visualizations
• to reduce the amount of space a visual requires

14)You applied conditional formatting to Customer Order by Amount. After you did this, a colleague changed the sort to Alphabetical. What will happen?

Select an answer:

• Your conditional formatting will not be affected.
• Your conditional formatting will disappear.
• Your conditional formatting will need to be refreshed.

15)You suspect fewer customers are sending purchase orders to your company, although the dollar amount of the POs you receive has not changed. Which chart type can best visualize your hunch?

Select an answer:

• a line/pie combo chart
• a pie chart with distinct colors for each slice
• a clustered column/line combo chart

16)What is an example of an ad hoc report?

Select an answer:

• a request from Sales for how many customer purchase orders are in the system
• a request from Accounting for the number of customer orders that have not been invoiced
• a request from Marketing for the top-selling products by dollar amount

17)You are going to present year-end sales information in a company-wide meeting. What must you consider when deciding how to present the data?

Select an answer:

• Your audience likely knows the data as well as you do, so keep your presentation formal.
• You are there to present financial data, so limit your presentation to numbers.
• You know the data better than your audience, so present to the level of their understanding.

18)You are working with ABC Corp. on its data analytics. The company asks you to compile a ranking of its top-performing products over the past five years. What two questions must you ask?

Select an answer:

• "Where is the data on all products?" and "How should price changes over the year be considered?"
• "Where is the data on all products?" and "What is your definition of top-performing?"
• "Where is the data on all products?" and "What should be done about orders where products were returned?"

19)You used the Steps Recorder in Windows to document the steps in changing a sort order. When colleagues use your recording, what will they see?

Select an answer:

• a video playback file showing each of the steps you took
• a Word document explaining each of the steps you took
• a series of screenshots with each screenshot showing a step you took

20)How can you use PowerPoint to make your presentations even more powerful?

Select an answer:

• You can create step-by-step tutorial for users to explore the data on their own.
• You can present the data and visuals at a pace comfortable for your audience.
• You can display more visuals on a screen than you can with just your dashboard on Power BI.

21)For a presentation, you want to sort customer orders for the quarter from largest to smallest, and also highlight orders that are larger than the average order amount. How will you accomplish it?

Select an answer:

• After sorting, use the Below Average conditional formatting rule to delete orders below average.
• After sorting, use the Above Average conditional formatting rule and select a highlighting color.
• After sorting, use the Top 10% conditional formatting rule and select a highlighting color.

22)You are using PowerPoint to create tutorial on navigating through a dashboard. Why would you apply a shape and highlighting to one part of a visual?

Select an answer:

• so the user's attention is drawn to certain areas you want to focus on
• so the user does not accidentally navigate to the dashboard in Power BI
• so you can hide information you do not want the user to see

23)What is considered the "magic" of pivots?

Select an answer:

• You can determine what the X column and the Y row headings are.
• The X columns and Y rows are predetermined so you cannot make a mistake.
• You can determine what the Y row headings are, and Excel provides the X column headings.

24)Question 24 of 30:

What is one benefit of pivot tables when it comes to exploring inside your data?

Select an answer:

• Pivot tools quickly fix errors in the underlying data.
• Pivot tools do not change the underlying data.
• Pivot tools do not require creating tables of data.

25)You are reviewing customers by yearly purchase amount over the last three years. Why would you add sparklines to your pivot table?

Select an answer:

• Sparklines "spark," as a bold highlight, at the highest level of customer purchases.
• Sparklines show you trends over the three years of customers' purchases.
• Sparklines, and no another visualization, can show percentage changes.

26)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.

27)You set up a pivot table for sales by product over the last three years and add an easy-to-read, 100% stacked bar chart. Why would you also include an Order Date slicer?

Select an answer:

• so users can look at particular months that interest them
• so users can perform mathematical calculations in the data
• so users can filter out any products that do not interest them

28)Where is noise found?

Select an answer:

• in a data set
• in queries
• in pieces of data

29)If you are building a dashboard for sales management, how will artifacts be involved?

Select an answer:

• They are the filters you place on the data that will then display on the dashboard.
• They are the important visuals you will place on the dashboard.
• They are the data tables you will place on the dashboard.

30)When you are building a dashboard, why should you do the intricate sizing and formatting at the very end of the process?

Select an answer:

• Sizing and formatting are the most important aspects of building a dashboard.
• The display you select, such as smartphone, will differ from tablet or laptop displays.
• Objects will shift a lot during the process of setting up a dashboard.