DA-100 Review Flashcards
How many rows does R visual support?
150,000
What does PATH function do?
Shows full path of parent and child hierarchy
What does PATHITEM do?
Shows the segment of a path with second parameter as position in segment.
Which data source method needs to be used for Q&A?
Import
Which data source method should be used for DAX calculated table?
Import
Which data source method for Analysis services?
Live connection
By default how many rows does Power Query preview?
1000
Can Power Query preview the full dataset?
Yes
Generally speaking, is it recommended to enable power query background refresh?
No
Is Quick Insights feature available on power bi desktop?
No
Which data source method for Quick Insights?
Import
What is the purpose of the Quick Insights feature?
Detects downward and upward trends in time series data
Which visualization type for scikit learn machine learning visuals?
Python
What is a main purpose of Power Apps?
Take actions within a report
What language does D3 use?
JavaScript
What language does R visuals use?
R language
What visual types interact differently? (Do not carry filter selections over)
Python and R
DAX filter expression for roles TRUE() will result in what?
View all rows. FALSE() = view no rows
How are Custom Visuals added?
Admin adds permitted customs visuals to the Organizational visuals
What level can a workspace owner endorse dataset without admin verification?
Promoted
What does tile flow do?
Tile flow alights to top left corner
Does tile flow affect the mobile view?
No
How to improve mobile performance and feel?
Set slicers to responsive size and rearrange size
How to make calendar with start and end date in DAX?
Calendar(date(start_date),date(end_date))
Which permission allows to download Data without having access to the workspace?
Build Permission
What can alerts do?
Send email or Run Power automate flow
Can alerts be used to customize mobile notifications?
No. This must be done on individuals mobile device.
Can alerts call a webhook?
No
What should use to configure RLS
DAX expression
What 2 things can be used for dynamic reports?
Parameters / URL as parameter
What part of speech can be used in Q&A?
Nouns and adjectives
How long are Q&A questions saved for?
28 days
Where is power bi refresh configured?
Power Bi Service
How many different time slots can be used for refresh in a single day?
48
What data source method is for power bi refresh from a web service?
Import
What should you use to allow users to easily add new visuals to a dashboard?
View insights
What will SUMMARIZE function do?
Generate unique values based on column input.
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
What 3 ways can you manage home page navigation?
Buttons , bookmarks and images
What is common cause of view native query being disable or having an issue?
Common data service does not support query folding
What shows anomalies in data?
Column distribution
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
Which data source method for DAX created table?
Import
What improves performance for direct query?
Turn off interactions between visuals
What level are data classifications defined at?
Tenant
Is data classifications configured at Azure active security groups level?
No
Are data classifications for a dashboard always displayed?
No. Admin can configure this though.
Can Q&A be configure as a button ?
Yes
Where can you set up the colors for data in a visual?
Dashboard or report theme
Where can you setup the tile background color?
Dashboard theme
Where can you set the background image?
Dashboard or report theme
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
Get overall total without filtering Dax
Calculate(sum(column),removefilters())
Do data classifications apply to the entire organization?
Yes
Can data classifications be managed by azure security groups?
No
When to use biz size?
Bin size means each bucket size is the value
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
What settings are required for: list report of power bi home page?
Feature
What settings are required for: Make a dataset discoverable without requiring permission from the Power Bi admin?
Promoted
What settings are required for: Configure Dashboard so that the sensitivity of its data is visible?
Data Classification
How to share report with a guest?
Add guests users to Azure AD B2B, create app and add guest users
Do Key Influencers require power bi premium?
No
Can you analyze text for positive or negative sentiment in Power Bi desktop?
yes
Can you can create your own machine learning models and invoke the models in power bi desktop?
Yes
Aggregation DAX
Aggregation X function( KEEPFILTERS( VALUES(Column) ), Calculate( Aggregation(Column) ) )
What is the update time of direct query data source method?
Latest Values in datawarehouse
What is the update time of flat files without on premises gateway?
When the flat files was last loaded
Which workspace role to publish apps?
Member
Which workspace role to publish reports?
Contributor
Which workspace role to build reports using datasets in different workspaces without any additional configuration?
Contributor
Which data role enables advanced analytics capabilities through reports and visualizations?
Data Analyst
Which data analyst task has a critical performance impact on reporting and data analysis?
Model
Which one of the following options is a key benefit of data analysis?
Informed business decisions
What are the building blocks of Power BI?
Visualizations, datasets, reports, dashboards, tiles.
A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI?
An app
What type of expression do you use to extract data from Microsoft SQL Server?
T-SQL
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
What can you do to improve performance when you’re getting data in Power BI?
Perform some calculations in the original data source
What is a risk of having null values in a numeric column?
That function AVERAGE of data will be incorrect.
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
Which of the following selections are not best practices for naming conventions in Power BI?
Abbreviate column names.
What does data granularity mean?
Data granularity is the level of detail that is represented in the data.
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.
What is cardinality?
Cardinality is the direction that the data flows in a relationship between two tables.
Which two functions will help you compare dates to the previous month?
CALCULATE and PREVIOUSMONTH
Why would you want to override the default context?
To create measures that behave according to your intentions, regardless of what the user selects.
How do you use an inactive relationship in a single measure?
Use the USERELATIONSHIP function.
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.
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.
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.
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.
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.
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.
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.
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.
Which of the following filters are not available in Power BI reports?
Drillthrough
Page type
Report level
Page level
Page Type
How can you analyze performance of each of your report elements?
By using performance analyzer
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.
What is a dashboard?
A canvas of report elements that can be built in Power BI service
What is one way that reports and dashboards differ?
In reports, you can have multiple pages; in dashboards, you can have only one page.
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.
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.
Power BI paginated reports are created by using which tool?
Power BI Report Builder
Power BI paginated reports is an evolved technology that was built from which original tool?
SQL Server Reporting Services
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.
Where are time series charts located?
Time series charts can be imported from AppSource.
What visual should be used to display outliers?
The scatter chart is best-suited to display outliers.
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.
Can you access the Q&A feature by using buttons?
Yes, you can access the Q&A feature by selecting Q&A button type.
Which of the following selections are not features of the Q&A visual?
Searching for help topics about Power BI.
What does the decomposition tree NOT enable you to do?
Conduct what-if analysis with built-in parameters.
How is the Admin workspace role different from other types of workspace roles?
Admin is the only role that can add and remove users.
What feature in Power BI service can you use to troubleshoot the flow of data from its source to its destination?
Lineage view
- 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
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.
Which function will tell you the username of the person who is signed in to Power BI service?
USERPRINCIPALNAME()
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
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