Power BI Quiz

1
When creating a waterfall chart, which two field options that you need to define?
A)Category
B)X Axis
C)Y Axis
D)Size

1. A and C
2. A and B
3. B and C
4. A,B and D

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A and C[/bg_collapse]
 
2
Department table has unique departments and employee table can have many employees in each department and both entities can be linked in relationship view  from department to Employee table using

1. 1 to 1 relationship
2. One to many Relationship
3. Many to Many Relationships
4. Many to one Relationship

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : One to many Relationship[/bg_collapse]
 
3
You are viewing a Power BI dashboard in a browser window. What happens when you click the Infocus mode of a tile?

1. The Power BI desktop file opens.
2. The report from which the tile was pinned opens.
3. The Power BI desktop file gets downloaded.
4. The tile you selected expands and takes the full space.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : The tile you selected expands and takes the full space.[/bg_collapse]
 
4
Which level of filter behaves the same as a slicer in a report in Power BI Desktop

1. Visual Level Filter
2. Page Level Filter
3. Report Level filter
4. Query Level Filter

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Page Level Filter[/bg_collapse]
 
5
When you pin a visual created by the natural language query, to which dashboard is it pinned?
 

1. The last dashboard you visited
2. The last dashboard you created
3. A new dashboard
4. The dashboard you selected in the Pin to dashboard window

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : The dashboard you selected in the Pin to dashboard window[/bg_collapse]
 
6
which of the following is crosstable chart?
 

1. Cross Table
2. Matrix
3. Line
4. Guage

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Matrix[/bg_collapse]
 
7
Which chart is suitable for comparing two sets of measure values that are usually hard to compare because of the differences in scale.

1. KPI Chart
2. Guage Chart
3. Combo Chart
4. Stacked Bar Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Combo Chart[/bg_collapse]



8
Which chart is used to compare data side by side

1. Bar
2. Line
3. Gauge
4. KPI

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Bar[/bg_collapse]
 
9
Which  chart is suitable for illustrating how an initial value is affected by intermediate positive and negative value

1. Line
2. Combo
3. Bullet
4. WaterFall

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : WaterFall[/bg_collapse]
 
10
Report Level filter applies to
 

1. One Page
2. All Pages
3. One Visualization
4. Multiple Visualizations in same page

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All Pages[/bg_collapse]
 
11
Which chart will show correlation between 2 variables?

1. Pie Chart
2. Scatter
3. Bar Chart
4. Line Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Scatter[/bg_collapse]
 
12
A doughnut chart is similar to a

1. Bar Chart
2. Filled Maps
3. Waterfall chart
4. Pie chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Pie chart[/bg_collapse]
 
13
Which visualization would you use to show progress toward a particular target?
 

1. Bar Chart
2. Scatter Chart
3. waterfall chart
4. Gauge Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Gauge Chart[/bg_collapse]
 
14
Which Chart is  used to show percentage of parts in a chart

1. Pie chart
2. Column chart
3. Bubble chart
4. Water Fall chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Pie chart[/bg_collapse]
 
15
Which chart helps you visualize a linear process that has sequential connected stages.

1. Pie chart
2. Column chart
3. Funnel Chart
4. Water Fall chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Funnel Chart[/bg_collapse]