3. Model data with power BI OK

Question 1

Is it rue or false:

ALL () Removes all filters everywhere and can only be used to remove filters not to create a table.

Answer 1

True

Question 2

What of the following are the two correct statement for RELATED

1. Required that a relationship occurs between the current table with table with related information
2. You always have to work with DATE-ADD
3. It is a like V-look up

Answer 2

1 to 3

Question 3

Select two true statement of COUNTA

1. Not support boolen data type
2. Returns a whole number
3. Counts the number of rows in a specified column that contains non-blank values
4. It is the same as count

Answer 3

2 and 3

Question 4

True or false
DATEADD compare data along a period of time

Answer 4

True

Question 5

True or false
Last not blank you can retrieve the first filled row date

Answer 5

False
Retrieves the first one

Question 6

With quick measures you can solve problems without the use of use of DAX

True or false

Answer 6

True

Question 7

DIfference between CALENDAR And CALENDAR AUTO

1. Both set start and end automatically
2. Both set star and end specifically
3. CALENDAR set start and end specifically and CALENDAR AUTO automatically

Answer 7

3.

Question 8

True or false

MMMM Is a user defined date/time that shows the month as a full month name

Answer 8

true

Question 9

FILTER

Return a calculated column that represents a subset of anothe table of expression

True or false

Answer 9

False

Filter returns a table

Question 10

What Dax Formula returns the user email address using a Dynamic role level security that will compare the user email address to that in employee table

Answer 10

userprincipalname

Question 11

SUMX
When we want to able to calculate row level

1.YES
2. No

Answer 11

1. YES

Question 12

Quick insights don’t work with

1 Direct query
2. Streaming
3. Pushdatasets
4. 1,2
5. 1,2,3

Answer 12

5.1 2 3

Question 13

1. A member can publish and change permission for the apps
2. A contributor can publish reports to the workspace and delete content
3. 1 false, 2, True
4. 1 false 2 false
5. 1 true 2 True
6. 1 True 2 False

Answer 13

3. 1 true 2 True

Question 14

Power BI User admin

1. Create and manage user groups
2. Reset user passwords
   3, Manage workplaces
3. 1 and 3
4. 1 and 2

Answer 14

5, 1 and 2

Question 15

1. Billing Admin Cannot manage subscriptions
2. Power Platform admin can enable and disable Power bi features
3. 1 true 2 true
4. 1. False 2 true
5. 1 true 2 false
6. 1. false 2 false

Answer 15

2. false and true

Question 16

Is PATH function is used to creat a hierarchy

1. True
2. False

Answer 16

1. true

Question 17

Sensitivity labels to a report are:

Power BI automatically applies tha label to the exported file and protects it according to the labels file

1. true
2. false

Answer 17

1. true

Question 18

Data size limitations for R

Data used by the R visual is limited to 150.000 rows
the input data has a limit of 250 MB

True or false

Answer 18

True

Question 19

Count rows refers to a table
it count The # of what in a specific table

1. Rows
2. Columns
3. Measures
4. calculated measure

Answer 19

1