Brainscape's Knowledge GenomeTM

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


See full index

Power BI Certification > PBI > Flashcards

PBI Flashcards

1
Q

When can you import local files in Power BI

A

For data that does not change

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

Why might it be necessary to return and change connection settings in Power BI Desktop after creating a data source connection and loading data?

A

Due to changes in the organization’s security policy, such as updating passwords

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

What are the possible actions that can be taken when returning to change connection settings in Power BI Desktop after loading data?

A

data source, edit permissions or clear permissions.

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

When working in Power BI, what is the recommended best practice for optimizing data retrieval and usage from a relational database?

A

Writing a query in a view, similar to a table in a relational database

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

NoSQL (non-relational) databases

A

flexible database systems that do not use tables to store data

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

Preview pane for cosmo db (no sql db) shows

A

The preview pane only shows Record items because all records in the document are represented as a Record type in Power B

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

Importing the data in to Power BI means

A

that the data is stored in the Power BI file and gets published along with the Power BI reports

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

Why might you NOT want to use import mode in PBI

A

Security Reasons

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

Why is direct query useful?

A

because it ensures you’re always viewing the most recent version of the data.

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

The three different types of storage modes you can choose from:

A

Import
DirectQuery
Dual (Composite)

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

How to switch storage mode

A

Model view -> select a table -> Properties pane -> storage mode drop down

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

Import mode (3 attributes)

A
  1. Create a local PBI Copy of you semantic models
  2. Can use all PBI Services including Q&A and Quick Insights
  3. Data refreshed can be scheduled or on demand
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

DirectQuery Mode Attributes

A
  1. Useful when you dont want to save local copies of data (Data wont be cached)
  2. Direct connection to the data source
  3. Viewing most up to date data
  4. Suited for when you have large semantic models (Improved performance)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Dual (Composite mode)

A
  1. Can ID some data to be directly imported and other data the must be querried
  2. Limited M transformations
  3. Restricted DAX functions in calculated columns
  4. Same constraints as directquery
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Azure Analysis Services

A

fully managed platform as a service (PaaS) that provides enterprise-grade semantic models in the cloud

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

differences between Azure Analysis Services and SQL Server are:

A
  1. Analysis Services models have calculations already created
  2. Can query the data directly using MDX or DAX
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Fast Refresh Schedule Analysis Services

A

When data is refreshed in the service Power BI Reports will immediately be updated

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

The performance of Power Query depends on

A

The performance at the data source level

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

Power Query takes advantage of good performance at the data source through

A

Query Folding

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

Query folding

A

the process by which the transformations and edits that you make in Power Query Editor are simultaneously tracked as native queries, or simple Select SQL statements, while you’re actively making transformations

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

The benefits to query folding include:

A
  1. More efficiency in data refreshes and incremental refreshes.
  2. Automatic compatibility with DirectQuery and Dual storage modes.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

If the View Native Query option isn’t available

A

then query folding isn’t possible for this step, and you’ll have to work backward in the Applied Steps area until you reach the step in which View Native Query is available (displays in bold type).

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

Native queries aren’t possible for the following transformations:

A

1.Adding an index column
2. Merging and appending columns of different tables with two different sources
3. Changing the data type of a column

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

Other ways to optimize query performance in Power BI include:

A

1.Process as much data as possible in the original data source.
2.Use native SQL queries.
3. Separate date and time, if bound together.

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

What is a query timeout in relational source systems?

A

Relational source systems often implement query timeouts to prevent a single user from monopolizing hardware resources. These timeouts limit the duration a query can run and can be configured for various timespans, from seconds to minutes or more. The purpose is to manage concurrent usage of data in the same database.

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

Power BI Query Error: Timeout expired

A

indicates that you’ve pulled too much data according to your organization’s policies.

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

Ways to resolve “Power BI Query Error: Timeout expired”

A
  1. Pull in fewer columns or rows
  2. Reduce complexity of SQL
  3. Bring data in small chunks and combine using Power Query
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

We couldn’t find any data formatted as a table error

A

When importing data from excel power bi may not be able to find a table

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

A calculated table formula must return

A

a table object

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

Calculated tables have a cost

