EDX Analyzing and Visualizing Data with Power BI: Quiz & Lab: Q&A

EDX Analyzing and Visualizing Data with Power BI: Quiz & Lab: Questions & Answers.

1. Power BI Desktop Data Transformations.

2. Power BI Desktop Modelling

3. Power BI Desktop Visualization

4. Power BI Service

5. Working with Excel

6. Organization Packs, Security and Groups

7. Direct Connectivity

8. Developer API

9. Mobile App

Question 1

When you connect to an Access database, which entities are shown in the Navigator window?

A- Users from the Access database

B- Tables from the Access database.

C- Rows in from Access database

D- Columns from the Access database

1/1 point (graded) Answer B - Tables from the Access database.

Question 2

Which three statements describe the Applied Steps area in the Query Editor window?

A. It records the list of steps from connecting to the data source to all the steps applied to the data.

B. The recorded list is based on the step that has least effect to the the step that has the most effect to the data source.

C. The recorded list follows the sequence of steps applied to the data source.

D. You can modify the connection to the data source by modifying the Source step settings.

1/1 point (graded) Answer A,C,D

A. It records the list of steps from connecting to the data source to all the steps applied to the data.

C. The recorded list follows the sequence of steps applied to the data source.

D. You can modify the connection to the data source by modifying the Source step settings.

Question 3.

Which three transformations are available when you right-click a column header in the Query Editor window?

Remove

Change Type

Duplicate Column

Count Rows

Not sure

Question 4

When using the "Split Column by Delimited" transformation, which option may result in more than two new columns?

A- At the left-most delimiter

B- At the right-most delimiter

C- At each occurrence of the delimiter. correct

D- None of the above

C- At each occurrence of the delimiter. correct

Question 5

Which three views are available in Power BI Desktop?

Dashboard

Report

Data

Relationships

Dashboard

Report

Data

Relationships

Question 6

You have four queries named Query 1, Query 2, Query 3, and Query 4 in the Power BI desktop. You are creating Query 5, which will be appended at the end of Query 3.

When you load the data, which queries will be refreshed?

Query 1 to Query 4

Query 1 to Query 5

Query 3 and Query 5.

Only Query 5

Query 3 and Query 5.

Consider the following custom column formula:

= if [Country] = "USA" then "United States" else [Country]

Which of the following statements describes the value of the custom column formula?

The value will be "USA".

The value will be "United States".

The value will be the same as the Country column.

The value will either be "United States" or whatever the value of the Country column is.

The value will either be "United States" or whatever the value of the Country column is. correct

Question 8

Which transformation option converts rows as columns and columns as rows?

Transpose.

Pivot Column

Unpivot Columns

Unpivot Other Columns

Transpose.

Exercise 1: Import Data from Access Database

Lab Questions

3/5 points (graded)

Answer the following question by reviewing the imported data in Power BI Desktop. (Hint: Use the Data view).

How many rows were imported from the Date query? incorrect 6209

How many rows were imported from the Locations query? correct 99618

How many rows were imported from the Manufacturer query? correct 14

How many rows were imported from the Products query? correct 2412

How many rows were imported from the Sales table? incorrect 10439386

Exercise 2: Import Data from a Folder Containing CSV Files

Lab Questions

Answer the following question by reviewing the imported data in Power BI Desktop. (Hint: Use the Data view).

How many rows were imported from the International Sales query? correct

797244

How many rows are now in the Sales query? correct

10782612

Exercise 3: Import a Less Structured Data from an Excel File

Lab Questions

Answer the following question by reviewing the imported data in Power BI Desktop. (Hint: Use the Data view).

How many rows were imported from the Country Population query? correct

75

How many distinct values of the Year column were imported from the Country Population query? correct

15

Question 9

Which three cardinalities are available in Power BI table relationships?

A. Many to One

B. One to One

C. One to Many

D. Many to Many

Answer A,B,C

Question 10

Which two cross filter directions are available in Power BI table relationships?

A. Single

B. Double

C. Both

D. Multiple

Answer A, C

Question 11

Consider the following DAX formula for a calculated column in the Sales table:

UnitPrice = Sales[Revenue] / Sales[Units]

Which three statements describe the DAX formula?

A. The formula creates a calculated column named UnitPrice.

B. The value of the calculated column is dependent on the Revenue column.

