Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

Accelerate your Career and Get Certified

Model Data in Power BI

Friday, June 25th, 2021

Welcome to your Model Data in Power BI

In a data model diagram the boxes contain ______ of data, where each line item within the box is a ______.

files, relationship

tables, column

files, column

files, row

tables, row

tables, relationship

Star schemas use fact tables and tables.

Tables should always be as granular as possible so that users can drill into every single transaction

False

True

Primary keys must be [select all]

numeric

associated with a foreign key in another table

unique

non-null

The dashed line between the two tables indicates that it is _______ relationship.

the active

an inactive

A date table must contain a column of type 'date' with unique values.

True

False

With a single cross-filter direction between two tables with a one-to-many relationship, filtering will be done by

The "many" side - the table with multiple values on the relationship column

The "one" side - the table with unique values on the relationship column

Either the "one" or the "many" side can act as the filter, depending on the option selected

Benefits of a date table include [select all that apply]

determining the calendar year of a given date

determining whether a given date is a company holiday

determining the fiscal year of a given date

determining days between two dates, such as order date and ship date

Power BI automatically enters these values as a hierarchy

Date types

Fields with the name "Level 1", "Level 2" etc

Any fields prefixed with "sub"

None of the above

Which of the following does not compress as well that the other methods?

Power Query

Calculations in SQL views

DAX

Quick measures

This DAX function returns a string containing a delimited list of IDs starting with the top/root of the hierarchy and ending with the specified ID

PATHITEM

PATH

FLATTEN

An inactive relationship will never be used unless ________.

Explicitly declared in a measure

Both fields in the relationship are added to the view

Both fields in the active relationship are added to the view

Power BI autodetects relationships based on column names

True

False

The CALCULATE function

override certain portions of the context

ignores all filters in the view

Total Price shown below is

A child of Quantity and Unit Price

A dimension

The name of the new column

Compared with the product of Quantity and Unit price

A parent of Quantity and Unit Price

This DAX function [select all that apply]

Total Sales for 2015 = CALCULATE(SUM('Sales OrderDetails'[Total Price]), YEAR('Sales OrderDetails'[orderdate]) = 2015)

Will return the same value regardless of other dimension filters such as region, manager, or product

Overrides the order date filter context

Will be equal to SUM('Sales OrderDetails'[Total Price]) when the view has a filter on orderdate = 2015

Tables with different levels of granularity need to be reconciled before establishing a relationship between the tables.

False

True

Fact tables contain these types of data [select all]

sales orders

customer detail

website visits

product detail

Which cardinality is not recommended?

Many-to-many

Many-to-one

One-to-many

One-to-one

Which cardinality is a default when relationships are automatically created?

one-to-many

one-to-one

there is no default, you must define the cardinality

many-to-many

The solid line between the two tables indicates that it is _______ relationship.

the active

an inactive

This function returns a complete range of dates that are automatically determined from your dataset

DATERANGEAUTO()

DATERRANGE()

CALENDAR()

CALENDARAUTO()

A date table is any table containing a date range in one of the columns. There is no 'official' date table in Power BI.

True

False

This function

Sales by Ship Date = CALCULATE(Sales[TotalPrice], USERELATIONSHIP('Calendar'[Date], Sales[ShipDate]))

Allows total price to be calculated using the inactive relationship between 'Calendar'[Date] and Sales[ShipDate]

Creates an active relationship between ShipDate and the calendar date

This type of dimension table has multiple valid relationships with fact tables, meaning that the same dimension can be used to filter multiple columns or tables of data.

Hierarchy

Many-to-many

Many-to-one

Cubing

Role-playing

A best practice before running the performance analyzer is to clear these [select all that apply]

data engine cache

visual cache

Power Query cache

DAX cache

measure cache

If the same expression is repeated multiple times in a calculation

A variables can make result in better performance because they will avoid having the same expression calculated multiple times

Power BI will detect this and only calculate it once

The performance analyzer shows the time to complete the following categories [select all that apply]

Other

Table Joins

DAX Query

SQL Query

Visual Display

Which of the following is not a query reduction option

Disable cross filtering/highlighting by detail

Add an apply button to all basic filters to apply changes when you're ready

Add an apply button to each slicer to apply changes when you're ready

Summarize data in source before sending to Power BI

Benefits of variables include [select all that apply]

Improved performance

Improved appearance of reports

Improved readability

Improved debugging

Which of the following is not an option for using aggregation in a data model

DAX

create the aggregation in the Power Query Editor

create a view on the for the aggregation and then import that view into Power BI Desktop

create a table on the source database for the aggregation and then import that view into Power BI Desktop

What are reasons to use DirectQuery [select all that apply]

need for near-real time reporting

desire to handle large data without pre-aggregating

best practice to use rather than Import

Best practice is to use the Auto date/time option enabled only when you

work with calendar time periods and when you have simplistic model requirements in relation to time.

wish to avoid the performance bottleneck caused by an official date table

wish to benefit from a date dimension table

To clear the data cache, you can either ______ or connect DAX Studio to the data model and then call Clear Cache.

Restart Power BI Desktiop

Open a blank page in Power BI desktop

Add a new table to the data model

Which of the following are characteristic of DirectQuery [select all that apply]

performance depends on underlying data source server

The same modeling capabilities as with when Import is used.

eliminates Power BI security concern since data is kept on the data source server

Only the schema is loaded, the source tables aren't queried until you start building a visual.

Variables help simplify the task of troubleshooting your DAX calculation by evaluating each variable separately and by recalling them after the ______ expression.

=

RETURN

ASSIGN

Using aggregations in the data model can [select all that apply]

reduce the Power BI file size

present data at a lower grain

allow for more drill down

speed up the refresh process

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Δ

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC