Brainscape's Knowledge GenomeTM

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


See full index

Da-100 PowerBi > DA-100 Review > Flashcards

DA-100 Review Flashcards

1
Q

How many rows does R visual support?

A

150,000

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

What does PATH function do?

A

Shows full path of parent and child hierarchy

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

What does PATHITEM do?

A

Shows the segment of a path with second parameter as position in segment.

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

Which data source method needs to be used for Q&A?

A

Import

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

Which data source method should be used for DAX calculated table?

A

Import

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

Which data source method for Analysis services?

A

Live connection

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

By default how many rows does Power Query preview?

A

1000

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

Can Power Query preview the full dataset?

A

Yes

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

Generally speaking, is it recommended to enable power query background refresh?

A

No

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

Is Quick Insights feature available on power bi desktop?

A

No

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

Which data source method for Quick Insights?

A

Import

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

What is the purpose of the Quick Insights feature?

A

Detects downward and upward trends in time series data

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

Which visualization type for scikit learn machine learning visuals?

A

Python

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

What is a main purpose of Power Apps?

A

Take actions within a report

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

What language does D3 use?

A

JavaScript

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

What language does R visuals use?

A

R language

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

What visual types interact differently? (Do not carry filter selections over)

A

Python and R

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

DAX filter expression for roles TRUE() will result in what?

A

View all rows. FALSE() = view no rows

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

How are Custom Visuals added?

A

Admin adds permitted customs visuals to the Organizational visuals

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

What level can a workspace owner endorse dataset without admin verification?

A

Promoted

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

What does tile flow do?

A

Tile flow alights to top left corner

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

Does tile flow affect the mobile view?

A

No

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

How to improve mobile performance and feel?

A

Set slicers to responsive size and rearrange size

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

How to make calendar with start and end date in DAX?

A

Calendar(date(start_date),date(end_date))

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

Which permission allows to download Data without having access to the workspace?

A

Build Permission

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

What can alerts do?

A

Send email or Run Power automate flow

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

Can alerts be used to customize mobile notifications?

A

No. This must be done on individuals mobile device.

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

Can alerts call a webhook?

A

No

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

What should use to configure RLS

A

DAX expression

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

What 2 things can be used for dynamic reports?

A

Parameters / URL as parameter

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

What part of speech can be used in Q&A?

A

Nouns and adjectives

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

How long are Q&A questions saved for?

A

28 days

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

Where is power bi refresh configured?

A

Power Bi Service

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

How many different time slots can be used for refresh in a single day?

A

48

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

What data source method is for power bi refresh from a web service?

A

Import

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

What should you use to allow users to easily add new visuals to a dashboard?

A

View insights

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

What will SUMMARIZE function do?

A

Generate unique values based on column input.

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

What does VALUES do?

A

Values selects a single column and gets a unique set of values for that table. Values includes blanks. Distinct does not

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

What 3 ways can you manage home page navigation?

A

Buttons , bookmarks and images

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

What is common cause of view native query being disable or having an issue?

A

Common data service does not support query folding

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

What shows anomalies in data?

A

Column distribution

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

Make aggregation table steps(5)

A

1 create new agg table
2 select base table and select manage aggregations
3 select new agg table as aggregation table
4 select summarization type
5 select the base table columns

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

Which data source method for DAX created table?

A

Import

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

What improves performance for direct query?

A

Turn off interactions between visuals

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

What level are data classifications defined at?

A

Tenant

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

Is data classifications configured at Azure active security groups level?

A

No

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

Are data classifications for a dashboard always displayed?

A

No. Admin can configure this though.

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

Can Q&A be configure as a button ?

A

Yes

49
Q

Where can you set up the colors for data in a visual?

A

Dashboard or report theme

50
Q

Where can you setup the tile background color?

A

Dashboard theme

51
Q

Where can you set the background image?

A

Dashboard or report theme

52
Q

Create row security steps(5):

A 
1 create roles in power bi desktop
2 select dimension table 
3 add Dax expression using filter with column
4 publish to power bi service
5 assign each user to role
53
Q

Get overall total without filtering Dax

A

Calculate(sum(column),removefilters())

54
Q

Do data classifications apply to the entire organization?

A

Yes

55
Q

Can data classifications be managed by azure security groups?

A

No

56
Q

When to use biz size?

A

Bin size means each bucket size is the value

57
Q

When to use bin count

A

Evenly distributed the range of values for each bin size. Ie 0-12 range, bin count =4. Each bin size =3

58
Q

What settings are required for: list report of power bi home page?

A

Feature

59
Q

What settings are required for: Make a dataset discoverable without requiring permission from the Power Bi admin?

A

Promoted

60
Q

What settings are required for: Configure Dashboard so that the sensitivity of its data is visible?

A

Data Classification

61
Q

How to share report with a guest?

A

Add guests users to Azure AD B2B, create app and add guest users

62
Q

Do Key Influencers require power bi premium?

A

No

63
Q

Can you analyze text for positive or negative sentiment in Power Bi desktop?

A

yes

64
Q

Can you can create your own machine learning models and invoke the models in power bi desktop?

A

Yes

65
Q

Aggregation DAX

A 
Aggregation X function(
KEEPFILTERS(
VALUES(Column)
),
Calculate(
Aggregation(Column)
)
)
66
Q

What is the update time of direct query data source method?

A

Latest Values in datawarehouse

67
Q

What is the update time of flat files without on premises gateway?

A

When the flat files was last loaded

68
Q

Which workspace role to publish apps?

A

Member

69
Q

Which workspace role to publish reports?

