Jazz Power BI Workshop Quiz-1

We break dimensions in Star Schema to achieve the desired results.

Fact Tables can be connected together for Data Modeling.

What is the Total Budget for the year 2014?

You can create multiple active relationships from one table to the same primary key

Which three tabs in the Query Editor contain data shaping and transformation tools? _{(Choose only ONE best answer)}

What is the Total Budget Amount for the category Clothing?

What is the purpose of data profiling in Power Query? _{(Choose only ONE best answer)}

Extract command is used to extract a certain value from a column and place it in a new column in Add Column query

What is the Query Editor used for? _{(Choose only ONE best answer)}

Implicit measures are builtin features of Power BI, but Explicit measures are virtual features

Referencing is like making the relationships with Parent tables

Iterator functions operate

When you apply a tool from the "Transform" menu of the Power Query editor, which of the following is true?

SUMX, COUNTX are Iterator Functions, but COUNTROW is not an Iterator Function

Which of the following operations is used to add new rows to an existing table? _{(Choose only ONE best answer)}

Power BI is capable of loading data from JSON and web files, but not from databases like SQL.

Which data profiling tool provides detailed column statistics and value distribution for a selected column? _{(Choose One)}

What can the column distribution be used for? _{(Choose only ONE best answer)}

Like Galaxy Schema, we can also create Multiple Fact tables in Star Schema too.

Which One is an Aggregator function

Which data profiling tools does Power Query have? _{(Choose only ONE best answer)}

Union is like Merge Query in Power BI