A
  1. Increase the model storage size
  2. Prolong data refresh time
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

A calculate column must return

A

a scalar or single value

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

calculated columns in import models have a cost

A
  1. Increase the model storage size
  2. prolong the data refresh time
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Row Context

A

The current row

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

Referencing a column in another table when the two tables are not related

A

Use the LOOKUPVALUE dax function

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

Relatedtable

A

Retrieves values on the many-side of a relationship and returns a table object

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

Iterator functions

A

provide you with flexibility to create sophisticated summarizations

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

Three ways to add columns

A
  1. Add columns to a view or table as a persisted column
  2. Add custom columns (using M) to Power Query queries
  3. add calculated columns (using DAX) to model tables
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Preference to add custom columns

A

Is in Power Query whenever possible because they load to the model in a more compact and optimal way

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

Unpivot columns

A
  1. Creates Attribute and Value columns
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Pivot columns

A

convert your flat data into a table that contains an aggregate value for each unique value in a column

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

Best practices when naming tables, columns and measures

A
  1. Remove “_”
  2. Remove prefixes and suffixes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

Report objects include

A
  1. Visuals
  2. Elements
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Visuals - Report Objects

A

Visualizations of the semantic model data

44
Q

Elements - Report Objects

A

Provide visual interest but dont use semantic model data (Buttons, shapes, and images)

45
Q

Categorical Visual Types

A
  1. Bar charts
  2. Column Charts
46
Q

Categorical Visuals are Good For

A

When you need to show data across multiple categories

47
Q

You should sort categorical visuals by

A

The value rather than the in alphabetical category order

48
Q

Time series visuals should be used when

A

You want to show values over time

49
Q

Time Series Visual Types

A
  1. Line Chart
  2. Column Chart
  3. Stacked column chart
  4. Area chart
  5. Line and stacked column chart
  6. Ribbon chart
50
Q

When should you use a column chart vs a line chart

A

Us a columns chart when there are missing values

51
Q

Ribbon Chart added benefits

A

Shows rank changes over time

52
Q

Proportional Visuals are good for

A

Showing data as part of a whole; How a value is distributed across a dimension

53
Q

Can you plot negative and positive numbers on a proportional visual?

A

All number must be either All Positive or All Negative

54
Q

Proportional Visuals Types

A

1.100% Stacked Column chart

  1. Funnel chart
  2. Treemap
  3. Pie chart
  4. Doughnut chart
55
Q

Numerical Visuals show

A

show high level callouts that demand immediate attention

Communicate important data quickly

56
Q

Grid Visuals can Convey

A

A lot of detailed information

57
Q

Best visual for hierarchical navigation

A

Matrices

58
Q

Performance Visuals

A

Communicate performance by describing a value and its comparison with a target

59
Q

Core Performance Visuals

A
  1. Gauge
  2. KPI
  3. Table, with conditional formatting
  4. Matrix, with conditional formatting
60
Q

Instead of using a map visual which takes up a lot of space you can use a

A

Categorical visual

61
Q

Filtering can occur at five different levels of a PBI Report

A
  1. Semantic Model (RLS)
  2. Report
  3. Page
  4. Visual
  5. Measure
62
Q

DAX

A

Data Analysis Expression

63
Q

When can you not create a measure

A

When the model is a live connection to SQL Server Analysis Services multidimensional model

64
Q

Unlike report and page-level filters, visual-level filters can filter by

A

using a measure

65
Q

In order to reduce the load on a semantic model when applying multiple filters

A

add an apply button which applies the filters all at once

66
Q

Advantages of using filterpane

A
  1. Consistent Location
  2. Allows you to configure advanced filter types
  3. Search box and sort functions
  4. Faster
  5. Lock and Hide filters
  6. Apply button
  7. Filter using a measure
67
Q

Disadvantages of using filterpane

A
  1. Less design flexibility
  2. Confusion when filters are hidden and locked
  3. Easy to lose track of applied filters
68
Q

Advantages of using a slicer

A
  1. Place them anywhere
  2. Highly configurable
  3. You can configure hierarchical slicers
  4. They can display their selection
  5. They can display images
  6. can selectively filter visuals
  7. You can filter slicers
  8. you can sort slicer items
  9. synced slicers can filter other pages in a report
