Model

Question 1

You have a fact table that contains sales data
The fact table includes a sales date column formatted as a date data type. Auto date/time setting is disabled in both global and current file options

you load the fact table in power bi desktop

you need to ensure that you are able to analyze data on a yearly, quaterly, weekly and daily basis.
What should you use

Answer 1

Add a separate date dimension table

Question 2

You have created a Power BI dataset and need to creat mulitple reports
What is a benefit of usin a Power bI data set as data source for multiple reports compared to each report having a separate data set

Answer 2

Reduces the number of data sets, refreshes and storage requirements in the Power Bi service

Question 3

You have designed a star scehma to simplify your data
you need to understand the relationship between the tables in the star schema
What is the relationship between the fact table and the dimension table

Answer 3

Many to one

Question 4

You have a fact table that contains sales data and the following two date columns
Order date
Ship date

Both columns have a relationship to the date column in the calendar table and DAX measures have been configured to use the relationships for calculations related to the order of ship dates

You need to ensure that by default, the calendar table does not filter the fact table, unless it is using a DAX measure that uses this relationships

Answer 4

Disable make this relationship active for both relationship

Question 5

You have one row for every 5-minute interval for each location. The temperature tables is related to the date an location dimensions by using many to one relationships
You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location
What two actions should you perform

Answer 5

Create a column that contains the time values for the start of the hour of the reading time value

Use the group by functionality to aggregate the rows by hour, date and location key to create an averageTemp C value per row

Question 6

You decide to remove unnecessary columns from your data model
What are two potential performance benefits of doing this

Answer 6

Increase the refresh speed
Reducing the size of the data model

Question 7

You plan to use the calculate table functionality to add a duplicate table in Power BI desktop
Which features of the original table will be duplicated

Answer 7

data only

Question 8

You have a Power BI data set that get data from a table in a SQL Server database

From which view in Power Bi desktop can you modify the storage mode of the table

Answer 8

Model View