NEW
Font size
WorksheetsPower BI Quiz
Total questions: 50
Worksheet time: 25mins
1 Who enables advanced analytics capabilities through reports and visualizations?
A.Data Visualizer
B.Data Scientist
C.Data Engineer
D.Data Analyst
2 Which data analyst task has a critical performance impact on reporting and data analysis?
A.Analyze
B.Visualize
C.Mining
D.Model
3 Which of the following is an important step for understanding and interpreting the information that is displayed on the report?
A.Analytics
B.Complex Reports
C.Informed Business Decisions
D.Complex Dashboards
4 Select the building blocks of Power BI.
A.Tiles and Dashboards
B.Visual Studio, C#, and JSON files
C.Datasets, Visualizations, Reports, Dashboards, and Tiles
D.Databases and Mobile Devices
5 The common flow of activity in Power BI is described by?
A.Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards
B.Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.
C.Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.
D.Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.
6 Which of the following is a collection of ready-made visuals which is pre-arranged in dashboards and reports?
A.Canvas
B.App
C.Dataset
D.Scheduled refresh
7 Which of the following is used to query the data from Microsoft SQL Server?
A.DAX
B.T-SQL
C.MDX
D.DML
8 You are creating a Power BI report with data from an Azure Analysis Services Cube. The data should be available immediately in the Power BI report whenever the data refreshes in the cube. How should you connect?
A.Connect Live
B.Import
C.Direct Query
D.Indirect Query
9 What should you do to improve performance while getting data in Power BI?
A.Only pull data into the Power BI service not Power BI Desktop
B.Use the Select SQL statement in your SQL queries when you are pulling data from a relational database
C.Combine date and time columns into a single column
D.Do some calculations in the original data source
10 Which storage mode leaves the data at the data source?
A.Import
B.DirectQuery
C.Dual
D.None of the Above
11 Which of the following option improves performance by generating a single query statement to retrieve and transform source data?
A.Query folding
B.Adding index columns
C.Adding custom columns with complex logic
D.None of the Above
12 What type of import error might leave a column blank?
A.Keep errors
B.Unpivot columns
C.Data type error
D.All of the Above
13 Which of the following is the primary data preparation tool in Power BI?
A.Report Editor
B.Power Query Editor
C.Data Editor
D.Data Visualizer
14 You need to shape data by converting your flat data into a table that contains aggregated value for each unique value in a column. What is this process called ?
A.Group by columns
B.Pivot (pivoting a column)
C.Manage aggregations
D.Group by Rows
15 What can be achieved by removing unnecessary rows and columns?
A.It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.
B.Deleting unnecessary rows and columns can damage the structure of the data model.
C.Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.
D.None of the Above
16 To detect the type of data in the columns, how many rows does Power Query scan ?
A.10,000
B.1,000
C.100
D.10
17 Which of the following is the correct definition of data profiling ?
A.Aggregating columns containing numeric data
B.Studying the nuances of the data
C.Data modeling
D.Data Visualization
18 Which of the following is the risk of including null values in a numeric column?
A.AX expressions with MAX data will be incorrect
B.DAX expressions with SUM data will be incorrect
C.DAX expressions with AVERAGE data will be incorrect
D.DAX expressions with MIM data will be incorrect
19 Which of the following is not a best practice for naming conventions in Power BI?
ARename columns with spaces in them
B.Replace values that have integers with human-readable results
C.Abbreviated column names
D.None of the Above
20 Which of the following functionalities allows one see the code that is generated as part of each transformation step?
A.Advanced editor
B.Data profiling
C.Queries pane
D.Data Manipulation
21 You have two queries that contain different data with the same structure and you are required to combine them into one query. Which of the following operations should you perform?
A. Merge
B. Append
C. Combine column
D.Combine Row
22 You are required to related filter facts differently. Which of the below dimensions should you choose?
A.Role-playing dimension
B.Snowflake dimension
C.Degenerate dimension
D.Regenerate dimension
23 You need to store details about business entities Which of the following table should you use ?
A.Fact table
B.Dimension table
C.Date table
D.table
24 What are the two types of tables in a star schema known?
A.Active and inactive tables
BQualitative and quantitative data tables
C.Fact and dimension tables
D.None of the Above
25 What is the difference between a fact table and a dimension table?
A.Fact tables store observations or events while dimension tables contain information about specific entities within the data.
B.Fact tables contain information about specific entities while dimension tables contain information about observational data.
C.Dimension tables explain about specific roles in Power BI while fact tables explain the information about facts that are associated with those roles in Power BI.
D.There is no difference
26 What is Cardinality?
A.Cardinality is how long it takes for the data to load.
B.Cardinality is the granularity of the data.
C.The direction that the data flows in a relationship between two tables is Cardinality.
D.Cardinality is a type of visual element.
27 What is it called when multiple records in one table are associated with multiple records in another table?
A.Many-to-many relationship
B.One-to-many relationship
C.Many-to-one relationship
D.One-to-one relationship
28 You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?
A.Stacked area chart
B.Donut chart
C.Line chart
D.Waterfall chart
29 You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of these functions. What should you recommend?
A.Merge tables by using Power Query
B.Hide unused columns in the model
C.Split the model into multiple models
D.Transpose
30 What is calculated on demand?
A.Calculated tables
B.Measures
C.Calculated rows
D.Calculated columns
31 Which are calculated based on filters that are used by the report user?
A.Measures
B.Calculated columns
C.Calculated rows
D.Calculated tables
32 Which DAX function evaluates an expression in a modified filter context?
A.SUMX
B.CALCULATE
C.ALL
D.AVERAGE
33 You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?
A.Area chart
B.Donut chart
C.Scatter chart
D.Pie chart
34 What type of Measure uses SUM to aggregate over one set of dimensions and a different aggregation over a different set of dimensions?
A.Additive
B.Aggregate
C.Semi-additive
D.None of the Above
35 You need to manipulate data using time periods. What type of functions should you choose?
A.Time intelligence
B.Comparer functions
C.Value functions
D.Additive functions
36 Which two functions will help you compare dates to the previous month?
A.TOTALYTD and PREVIOUSMONTH
B.CALCULATE and TOTALTYD
C.CALCULATE and PREVIOUSMONTH
D.None of the Above
37 What benefit do you get from analyzing metadata?
A.The benefit of analyzing metadata is that you can clearly identify data inconsistencies with your dataset.
B.The benefit of analyzing the metadata is to get familiar with your data.
C.The benefit of analyzing the metadata is to know the number of rows, columns, and tables being loaded into your model.
D.The benefit of analyzing the metadata is to easily upload data.
38 You need to identify bottlenecks that exist in a code. Which tool should you use?
A.Q&A
B.Column profiling
C.Performance analyzer
D.Row profiling
39 You open a query in the Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?
A.Show whitespace
B.Column profile
C.Column distribution
D.Column quality
40 Which Power BI option gives you the option to send fewer queries and disable certain interactions?
A.Direct query
B.Query reduction
C.Query diagnostics
D.Indirect query
41 Where else can performance improvement be done except Power BI?
A.At the data source
B.In the Power BI service
C.In Microsoft SharePoint
D.In Microsoft Azure
42 A critical aspect of data aggregation is that it allows you to focus on
A.The important and most meaningful data
B.Disabling interactive analysis over big data
C.Larger cache size and decreased query performance
D.All of the above
43 Which of the following filters are not available in Power BI reports?
A.Drillthrough
B.Report level
C.Page type
D.Page level
44 What is a dashboard?
A.A canvas of report elements that can be built in Power BI Desktop
B.Dashboards can be built by using visuals that are developed with an underlying data source
C.A canvas of report elements that can be built in the Power BI service
D.The canvas in which you can view the data model of a report
45 Why are parameters important in Power BI paginated reports?
A.They are required so that Power BI can call the paginated report.
B.They allow the report developer to control the refresh interval of the report.
C.They allow the user to control aspects of how the report is rendered when the report is run.
D.None of the Above
46 What is the best description of a workspace?
"A.A workspace is a feature in the Power BI service that allows you to view reports only.
B.A workspace is a feature that allows you to view and edit the data model, build visualizations, and transform the data.
C.A workspace is a feature of Power BI Desktop that allows you to build only.
D.A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, etc."
47 Where are the dataset scheduled refreshes configured?
A.Power BI Desktop
B.Power BI Service
C.AppSource
D.DataSource
48 You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?
A.Viewer
B.Contributor
C.Member
D.Admin
49 You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?
A.Add a SQL statement
B.Set Data Connectivity mode to DirectQuery
C.Set the Command timeout in minutes setting
D.Set Data Connectivity mode to Import"
50 You build a report to help the sales team of techtrics to understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?
A.Key influences
B.Funnel chart
C.Q&A
D.Line and clustered column chart
