Data Loading & Visualization in Power BI: Data Modeling

 

Question:

This is a screenshot of the relationship between two Power BI tables. Based on this screenshot, what is the cardinality of this relationship?

• Many-to-one

Question

:

You would like to set up a relationship between two tables in Power BI, and both columns have numerous duplicate values. Which kind of relationship would you set up here?

• Many-to-many

Question

A.	CalcColumn = Table[Column_1] -Table[Column_2]
B.	CalcColumn = ColumnCalc(Table[Column_1] -Table[Column_2])
C.	CalcColumn = Table.Calc(Column_1 - Column_2)
D.	CalcColumn = Table.NewColumn(Column_1 - Column_2)

You would like to create a calculated Power BI column that is the difference between two of your columns. Which DAX command can you use for this?

• Option A

Question

A.	Price Range = IF([Price] > 100000, "High", IF(AND([Price] > 50000, [Price] <= 100000), "Medium", IF([Price] <= 50000, "Low")))
B.	Price Range = IF(OR([Price] > 100000, AND([Price] > 50000, [Price] <= 50000)), "High", "Middle", "Low")
C.	Price Range = IF(SUM([Price]) > 100000, "High", "Medium", "Low")
D.	Price Range = Price.If([Price] > 100000, [Price] > 50000, [Price] <= 50000)

You have a table UsedCars, with a column Price. You would like to label the prices High, Medium, and Low and store this data in a new column Price Range. Which DAX expression can you use?

• Option A

Question:

Your Power BI report displays a table that shows the average rating of a product using data from different tables, and you would like to add a column assigning a star rating to this table. Which Power BI feature can you use for this?

• Calculated columns

Question:

This is an image of a relationship between two tables. Please identify the cardinality and cross-filtering setting for this relationship.

• One-to-one, both

Question

:

You have an Excel file with 4 sheets. If you attempt to load this file into Power BI, how will it identify the tables?

• It will identify each sheet as a different table

Question

:

You have two tables - Products, with a column Product ID, and Orders which also contains the Product ID column. You would like to set up a relationship between these two tables such that you can view the total count of orders for each Product ID. Which kind of cross-filter can you use for this?

• Single (Products filters Orders)

Question

:

You have a Power BI table Product with a column Product ID and another table Orders with a column named Sales. Orders also contains the Product ID. You have configured a relationship between these two columns, and you would like to view the sum of OrderSales for each ProductID using a calculated measure. Which function could you use for this?

• SUMX

Question

:

This is a map visualizing the total sales of a global superstore by country. Based on this, which country has the highest sales?

• United States

Question

A.	NewTable = INTERSECT(‘Table_1’, ‘Table_2’)
B.	NewTable = Table_1 .INTERSECT(‘Table_2’)
C.	NewTable = SET_INTERSECT(‘Table_1’, ‘Table_2’)
D.	NewTable = COMMON(‘Table_1’, ‘Table_2’)

You would like to create a calculated Power BI table with the common rows from 2 different tables. Which DAX command can you use for this?

• Option A

Question

:

Power BI automatically detects some hierarchical data. Which of these hierarchies would Power BI detect?

Year >> Quarter >> Month >> Day

Question

A. NewTable = UNION(‘Table_1’, ‘Table_2’)

B.	NewTable = Table_1 .UNION(‘Table_2’)
C.	NewTable = SET_UNION(‘Table_1’, ‘Table_2’)
D.	NewTable = COMBINED(‘Table_1’, ‘Table_2’)

You would like to create a calculated Power BI table with the combined rows from 2 different tables. Which DAX command can you use for this?

• Option A

Question

:

This is an image of a relationship between two tables CustomerDetails and OrderItems. Please identify the cardinality and cross-filtering setting for this relationship.

• One-to-many, single

Question

:

You have a Power BI table with a column named Date, which stores dates at the granularity of a day. You would like to visualize this data using a line chart. At which granularity can you visualize this data?

• All of these

Question

:

In Power BI you wish to bring together data from different sources and set up relationships in your data for efficient analysis. What is this process known as?

• Data modeling

Categories: Power BI