69
Q

Disadvantages of using a slicer

A
  1. Slicers can have an impact of report render performance
  2. occupy space on the page
  3. filtering options are less complex
70
Q

Benefits of creating a workspaces

A
  1. House reports in one location
  2. Make them shareable
  3. collaborate with other teams
  4. Update reports
71
Q

What access should you give people?

A

The minimum access necessary to collaborate

72
Q

4 roles in a workspace

A
  1. Admin
  2. Member
  3. Contributor
  4. Viewer
73
Q

Admin Access

A
  1. Update and delete the workspace
  2. add of remove people including other admins
74
Q

Member access

A
  1. Add members or others with low permissions
  2. publish, unpublish and change permissions for an app
75
Q

Contributor access

A
  1. create, edit and delete content such as reports in the workspace
  2. publish reports to the workspace
76
Q

Viewer Access

A
  1. View and interact with an item
  2. Read data that’s stored in workspace dataflows
77
Q

Who can view usage metrics reports

A
  1. Admin, Member, and contributor
  2. Must have a pro license
78
Q

Advantages of using a deployment pipeline

A
  1. Increased productivity
  2. Faster delivery of content
  3. Lower human intervention required
79
Q

Sensitivity Labels

A

Specify which data can be exported

80
Q

Two types of on-premise data gateways

A
  1. Oranization mode
  2. Personal mode
81
Q

Organization mode

A

Allows multiple users to connect to multiple on-premise data sources and is suitable for complex scenarios

82
Q

Personal Mode

A

Allows one user to connect to data sources

83
Q

Two ways to endorse semantic models

A
  1. Promotion
  2. Certification
84
Q

Promotion

A

Promote your semantic models when they are ready for broad usage

85
Q

Certification

A

Request certification for a promoted semantic model

86
Q

Query Caching

A

Local caching feature that maintains results on a user and report basis

87
Q

Reserved parameters for incremental refresh

A
  1. RangeStart
  2. RangeEnd
88
Q

Permission needed for promotion and certification

A
  1. Promotion does not need specific permission
  2. Certification requires permission from the semantic model owner to access to the semantic model
89
Q

Data Alerts

A

Notify you or a user that a specific data point is above, below, or at a specific threshold

90
Q

Data alerts are available for

A
  1. KPI Visuals
  2. gauges
  3. cards
91
Q

Q&A Feature

A

A tool within PBI Desktop that allows you to ask natural language questions about the data

92
Q

Q&A Visual consists of three main elements

A
  1. Question box
  2. Pre-populated suggestion tiles
  3. pin visual
93
Q

Quick Insights

A

Uses machine learning algorithms to go over your entire semantic model and produce insights for you quickly

94
Q

4 actions you can perform with quick insights

A
  1. Filter the visualization
  2. pin the insight card to a dashboard
  3. Run insights on the card
  4. Return to the original insights canvas
95
Q

2 ways of implementing RLS

A
  1. Statis
  2. Dynamic
96
Q

Static RLS

A

Uses a fixed value in the DAX Filter

97
Q

Dynamic RLS

A

Uses a dax function

98
Q

Where do you go to create RLS roles in PBI Desktop?

A

Modeling Tab -> Manage Roles

99
Q

Column distribution

A

Show you the distribution of the data within the column and the counts of distinct and unique values

100
Q

Column Profile

A
  1. Row count
  2. Empty rows and strings
  3. Min and max
101
Q

Value distribution

A

Graph that tells you the counts for each distinct value in that specific column

102
Q

Column Statistics

A

On a numeric column will include how many zeroes and null values exist along with the average value, standard deviation and how many even and odd values are in the column

103
Q

What is a risk of having null values in a numeric column?

A

That function AVERAGE of data will be incorrect.

104
Q

If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?

A

Append

105
Q

Which of the following selections aren’t best practices for naming conventions in Power BI?

A

Abbreviate column names.

106
Q

Start Schema

A

Each table within your semantic model is defined as a dimension or a fact table

Power BI Certification (1 decks)

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