C. The value of the calculated column is dependent on the Units column.

D. The Data type of the calculated column is Text.

Answer A,B,C

Question 12

Which three options allow you to hide a field from the Report view in Power BI Desktop?

A. In Power BI Desktop Report view, right-click the field on the Fields list, and click Delete.

B. In Power BI Desktop Data view, right-click the column header on the respective table, and click Hide in Report View.

C. In Power BI Desktop Relationships view, right-click the field on the respective table, and click Hide in Report View.

D. In Power BI Desktop Report view, right-click the field on the Fields list, and click Hide.

Answer B,C,D

Question 13

In Power BI Desktop Report view, which three options will create a measure in the Sales table?

A. Select the Sales table in the Fields list, and then click New Measure in the Modelling ribbon.

B. Create the measure from any table, and then set the Home Table properties to Sales.

C. On the Fields list, click the ellipsis next to the Sales table or right-click any field in the Sales table, and then click New Measure.

D. Click New Measure, and then type in the formula Home Table = Sales.

Answer A,B,C

Question 14

What are the three reasons for which you might use calculated tables?

A. To union tables

B. To improve the speed and performance of an existing table

C. To perform different types of merge join

D. To create a table based on the result of a function or formula

Answer A,C,D

Question 15

Which three fields are available when creating a Pie chart for visualization?

A. Legend

B. Group

C. Details

D. Values

Answer A,C,D

Consider the following chart:

Drag and drop the fields to the corresponding settings to create the above chart.

1-Year

2-Country

3-Revenue

4-Units

5-Category

6-Segment

1-Y. 2-Co. 3-R. 4-U.

Question 16

By default, which level of filter behaves the same as a slicer in a report in Power BI Desktop

A. Visual level filter

B. Page level filter

C. Report level filter

D. Query level filter

Answer B

Consider the following chart:

Drag and drop the fields to the corresponding settings to create the above chart.

1-Country

2-Category

3-Revenue

Year

Segment

Units

1- co. 2- ca. 3- re. 4- ye

Consider the following chart:

Drag and drop the fields to the corresponding settings to create the above chart.

1-Segment

2-Category

3-Revenue

Year

Country

Units

1- Se. 2- Ca. 3-Re. 4-Ye.

Question 17

When creating a waterfall chart, which two field options that you need to define?

A. Category

B. X Axis

C. Y Axis

D. Size

A,C

Question 18

Which visualization would you use to show progress toward a particular target?

A. Bar chart

B. Scatter chart

C. Waterfall

D. Gauge

Answer D.

Question 19

Which three shapes can you create using the Insert Shapes feature in Power BI Desktop?

a. Flowchart

b. Triangle

c. Rectangle

d. Oval

Answer B,C,D.

Question 20

From which two options can you customize your report page layout?

a. From the Report ribbon, New Page option

b. From the Report ribbon, Page View option

c. From the Visualizations, Format option

d. From the Visualizations, Field option

B,C

Question 21

Which of the following option would you use to modify the interactions flow between visuals in a Power BI report?

a. Edit Queries

b. Arrange

c. Page Size

d. Edit Interactions correct

Answer D.

Question 22

When you make a copy of a page in your report by using Duplicate Page, which visualizations from the page are duplicated?

a. All visualizations correct

b. Only the selected visualizations

c. Only visualizations that have filter relationship

d. All visualizations, except the static images

Answer A

Question 23

Which of the following is not an option for Default Summarization?

a. Sum

b. Average

c. Count

d. Standard deviation correct

Answer D

Question 24

Which four options you can use to modify the Z order of a visualization?

a. Send to Back

b. Bring to Front

c. Bring Forward

d. Set Transparent

e. Send Backward

Answer A,B,C,E.

Exercise 1: Cross-Tabular Report

You should have something similar to the below:

Lab Questions

Answer the following questions using the report you created. (Do NOT include currency symbols or thousands separators). Do not use any level of filtering to answer the questions.

What is VanArsdel's sales for December 2013? (to two decimal places) incorrect

?

What is VanArsdel's total units for the March 2013?

?

incorrect

Exercise 2: Part-to-Whole Report

You should have something similar to the below:

Lab Question 1

Answer the following questions using the report you created. (Do NOT include currency symbols or thousands separators). Do not use any level of filtering to answer the questions.