A

Contributor

70
Q

Which workspace role to build reports using datasets in different workspaces without any additional configuration?

A

Contributor

71
Q

Which data role enables advanced analytics capabilities through reports and visualizations?

A

Data Analyst

72
Q

Which data analyst task has a critical performance impact on reporting and data analysis?

A

Model

73
Q

Which one of the following options is a key benefit of data analysis?

A

Informed business decisions

74
Q

What are the building blocks of Power BI?

A

Visualizations, datasets, reports, dashboards, tiles.

75
Q

A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI?

A

An app

76
Q

What type of expression do you use to extract data from Microsoft SQL Server?

A

T-SQL

77
Q

You’re creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect?

A

Direct Query

78
Q

What can you do to improve performance when you’re getting data in Power BI?

A

Perform some calculations in the original data source

79
Q

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

A

That function AVERAGE of data will be incorrect.

80
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

81
Q

Which of the following selections are not best practices for naming conventions in Power BI?

A

Abbreviate column names.

82
Q

What does data granularity mean?

A

Data granularity is the level of detail that is represented in the data.

83
Q

What is the difference between a fact table and a dimension table?

A

Fact tables contain observational data while dimension tables contain information about specific entities within the data.

84
Q

What is cardinality?

A

Cardinality is the direction that the data flows in a relationship between two tables.

85
Q

Which two functions will help you compare dates to the previous month?

A

CALCULATE and PREVIOUSMONTH

86
Q

Why would you want to override the default context?

A

To create measures that behave according to your intentions, regardless of what the user selects.

87
Q

How do you use an inactive relationship in a single measure?

A

Use the USERELATIONSHIP function.

88
Q

What benefit do you get from analyzing the metadata?

A

The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.

89
Q

What benefit do you get from analyzing the metadata?

A

The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.

90
Q

What benefit do you get from analyzing the metadata?

A

The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.

90
Q

What benefit do you get from analyzing the metadata?

A

The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.

91
Q

What can be achieved by removing unnecessary rows and columns?

A

Deleting unnecessary rows and columns will reduce a dataset size and its good practice to load only necessary data into your data model.

92
Q

Is it possible to create a relationship between two columns if they are different DATA TYPE columns?

A

No, both columns in a relationship must be sharing the same DATA TYPE.

93
Q

What is the benefit of using a report tooltip?

A

To provide additional detail that is specific to the context of the data that is being hovered over.

94
Q

Do you need to import custom visuals each time you want to use them when you are developing a new report?

A

Yes, custom visuals must be imported from AppSource each time you start developing a new report.

95
Q

Which of the following filters are not available in Power BI reports?

Drillthrough

Page type

Report level

Page level

A

Page Type

96
Q

How can you analyze performance of each of your report elements?

A

By using performance analyzer

97
Q

Can you use bookmarks to create a slide show in Power BI?

A

Yes, you can, by adding buttons as navigation to go between saved bookmarks.

98
Q

What is a dashboard?

A

A canvas of report elements that can be built in Power BI service

99
Q

What is one way that reports and dashboards differ?

A

In reports, you can have multiple pages; in dashboards, you can have only one page.

100
Q

Where can you configure and set data alerts?

A

Data alerts can be set only in Power BI service on specific visuals such as KPI cards, gauges, and cards.

101
Q

Why are parameters important in Power BI paginated reports?

A

They allow the user to control aspects of how the report is rendered when the report is run.

102
Q

Power BI paginated reports are created by using which tool?

A

Power BI Report Builder

103
Q

Power BI paginated reports is an evolved technology that was built from which original tool?

A

SQL Server Reporting Services

104
Q

What Power BI feature can give an in-depth analysis of the distribution of data?

A

The Analyze feature allows a user to understand why the distribution looks the way that it does.

105
Q

Where are time series charts located?

A

Time series charts can be imported from AppSource.

106
Q

What visual should be used to display outliers?

A

The scatter chart is best-suited to display outliers.

107
Q

What does the AI splits feature do?

A

AI splits work by considering all available fields and determining which one to drill into to get the highest/lowest value of the measure that is being analyzed.

108
Q

Can you access the Q&A feature by using buttons?

A

Yes, you can access the Q&A feature by selecting Q&A button type.

109
Q

Which of the following selections are not features of the Q&A visual?

A

Searching for help topics about Power BI.

110
Q

What does the decomposition tree NOT enable you to do?

A

Conduct what-if analysis with built-in parameters.

111
Q

How is the Admin workspace role different from other types of workspace roles?

A

Admin is the only role that can add and remove users.

112
Q

What feature in Power BI service can you use to troubleshoot the flow of data from its source to its destination?

A

Lineage view

113
Q
  1. What reserved parameters configure the start and end of where Incremental refresh should occur?

Start and End parameters

StartRange and EndRange

RangeStart and RangeEnd

A

RangeStart and RangeEnd

114
Q

What is the difference between Promotion and Certification when you are endorsing a dataset?

A

Promotion does not need specific permissions while Certification requires permission from the dataset owner to access to the dataset.

115
Q

Which function will tell you the username of the person who is signed in to Power BI service?

A

USERPRINCIPALNAME()

116
Q

Where can you test RLS by using different security roles?

Power BI Desktop only

Power BI service only

Both Power BI Desktop and Power BI service

A

Both Power BI Desktop and Power BI service

117
Q

When using conditional formatting for a percent how should you declare the percent threshold? (Number or Percent)

A

Select percent column and declare the threshold as a decimal of 1 and as a NUMBER

Da-100 PowerBi (1 decks)

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