DA-100 Review Flashcards
1
Q
How many rows does R visual support?
A
150,000
2
Q
What does PATH function do?
A
Shows full path of parent and child hierarchy
3
Q
What does PATHITEM do?
A
Shows the segment of a path with second parameter as position in segment.
4
Q
Which data source method needs to be used for Q&A?
A
Import
5
Q
Which data source method should be used for DAX calculated table?
A
Import
6
Q
Which data source method for Analysis services?
A
Live connection
7
Q
By default how many rows does Power Query preview?
A
1000
8
Q
Can Power Query preview the full dataset?
A
Yes
9
Q
Generally speaking, is it recommended to enable power query background refresh?
A
No
10
Q
Is Quick Insights feature available on power bi desktop?
A
No
11
Q
Which data source method for Quick Insights?
A
Import
12
Q
What is the purpose of the Quick Insights feature?
A
Detects downward and upward trends in time series data
13
Q
Which visualization type for scikit learn machine learning visuals?
A
Python
14
Q
What is a main purpose of Power Apps?
A
Take actions within a report
15
Q
What language does D3 use?
A
JavaScript
16
Q
What language does R visuals use?
A
R language
17
Q
What visual types interact differently? (Do not carry filter selections over)
A
Python and R
18
Q
DAX filter expression for roles TRUE() will result in what?
A
View all rows. FALSE() = view no rows
19
Q
How are Custom Visuals added?
A
Admin adds permitted customs visuals to the Organizational visuals
20
Q
What level can a workspace owner endorse dataset without admin verification?
A
Promoted
21
Q
What does tile flow do?
A
Tile flow alights to top left corner
22
Q
Does tile flow affect the mobile view?
A
No
23
Q
How to improve mobile performance and feel?
A
Set slicers to responsive size and rearrange size
24
Q
How to make calendar with start and end date in DAX?
A
Calendar(date(start_date),date(end_date))
25
Which permission allows to download Data without having access to the workspace?
Build Permission
26
What can alerts do?
Send email or Run Power automate flow
27
Can alerts be used to customize mobile notifications?
No. This must be done on individuals mobile device.
28
Can alerts call a webhook?
No
29
What should use to configure RLS
DAX expression
30
What 2 things can be used for dynamic reports?
Parameters / URL as parameter
31
What part of speech can be used in Q&A?
Nouns and adjectives
32
How long are Q&A questions saved for?
28 days
33
Where is power bi refresh configured?
Power Bi Service
34
How many different time slots can be used for refresh in a single day?
48
35
What data source method is for power bi refresh from a web service?
Import
36
What should you use to allow users to easily add new visuals to a dashboard?
View insights
37
What will SUMMARIZE function do?
Generate unique values based on column input.
38
What does VALUES do?
Values selects a single column and gets a unique set of values for that table. Values includes blanks. Distinct does not
39
What 3 ways can you manage home page navigation?
Buttons , bookmarks and images
40
What is common cause of view native query being disable or having an issue?
Common data service does not support query folding
41
What shows anomalies in data?
Column distribution
42
Make aggregation table steps(5)
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
43
Which data source method for DAX created table?
Import
44
What improves performance for direct query?
Turn off interactions between visuals
45
What level are data classifications defined at?
Tenant
46
Is data classifications configured at Azure active security groups level?
No
47
Are data classifications for a dashboard always displayed?
No. Admin can configure this though.
48
Can Q&A be configure as a button ?
Yes
49
Where can you set up the colors for data in a visual?
Dashboard or report theme
50
Where can you setup the tile background color?
Dashboard theme
51
Where can you set the background image?
Dashboard or report theme
52
Create row security steps(5):
```
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
Get overall total without filtering Dax
Calculate(sum(column),removefilters())
54
Do data classifications apply to the entire organization?
Yes
55
Can data classifications be managed by azure security groups?
No
56
When to use biz size?
Bin size means each bucket size is the value
57
When to use bin count
Evenly distributed the range of values for each bin size. Ie 0-12 range, bin count =4. Each bin size =3
58
What settings are required for: list report of power bi home page?
Feature
59
What settings are required for: Make a dataset discoverable without requiring permission from the Power Bi admin?
Promoted
60
What settings are required for: Configure Dashboard so that the sensitivity of its data is visible?
Data Classification
61
How to share report with a guest?
Add guests users to Azure AD B2B, create app and add guest users
62
Do Key Influencers require power bi premium?
No
63
Can you analyze text for positive or negative sentiment in Power Bi desktop?
yes
64
Can you can create your own machine learning models and invoke the models in power bi desktop?
Yes
65
Aggregation DAX
```
Aggregation X function(
KEEPFILTERS(
VALUES(Column)
),
Calculate(
Aggregation(Column)
)
)
```
66
What is the update time of direct query data source method?
Latest Values in datawarehouse
67
What is the update time of flat files without on premises gateway?
When the flat files was last loaded
68
Which workspace role to publish apps?
Member
69
Which workspace role to publish reports?
Contributor
70
Which workspace role to build reports using datasets in different workspaces without any additional configuration?
Contributor
71
Which data role enables advanced analytics capabilities through reports and visualizations?
Data Analyst
72
Which data analyst task has a critical performance impact on reporting and data analysis?
Model
73
Which one of the following options is a key benefit of data analysis?
Informed business decisions
74
What are the building blocks of Power BI?
Visualizations, datasets, reports, dashboards, tiles.
75
A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI?
An app
76
What type of expression do you use to extract data from Microsoft SQL Server?
T-SQL
77
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?
Direct Query
78
What can you do to improve performance when you're getting data in Power BI?
Perform some calculations in the original data source
79
What is a risk of having null values in a numeric column?
That function AVERAGE of data will be incorrect.
80
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?
Append
81
Which of the following selections are not best practices for naming conventions in Power BI?
Abbreviate column names.
82
What does data granularity mean?
Data granularity is the level of detail that is represented in the data.
83
What is the difference between a fact table and a dimension table?
Fact tables contain observational data while dimension tables contain information about specific entities within the data.
84
What is cardinality?
Cardinality is the direction that the data flows in a relationship between two tables.
85
Which two functions will help you compare dates to the previous month?
CALCULATE and PREVIOUSMONTH
86
Why would you want to override the default context?
To create measures that behave according to your intentions, regardless of what the user selects.
87
How do you use an inactive relationship in a single measure?
Use the USERELATIONSHIP function.
88
What benefit do you get from analyzing the metadata?
The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.
89
What benefit do you get from analyzing the metadata?
The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.
90
What benefit do you get from analyzing the metadata?
The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.
90
What benefit do you get from analyzing the metadata?
The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your dataset.
91
What can be achieved by removing unnecessary rows and columns?
Deleting unnecessary rows and columns will reduce a dataset size and its good practice to load only necessary data into your data model.
92
Is it possible to create a relationship between two columns if they are different DATA TYPE columns?
No, both columns in a relationship must be sharing the same DATA TYPE.
93
What is the benefit of using a report tooltip?
To provide additional detail that is specific to the context of the data that is being hovered over.
94
Do you need to import custom visuals each time you want to use them when you are developing a new report?
Yes, custom visuals must be imported from AppSource each time you start developing a new report.
95
Which of the following filters are not available in Power BI reports?
Drillthrough
Page type
Report level
Page level
Page Type
96
How can you analyze performance of each of your report elements?
By using performance analyzer
97
Can you use bookmarks to create a slide show in Power BI?
Yes, you can, by adding buttons as navigation to go between saved bookmarks.
98
What is a dashboard?
A canvas of report elements that can be built in Power BI service
99
What is one way that reports and dashboards differ?
In reports, you can have multiple pages; in dashboards, you can have only one page.
100
Where can you configure and set data alerts?
Data alerts can be set only in Power BI service on specific visuals such as KPI cards, gauges, and cards.
101
Why are parameters important in Power BI paginated reports?
They allow the user to control aspects of how the report is rendered when the report is run.
102
Power BI paginated reports are created by using which tool?
Power BI Report Builder
103
Power BI paginated reports is an evolved technology that was built from which original tool?
SQL Server Reporting Services
104
What Power BI feature can give an in-depth analysis of the distribution of data?
The Analyze feature allows a user to understand why the distribution looks the way that it does.
105
Where are time series charts located?
Time series charts can be imported from AppSource.
106
What visual should be used to display outliers?
The scatter chart is best-suited to display outliers.
107
What does the AI splits feature do?
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
Can you access the Q&A feature by using buttons?
Yes, you can access the Q&A feature by selecting Q&A button type.
109
Which of the following selections are not features of the Q&A visual?
Searching for help topics about Power BI.
110
What does the decomposition tree NOT enable you to do?
Conduct what-if analysis with built-in parameters.
111
How is the Admin workspace role different from other types of workspace roles?
Admin is the only role that can add and remove users.
112
What feature in Power BI service can you use to troubleshoot the flow of data from its source to its destination?
Lineage view
113
2. What reserved parameters configure the start and end of where Incremental refresh should occur?
Start and End parameters
StartRange and EndRange
RangeStart and RangeEnd
RangeStart and RangeEnd
114
What is the difference between Promotion and Certification when you are endorsing a dataset?
Promotion does not need specific permissions while Certification requires permission from the dataset owner to access to the dataset.
115
Which function will tell you the username of the person who is signed in to Power BI service?
USERPRINCIPALNAME()
116
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
Both Power BI Desktop and Power BI service
117
When using conditional formatting for a percent how should you declare the percent threshold? (Number or Percent)
Select percent column and declare the threshold as a decimal of 1 and as a NUMBER