In January 2014, what is VanArsdel's sales, from all manufacturers, for Urban category and Moderation segment? (to two decimal places) (Hint: Try hovering on the chart)

6732251.98

correct 6732251.98

In May 2015, what is VanArsdel's sales, from all manufacturers, for Mix category and All Season segment? (to two decimal places) (Hint: Try hovering on the chart)

859987.07

correct 859987.07

Lab Question 2

Answer the following question by using the treemap chart you created.

Drag the Manufacturer name to its appropriate box, 1 for the one with highest, and 4 for the one with the lowest.

For VanArsdel's sales in 2015, which are the top 4 manufacturers?

Answers below the questions

3- Aliqui

2- Natura

4- Pirum

1- VanArsdel

Abbas

Barba

Fama

Leo

Pomum

Quibus

Salvus

Victoria

Exercise 3: Relationship Report

You should have something similar to the below:

Lab Questions

As you can see, in the year 2015, Moderation segment made the most of VanArsdel's sales. It is not always the case. Use the Play Axis to investigate.

In which year the Moderation segment first took over as the segment with most sales?

correct 2009

What about in terms of Units? In which year the Moderation segment first took over as the segment with most units?

correct 2011

Exercise 4: Trend Report

You should have something similar to the below:

Lab Question 1

In which year the growth of total sales were not matched by the growth of total units?

2005

2006 correct

2007

2008

Answer B

Lab Question 2

Which year saw the biggest drop in total sales?

2007

2008

2009 correct

2010

Answer C

What about total units? Which year saw the biggest drop in total units?

2007

2008

2009 correct

2010

Answer C

Exercise 5: Rank Report

You should have something similar to the below:

Lab Questions

What is the top product in terms of sales for the year 2010?

Maximus UM-92

Maximus UM-43

Maximus UM-70

Maximus UM-11 correct

Maximus UC-69

D

What about in terms of units? What is the top product in terms of total units for the year 2010?

Maximus UM-92

Maximus UM-43 correct

Maximus UM-70

Maximus UM-11

Maximus UC-69

B

Question 25

By default, where does clicking a tile on a Power BI dashboard take you?

a. To the latest opened report

b. To the report where the visual was pinned from

c. To the report that has the same data source

d. To the Power BI home page

Answer B

Question 26

When you pin a visual created by the natural language query, to which dashboard is it pinned?

a. The last dashboard you visited

b. The last dashboard you created

c. A new dashboard

d. The dashboard you selected in the Pin to dashboard window. correct

D

Question 27

You want to share a dashboard with your colleague. What are two possible ways to achieve this goal?

a. Click the ellipsis next to the dashboard name on the Dashboards list, and then click Share.

b. Click Share from the upper right of the dashboard you want to share.

c. From your browser, click Share.

d. Right-click anywhere in the dashboard, and then click Share.

Question 28

You are viewing a Power BI dashboard in a browser window. What happens when you click the Focus mode of a tile?

a. The tile you selected expands and takes the full space.

b. The report from which the tile was pinned opens.

c. The Power BI desktop file gets downloaded.

d. The Power BI desktop file opens.

A

Question 29

Which three properties of a tile can you edit in the Power BI dashboard from the Tile details window?

a. Title

b. Subtitle

c. Destination link

d. Color scheme

Answer A,B,C.

Question 30

What do you need to append to the URL of a Power BI dashboard in order to open it with the navigation pane collapsed by default?

a. ?navigationPane=false

b. ?navigationPane=collapsed

c. ?collapseNavigation=true correct

d. ?collapseNavigation=collapsed

Answer A

Question 31

You publish a report from Power BI Desktop to Power BI service. You then make changes to your local report in Power BI Desktop by adding some visualizations. When do the changes synchronize to Power BI service?

a. When you save the Power BI Desktop file

b. When you click REFRESH NOW in Power BI service

c. When you re-publish the Power BI Desktop report.

d. When the scheduled refresh is run on Power BI service

C

Question 32

What is the purpose of Power BI Personal Gateway?

a. To enable publishing reports to Power BI service

b. To provide a platform for easily consuming and sharing reports.

c. To provide quick and secure data transfer between Power BI service and on-premises data sources that support refresh.

d. To connect and shape data, build robust models, and author well-structured reports.

C

Exercise 1: Upload PBI Report and Pin Visualizations

You should have something similar to the below: