Data Modeling

Question 1

What is a data model

Answer 1

A queryable data resource thats optimized for analytics

Question 2

What are the two analytic query languages?

Answer 2

Data Analysis Expressions (DAX)
Multidimensional Expressions (MDX)

Question 3

What is a Power BI dataset?

Answer 3

A Power BI model that is published a workspace in the service

Question 4

Analytic Query

Answer 4

A query against a model that produces a result that easy for a person to understand

Question 5

Tabular Model

Answer 5

A model that is made up of one or more tables of columns

Question 6

Star Schema Design

Answer 6

A modeling approach where you have your fact table in the middle and you dimension tables on the points of the star

Question 7

Table Storage Mode

Answer 7

a property for every table (except calculated tables) that determines if the data is store in the model or left in the source

Question 8

3 Table Storage Modes

Answer 8

Import
DirectQuery
Dual

Question 9

Import Storage Mode

Answer 9

Queries data that is cached in the model

Question 10

DirectQuery Storage Mode

Answer 10

Queries pass through to the data source

Question 11

Dual Storage Mode

Answer 11

Queries stored data or passes through to the data source. Power BI determines the most efficient plan striving to use cached data whenever possible

Question 12

What is a model framework?

Answer 12

Its a combination of table storage mode settings

Question 13

3 Model Frameworks

Answer 13

Import Model
DirectQuery Model
Composite Model

Question 14

Import Model Framework

Answer 14

A model where the tables have their storage mode property set to Import

Question 15

DirectQuery Model Framework

Answer 15

A model where tables have their storage mode property set to DirectQuery and they belong to the same Source Group

Question 16

Composite Model Framework

Answer 16

A model that comprises more than one source group

Question 17

Source Group

Answer 17

its to combination of the data source and the connection used

Question 18

What does it mean to have more than one source group?

Answer 18

you have both import and direct query source groups being used or you are using a direct query connection on 2 different data sources

Question 19

Whats the key difference between an import model framework, direct query model framework, and a composite model framework?

Answer 19

an import model and direct query model only have one source group. When you have more than one source group its a composite model

Question 20

When is a model considered to be a composite model

Answer 20

When you have both direct query and import data sources or 2 separate direct query data sources

Question 21

What is the data size limit when publishing to a Shared Capacity?

Answer 21

1GB

Question 22

What is the data size limit for Dedicated Capacity?

Answer 22

> 10GB

Question 23

8 main data reduction techniques

Answer 23

• Remove unneeded columns
• Remove unneeded rows
• Summarize fact table to raise grain
• Optimize column data type by using number data type
• Use Power Query for custom columns rather than calculated columns
• Disable Power Query Load
• Disable auto date/time
• Use DirectQuery table storage

Question 24

How many times can a schedule refresh run in a Shared Capacity?

Answer 24

8 times per day

Question 25

How many times can a schedule refresh run in a Dedicated Capacity?

Answer 25

48 times per day

Question 26

When should you use an Import Model Framework?

Answer 26

When dataset is small and refresh limitation of 8 times in a day in a shared capacity or 48 time in a premium capacity is up to date enough

Question 27

What is the import source group?

Answer 27

all import storage mode tables, there can only be one import source group in a model

Question 28

Hybrid Table

Answer 28

a single table that uses an import partition and a direct query partition

Question 29

Table Partiton

Answer 29

a database feature where a large table is divided into smaller manageable units

Question 30

How do you create a hybrid table?

Answer 30

By setting up an import table with incremental refresh and enabling the get latest data in real-time with DirectQuery

Question 31

You need to create a RLS role for a dataset what should you do first?

Answer 31

You create the role in power bi desktop in Mange Roles