1.
Question 1
For the sales department of your organization, you publish a report that imports data from Microsoft Excel located in a Microsoft SharePoint folder. The data model contains several DAX measures. You must create a Power BI report from the existing data with minimal development efforts. Which type of data source should you use?
1 / 1 point
An Excel workbook
A Power BI dataset
Power BI dataflows
A SharePoint folder
Correct
That’s correct! You must select the SharePoint folder from the Get Data and paste the SharePoint site URL where the data is hosted.
2.
Question 2
You need to create a data source that external users can access. Which type of data source should you use?
1 / 1 point
SQL Server
SharePoint
OneDrive
Common data services
Correct
That’s correct! Common data services allow users to securely store and manage data from various sources, including Office 365 and custom applications. It is a suitable option for creating data sources that external users can access because it provides a secure and scalable platform for managing data.
3.
Question 3
You need to decide between DirectQuery mode and Import mode for your dataset’s import mode. What are the benefits of Import storage mode versus DirectQuery storage mode? Select all that apply.
1 / 1 point
Import mode supports Quick insights.
Correct
That’s correct! You can use Quick insights from Power BI service with Import storage mode.
Import mode supports the Q&A feature.
Correct
That’s correct! Import storage mode is fully supported with the Q&A feature in Power BI service.
Importmode supports per-table configuration.
Import mode has minimal need for data refresh.
Import mode minimizes disk space usage.
4.
Question 4
You have created a Power BI data source that uses SQL SELECT statements. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. When you import the data to Power BI, you receive the error message “Timeout expired”. You have checked the SQL connection and confirmed the Server has sufficient bandwidth and low latency. To minimize the timeout occurrence issue, what should you do?
1 / 1 point
Break down the SQL statement into separate data sources.
Implement aggregations in SQL statement.
Implement groupings in SQL statement.
Replace subqueries with nested queries.
Correct
That’s correct! Dividing the SQL statement into separate data source would minimize the amount of processing on SQL Server side. This would minimize or even eliminate the timeout issues.
5.
Question 5
You have a CSV file that contains user complaints. The table contains a column called Logged, which has data and the time of each complaint. The data is logged in the following format: 2022-12-21 at 08:35. You want to analyze the complaints by the logged date and utilize Power BI’s built-in date hierarchy. What should you do?
1 / 1 point
Apply transformation to extract the column's first characters that only contain the date.
You can use the same column as the date hierarchy.
Change the data type of the logged column to Date.
Split the logged column using ‘at’ as a delimiter.
Correct
That’s correct! Changing the data type of the logged column to Date allows you to utilize a built-in date hierarchy to analyze complaints by time and use drill-down functionality to display granular details.
6.
Question 6
For a query append in the query editor, you want to know the percentage of empty cells in each column. Which of the data preview options should you select?
1 / 1 point
Column profile
Column distribution
Column quality
Show whitespaces
Correct
That’s correct! Column quality is the data preview option that shows the percentage of data containing errors, empty cells, and valid data.
7.
Question 7
You want to merge two queries in the Power query editor where you want to keep the entire data from the first table while only matching rows from the second table. Which type of join should you choose?
1 / 1 point
Right outer join
Right inner join
Left inner join
Left outer join
Correct
That’s correct! Left inner join lets you keep all rows from the first table and only match rows from the second table while using merge queries in the query editor.
8.
Question 8
How can you filter rows in Power BI based on specified conditions during data transformation?
1 / 1 point
Apply the remove rows transformation operation.
Apply the Exclude values transformation.
Use Filter rows and specify the conditions.
Utilize the Sort option.
Correct
That’s correct! In the power query editor, you can use Filter rows and define the conditions to filter rows based on your required conditions.
9.
Question 9
You want to add a new column to the Power BI table that categorizes customers as high value if their total sales are above $10,000. Which transformation in the query editor allows you to create such a column without using the DAX expression?
1 / 1 point
Group by
Custom column
Conditional split
Extract
Correct
That’s correct! In the query editor, you can add a custom column and define the conditions for the column based on the sales values for each customer.
10.
Question 10
You are designing a data model for hospital emergency visits. You want to capture patient information like name, address, insurance details, email, and phone number. Which type of table should you store this information?
1 / 1 point
Fact table
Look up table
Dimension table
Measure table
Correct
That’s correct! The information about the patients is descriptive in nature therefore should be stored in the dimension table that will provide context for the fact table of the data model.
11.
Question 11
You have a Power BI report displaying a column chart of monthly sales. In the column chart, the months are displayed alphabetically. Which transformation step should you apply to visualize sales data by month in the correct chronological order?
1 / 1 point
Group by column from the query editor.
Sort by column from the Power BI desktop.
Group by column from the Power BI desktop.
Sort by column from the query editor.
Correct
That’s correct! You need to sort the month column by the month number to visualize sales data by month in the correct chronological order.
12.
Question 12
True or False: In the context of data profiling, Unique values and Distinct values represent the same information.
1 / 1 point
True
False
Correct
That’s correct! Distinct means a total number of different values regardless of how many times they appear in the dataset. A name that appears multiple times in the list is counted as 1 distinct count. Whereas the Unique values are the total number of values that only appear once.
13.
Question 13
You are importing data from a SQL Server database that contains two tables named SalesOrderDetails (left table) and SalesOrders (right table). You load both tables to Power BI desktop and the tables have a relationship based on theSalesOrderID column. You need to combine two tables into one and you must meet the following requirements:
There is a row for every SalesOrderDetails row in the resulting table, even if there is no corresponding SalesOrder row.
For every SalesOrderDetails row, the row in the resulting table includes the corresponding SalesOrder row data if the SalesOrder exists.
Any SalesOrder row data that does not have a corresponding SalesOrderDetailsrow is not included in the resulting table.
What should you do to combine the tables?
1 / 1 point
Merge the tables using left outer join kind based on the SalesOrderID.
Merge the tables using full outer join kind based on the SalesOrderID.
Merge the tables using inner join based on the SalesOrderID.
Append the tables.
Correct
That’s correct! To meet the requirements, the resulting table must contain all the rows from the SalesOrderDetails table with only matching rows from the SalesOrder table. This can be achieved by using a left outer join type while merging the tables.
14.
Question 14
You have a Power BI project with a large dataset. You have applied an extensive set of transformation operations to the dataset for analysis and visualization. You need to duplicate the data table for some additional analytical tasks. What transformation can you do to avoid repeating the transformation steps you already performed on the query?
1 / 1 point
Reference query from the query editor
Duplicate and save Power BI file with a different name.
Duplicate query from the query editor.
Duplicate the data model.
Correct
In reference query you can use an existing query in another query. All changes made to the primary query are automatically applied to the referenced query ensuring data consistency and avoiding the repetition of data transformation steps.
15.
Question 15
You have a Power BI project containing two data tables. The tables are related via many-to-many relationships. How many possible cross-filter directions could exist between the tables?
1 / 1 point
2
4
1
3
Correct
That’s correct! In many-to-many relationships, there could be three possibilities of cross-filter direction: Single where table a filters table b, Single where table b filters table a, and both.
16.
Question 16
You have a Power BI data model where the fact table is related to the Calendar table via multiple inactive relationships based on OrderDate, DeliveryDate, and ShipDate. How can you use the inactive relationship while defining DAX measures?
1 / 1 point
Using the KEEPFILTERS function.
Managing the relationship from the Manage relationship window
Using the USERRELATIONSHIP function.
Using the CROSSFILTER function.
Correct
That’s correct! The USERRELATIONSHIP function allows you to utilize the inactive relationship between two tables by overriding the active relationship for the current measure.
17.
Question 17
You want to create a date table starting from May 31, 2021, and ending one year later. What M code will you use to create this table?
1 / 1 point
=List.Dates(#date(2021,05,31), 365, #duration(0,0,0,1))
=List.Dates(#date(2021,05,31), 365, #duration(1,0,1,0))
=List.Dates(#date(2021,05,31), 365, #duration(1,0,0,0))
=List.Dates(#date(2021,05,31), 1, #duration(1,0,0,0))
Correct
That’s correct! The #date designates the starting date, 365 designates the duration and #duration(1,0,0,0) designates the duration interval in days. Therefore, the formula results in listing days starting on May 31, 2021 and ending 365 days later.
18.
Question 18
In the model view of Power BI desktop, what are the categories to configure column properties?
0 / 1 point
General, Formatting, and Advanced.
General and Formatting.
General and Advanced.
Formatting and Advanced.
Incorrect
Not quite. Please review the activity Configuring the table and column properties.
19.
Question 19
Which Power BI component lets you test the row-level security using different security roles?
0 / 1 point
Power BI desktop.
Both Power BI desktop and Service.
Power BI service.
Power BI mobile app.
Incorrect
Not quite. Please review the video Dynamic row-level security with DAX.
20.
Question 20
You have a Power BI data model containing a Sales table. The Sales table has Quantity and Unit price columns. You want to create a Total sales measure instead of a calculated column by optimizing the data model for storage. Which aggregation function will you use to compute the measure?
1 / 1 point
SUM
CALCULATE
CALCULATE and SUM
SUMX
Correct
That’s correct! SUMX will iterate each row of the table to compute the total sales by implementing the calculations of the measure.
21.
Question 21
You are working on a complex data model that requires various DAX measures to define a range of business metrics. You decided to use variables while creating DAX formulas. What are the benefits of using variables in DAX expressions over using original expressions? Select all that apply.
1 / 1 point
Variables have additional functions that can be used in the DAX measure.
Variables allow users to change the data source connection in the DAX measure.
Variables improve the overall performance of the resulting DAX measure.
Correct
That’s correct! If an expression is used multiple times within the same DAX code, instead of writing it each time, a variable improves the performance by caching the defined calculation.
Variables improve the overall readability of the resulting DAX measure.
Correct
That’s correct! Variable names are often shorter than the original expressions and used multiple times within the same DAX script therefore they improve the readability of the expression.
22.
Question 22
Profit margin is a non-additive measure, which DAX function should you use to handle this?
0 / 1 point
SUMX
DIVIDE
AVERAGE
FIRSTNONBLANK
Incorrect
Not quite. Please review the video Additive, semi-additive and non-additive measures.
23.
Question 23
You have a hospital emergency Power BI data model, and you want to know the emergency visits for the last 30 days. Which of the two DAX functions can you use to compute this measure? Select all that apply.
1 / 1 point
DATESBETWEEN
Correct
That’s correct! You can define the two time periods as the start and the end to compute the hospital visits.
SAMEPERIODLASTMONTH
TOTALYTD
DATESINPERIOD
Correct
That’s correct! This function takes today's date as a parameter. You then need to define the number of intervals which is 30 for the current measure.
24.
Question 24
True or False: You cannot create quick measures in Power BI service because only Power BI desktop supports the creation of quick measures.
0 / 1 point
True
False
Incorrect
Not quite. Please review the video Creatingquick measures.
25.
Question 25
True or False: You have imported a data model to Power BI desktop. You need to create a number of time intelligence calculations using DAX. The data model does not have a dedicated date table. To create the time intelligence measures, the first step is to create a common date table within your data model.
0 / 1 point
True
False
Incorrect
Not quite. Please review the video Using DAX summarization over time and Using DAX comparison over time.
26.
Question 26
What Power BI feature can you use to store pre-aggregated data for improved query performance when working with DirectQuery sourced dataset?
1 / 1 point
DAX calculated columns
Aggregated tables
DAX measures
DAX calculated tables
Correct
That’s correct! You need to create aggregated tables when working with DirectQuery connectivity to store pre-calculated data which enhances the query performance.
27.
Question 27
You are working on an on-premises SQL Server dataset to develop a real-time analytical solution. In addition to providing real-time analysis, you need to optimize the query performance. What actions should you take to optimize the query performance? Select all that apply.
0 / 1 point
Reduce the data volume by importing only necessary columns.
Correct
That’s correct! Reducing the data by importing only the columns needed for analysis will reduce the model size thereby improving the query performance.
Query the original data source for all analytical requirements
Import the data to Power BI memory.
This should not be selected
Not quite. Please review the video Behavior and limitations of DirectQuery and Optimizing DirectQuery performance.
Connect Power BI via DirectQuery mode.
Create aggregations based on DirectQuerysourced tables.
Correct
That’s correct! Aggregations on the DirectQuerysourced tables improve the performance and efficiency of query.
28.
Question 28
Which of the following Data types offers an optimal performance for the currency field of your data model?
1 / 1 point
Fixed decimal number
Decimal number
Text
Whole number
Correct
That’s correct! In the performance analyzer, you can inspect the execution time of each DAX measure which helps you to identify the slow performing measures and optimize them.
29.
Question 29
You need to visualize the running total of a company by fulfilling the following criteria.
The initial and final value columns must start on the horizontal axis.
The intermediate values must be floating columns.
Which type of visualization should you choose?
1 / 1 point
Waterfall chart
Combo chart
Funnel chart
Scatter plot
Correct
That’s correct! A Waterfall visualization is a chart that displays the running total, with the initial and final value columns starting on the horizontal axis and the intermediate values are floating columns.
30.
Question 30
You need to create a Power BI report visualizing the sales data of a company so that customers of similar age will be grouped together. Which type of visual should you use from the visualization pane of Power BI desktop?
1 / 1 point
Card visual
A KPI
A Scatter plot
A Waterfall chart
Correct
That’s correct! A Scatter plot is the first step of applying the clustering technique that groups data into clusters.
31.
Question 31
Your company provides you with a color scheme that they want to use throughout their reporting and analysis. How can you implement the color scheme into your Power BI workflow?
1 / 1 point
Save the color scheme as JSON (JavaScript Object Notation) and upload it to Power BI as a Custom theme
Save the color scheme as CSS and upload it to Power BI as a Customtheme.
Create a color scheme in Power BI desktop and save it as a template for later use.
Replace the report colors with the company’s color scheme from the Theme panel.
Correct
That’s correct! You can create custom themes in Power BI based on any color combinations. You need to save the file in JSON format before you can upload it to Power BI desktop.
32.
Question 32
Which Power BI Map visuals allow you to create a geographical hierarchy in your report page? Select all that apply.
1 / 1 point
Filled map
Correct
That’s correct! You can create a geographical hierarchy by using a Filled map visual from the Power BI Visualizations pane.
Shape maps
Azure maps
Correct
That’s correct! Azure maps also let you create geo-hierarchy for your analytical work in Power BI desktop.
Heat maps
33.
Question 33
When might you choose to use a Paginated report over an interactive report in Power BI?
1 / 1 point
When you need to print the report in tabular format
When designing for mobile devices.
For ad-hoc queries.
For real-time data analysis.
Correct
That’s correct! The major advantage of paginated reports is you can print all the data in a table, no matter how long it is.
34.
Question 34
True or False: Power BI allows you to add visual elements and images to your report tooltip.
0 / 1 point
True
False
Incorrect
Not quite. Please review the reading Activity: Create custom tooltips.
35.
Question 35
How is drill-through different from drill-down functionality in Power BI?
0 / 1 point
A drill-down is used for visuals, while a drill-through is used for tabular data.
Drill-through provides a more detailed view while drill-down is used to expand hierarchies.
Drill-through is used to expand hierarchies while drill-down provides detailed navigation.
A drill down and drill through can be used interchangeably.
Incorrect
Not quite. Please review the video Cross filter and cross highlight.
36.
Question 36
You have a Power BI desktop report containing three pages: Main, Delayed Response, and On-time Response. You have added a Button to the Main page for navigation.
You need to implement a solution that meets the following criteria:
The navigation destination must change based on the output of a DAX measure name [Delayed Response].
If [Delayed Response] is greater than 5%, the Button must display the text “Delayed Response” and navigate to the Delayed Response page.
Otherwise, the Button displays the text “On-time Response” and navigates to the On-time Response page.
What actions should you perform? Select all that apply.
1 / 1 point
Use Conditional formatting to set the Button text.
Correct
That’s correct! To change the Button text to match the page name, conditional formatting must be used to set the text to equal the newly created DAX measure.
Create a DAX measure that outputs the correct page name based on the value of [Delayed response].
Correct
That’s correct! First, you need to create a DAX measure that outputs the correct destination page name.
Set the Button type to page navigation and then use Conditional formatting to specify the destination.
Correct
That’s correct! Then you need to configure the Button to use page navigation and use the newly created DAX measure to specify the navigation.
Set the button type to Bookmark and then use Conditional formatting to specify the destination.
37.
Question 37
You have a Power BI dataset where each employee is reporting to multiple managers in the organizational hierarchy. How can you handle such a situation?
1 / 1 point
Implement only the most important employee-manager relationship in your report.
Utilize the PATH DAX function to handle the organizational hierarchy.
Utilize the PATHLENGTH DAX function to handle the organizational hierarchy.
Create a separate report for each employee-manager relationship.
Correct
That’s correct! You can use the PATH function to handle parent-child hierarchy which creates a separate path for each employee-manager relationship.
38.
Question 38
The Analyze in Excel feature allows you to summarize data in Excel with a live connection. What is the maximum row limit of summarized data with a live connection?
1 / 1 point
Three hundred thousand
The same as the source dataset.
Five hundred thousand
You cannot analyze data in Excel as summarization with a live connection.
Correct
That’s correct! Power BI allows you to analyze in Excel with summarization for a maximum of five hundred thousand rows.
39.
Question 39
A Power BI dashboard needs to be optimized for cellular devices. Which Power BI component can you use to optimize the report for mobile devices?
0 / 1 point
Power BI mobile app
Power BI Desktop
Power BI report builder
Power BI service
Incorrect
Not quite. Please review video Optimizing report layout for mobile.
40.
Question 40
You need to add an analytical line to a visual within your report. The value for the line must be equal to the result of a DAX measure that always returns a consistent single value. The DAX measure must only be used to populate the analytics line. Which type of analytics line should you use?
1 / 1 point
Max line
Average line
Constant line
Min line
Correct
That’s correct! Either the x- or y-axis Constant line allows a DAX measure to be used to provide the value for the visual that you can use for the current visual to fulfill the requirements.
41.
Question 41
True or False: In Power BI desktop, you can convert a Q&A visual to a fully formatted visual element to display on your report canvas.
0 / 1 point
True
False
Incorrect
Not quite. Please review the readings Activity: Add the Q&A feature to a dashboard and Activity: Using the Q&A feature for reports.
42.
Question 42
In Power BI where can you find time series charts?
0 / 1 point
You need to import time series charts from AppSource.
The Fields pane contains the time series charts.
Time series charts are in the Visualizations pane.
In the Filter pane of Power BI Desktop.
Incorrect
Not quite. Please review the reading Activity: using the Play axis visualization.
43.
Question 43
You need to assign an app workspace role to users who consume reports. Users should only have permission to examine the report. Which role should you assign to users?
0 / 1 point
Admin role
Contributor role
Viewer role
Member role
Incorrect
Not quite. Please review the video Workspaces and workspace roles.
44.
Question 44
You are creating a workspace in Power BI service. You must ensure you can configure a Microsoft 365 group whose SharePoint online document library is available to workspace users after it is created. Which setting should you configure when creating a workspace?
1 / 1 point
Develop a template app
License mode
Workspace OneDrive
Allow contributors to update the app
Correct
That’s correct! Workspace OneDrive settings allow you to configure the Microsoft 365 group whose SharePoint Online document library is available to workspace users once you have created the workspace.
45.
Question 45
True or False: You have a Power BI dashboard where you added a Custom tile. The Tile is taking data from a Live-streaming dataset. Power BI does not allow you to set and manage Alerts on the live-streaming dataset dashboard tiles.
0 / 1 point
True
False
Incorrect
Not quite. Please review the video Subscriptions and data alerts.
46.
Question 46
Sensitivity labels are a way to classify critical content and protect your sensitive data without losing productivity. Which of the following components can you apply Sensitivity labels to in Power BI Service? Select all that apply:
1 / 1 point
Dataflows
Correct
That’s correct! Dataflows support the use of sensitivity labels in Power Bi service.
Paginated reports
Correct
That’s correct! Paginated reports support the use of sensitivity labels in Power Bi service.
Workbooks
Semantic models (Datasets)
Correct
That’s correct! Semantic models support the use of sensitivity labels in Power Bi service.
47.
Question 47
Which of the following statements regarding publishing reports from Power BI desktop to Power BI service is true?
1 / 1 point
Only datasets are published to Power BI service.
Only reports are published to Power BI service.
Both reports and datasets are published to Power BI service.
Correct
That’s correct! When you publish a report from Power BI desktop to Power BI service, both reports and underlying datasets are published to Power BI service.
48.
Question 48
You are creating and managing dataflows for your organization. The company’s data is hosted in on-premises SQL Server.
True or False: To create the dataflows, you do not need to install and configure data gateways.
1 / 1 point
True
False
Correct
That’s correct! To create dataflows in Power BI service, you must install and configure data gateway to retrieve data from on-premises SQL server to the dataflows.
49.
Question 49
You have applied changes in the data source structure including renaming, remove, and add columns.
True or False: The refresh can only be applied to Power BI desktop.
1 / 1 point
True
False
Correct
That’s correct! If you delete, add, or rename a column in the table structure of schema, the changes only can be applied to Power BI desktop upon data refresh.
50.
Question 50
Which of the following security groups cannot add to row-level security in Power BI?
0 / 1 point
Azure Active Directory Security Group
Distribution group
Mail-enabled group
Microsoft 365 Group
Incorrect
Not quite. Please review the video Row level security.
0 comments:
Post a Comment