Power BI Quiz 2 (2.14)

How to transfer the distinct values of a column as the new column names?

Transpose
Pivot
Group by
Unpivot

Which of the following is true about the unpivoting a column ?

It converts the values of the columns into rows
It performs aggregrate calculation for each value in the column
It sets the data in the matrix format
It removes redundant values from the table

A new column created in the power bi desktop that depends on the conditions of the other columns

Conditional column
Custom column
Measures
DAX Column

The aggregation feature in powerbi interacts with what level storage modes?

Report level
Table level
Data level
Model level

Which of the following is not an aggregate function?

SUM
AVG
MUL
COUNT

What is the aggregate function to remove and count the distinct values in a column?

COUNT
DSTCOUNT
DISTINCT
DISTINCTCOUNT

COUNT function cannot count both numerical and alphabetical values?

True
False

Imported data can be edited in powerbi using

PowerBI Desktop
PowerBI Service
Power Query Editor
Admin Portal in powerbi

How to view the top 100 rows as the botton 100 rows for a column in the powerbi?

First transpose the table and view the top 100 rows
Select the column directly and click on reverse rows and view the top 100 rows
Split the table exactly at half and view the top 100 rows
Split the table exactly at half reverse the 2nd part and view the top 100 rows

Query in power bi is

Series of steps performed on the raw data to convert it into the required format
Sequence of predetermined conditions applied on the loaded data
The syntax that is designed and used to apply the required steps on the data
Used to build the meaningful visualizations for the imported data

In the power query editor

To add the deleted column, data should be imported again
Visualization can be applied on the data and tested before loading into the power bi desktop
Changes can be applied at the data level
Datatype changes are not possible

How to remove the redundant values for a particular column and draw meaningful insights based on it ?

Use unpivot property on the column to group the distinct values
Select the group by feature and use an aggregate function
Pivot the column so that the distinct values as listed as columns
Delete the redundant values

If pivot is applied to a column that cannot be aggregated?

An error is thrown as pivot operation cannot be done without aggregation
Pivoting is possible but advanced aggregate options cannot be used
Select “Don’t aggregate “ option under the aggregate value function
Select “Remove aggregate” option under the aggregate value function

In the real time data if the columns has too much unnecessary information

Seggregate the data as per the requirement in the datasource and load into the powerbi
Use the aggregate function to group the similar data and apply pivot
Use the comma delimiter upto the required part to split the data
Get the required part of the data by using split column

Which of the following is not an aggregate valued function under pivot?

Count
Mean
Median Average
Don’t aggregate

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

Leave a Comment Cancel reply