Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MCSA 70-778 > Level 1 Study Material > Flashcards

Level 1 Study Material Flashcards

1
Q 
Which of the following versions of the Windows operating system support installing Power BI Desktop?
A. Windows Vista
B. Windows 10
C. Windows 8.1
D. Windows 7
A

Windows 10, 8.1, and 7

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does ETL Stand For?

A

Extract the data from wherever it lives
Transform the shape of the data for better analysis
Load the data into dataset for analysis and reporting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which of the following items is never stored within a PBIX project file?
A. Data for the rows of tables imported from external datasources
B. Default values for query parameters
C. Code written in R
D. Data source credentials

A

Data source credentials

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the 3 places within a PBIX file where you can write R code?

A

Starting input source when creating a query, applied step in a query, R visual in a report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

When designing a query in Power BI Desktop to clean up data, what operation can be used to remove non-printable characters?

A

Clean

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the Trim function used for when querying?

A

Removing white space at start and end

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the Clean function used for when querying?

A

Removing non-printable characters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the Group By function used for when querying?

A

Duplifying rows and creating unique ID values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q 
Which of the following is not a valid privacy level for a Power BI data source?
A. Public
B. Protected
C. Private
D. Organizational
A

Protected

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Where in a pbix file is M code written?

A

Formula bar of the query editor for each applied step, or the advanced editor of the query editor.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q 
Which of the following is not a valid variable type when programming in the M language?
A. Record
B. List
C. Function
D. Dataframe
A

Dataframe (common in R, but not supported in M)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What language(s) can be used when designing a query in Power BI desktop?

A

SQL, M, DAX

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which of the following can be saved inside a PBIX project file but is never saved inside a PBIT project template file?
A. Datasource Credentials
B. Query Parameters
C. Rows of data imported from tables in external datasources
D. The default values for query parameters

A

Rows of data imported from tables in external datasources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Describe the basic idea of the star schema data model.

A

The model consists of a fact table in the center with the dimension tables surrounding it. The fact table is related to the dimension tables using 1 to many relationships.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is a fact table?

A

Larger tables that contain the meat of the data. Contains line items with numerical values, for example, sales amount.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is a dimension table?

A

Smaller tables with more string type data. Data that describes the fact tables in different ways.

17
Q

When designing a data model with Power BI, which of the following statements are true regarding the rules for creating table relationships?
A. A relationship between 2 tables can be defined using multiple fields from each table.
B. At least one column defined in a table relationship must contain unique values.
C. A relationship between two tables must be defined using a single field from each table.
D. You can define multiple relationships between two tables in a data model but only 1 of the relationships can be marked as active.

A

B,C, and D.

18
Q

True or False: When writing the DAX expression for a calculated column, you can assume your DAX code automatically has row context for the table in which the calculated column is defined.

A

True

19
Q

True or False: When writing the DAX expression for a measure, you can assume your DAX code automatically has row context for the table in which the calculated column is defined.

A

False

20
Q

Describe 3 traits of Calculated Columns

A
  1. Evaluated based on row context.
  2. Evaluated when data model is loaded into memory.
  3. Defined within scope of table inside data model.
21
Q

Describe 3 traits of Measures

A
  1. Evaluated based on current filter context
  2. Commonly used for aggregations
  3. Defined at scope of data model
22
Q

Which of the following is false?
A. When referencing a calculated column in a DAX expression, you must include the table name.
B. When referencing a measure in a DAX expression, you must include the table name.
C. When referencing a measure in a DAX expression, you should prefer not to include the table name.
D. When referencing a measure in a DAX expression, you can optionally include the table name.

A

B

23
Q

What does DAX Stand for?

A

Data Analysis Expressions

MCSA 70-778 (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions