Module 5: Practice Exam

Contents hide

3 TROUBLESHOOTING DAX FORMULAS WITH BING COPILOT

4 LESSON QUIZ: MICROSOFT GENERATIVE AI FOR POWER BI

Spread the love

INTRODUCTION – Practice Exam

This module offers a wealth of resources specifically tailored to help you prepare for the Microsoft Exam PL-300: Microsoft Power BI Data Analyst certification. These resources include a mix of comprehensive tutorials, practice tests, and expert guidance, all designed to build your knowledge and practical skills essential for mastering the exam material. By engaging with these resources, you will be well-prepared to confidently approach the exam and achieve your certification goals.

Learning Objectives:

Prepare for the PL-300 practice exam.
Synthesize skills from all courses through the completion of the practice exam assessment.
Understand the functionalities and impact of Microsoft Copilot across industries, and how it enhances business decision-making.
Identify the challenges faced by data analysts and learn how Copilot can help address these issues, particularly in report creation when paired with Power BI.
Explore how Copilot can improve the layout and design of Power BI reports, while recognizing its limitations.
Learn to structure and troubleshoot complex DAX formulas with the assistance of Generative AI tools like Copilot.
Reflect on the course content and gain insights into the learning path ahead.

PL-300 MOCK EXAM

1. Multiple Microsoft Excel files are saved in a folder and synced with Microsoft’s OneDrive for Business. You need to import data from files without using the data gateway. Which type of Power BI data connector should you use?

OneDrive for business
SharePoint folder (CORRECT)
Excel workbook
SharePoint list

That’s correct! A SharePoint folder is the only connector that allows you to import multiple Excel files stored in a OneDrive for Business folder without using a data gateway.

2. You are importing your Power BI project data from a SQL Server database. Which Power BI desktop view can you use to change the storage mode of the tables?

Data view
Report view
Page view
Model view (CORRECT)

That’s correct! You need to navigate to the Model view of Power BI desktop and use the Properties pane to change the storage mode of tables.

3. Which tool should you use to create a custom connector to access data from a third-party API?

Power BI
Power Query (CORRECT)
Power Automate
Power Apps

That’s correct! You can use Power query to create and manage a custom connector to retrieve data from third-party API.

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?

Replace subqueries with nested queries.
Break down the SQL statement into separate data sources. (CORRECT)
Implement aggregations in SQL statement.
Implement groupings in SQL statement.

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. Your data model contains a sales table with an OrderDate column. You want to analyze and visualize the sales data grouped by month. What transformation command of the Power query editor lets you create a month column without using DAX expression?

Group By
Extract
Trim
Date (CORRECT)

That’s correct! From the Power query editor, you need to select the Date and choose Name of the month from the drop-down option. A new column with the month name is added to the table that you will use to visualize sales by month.

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?

Column profile
Show whitespaces
Column distribution
Column quality (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. 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?

Right inner join
Left inner join (CORRECT)
Left outer join
Right outer join

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. How can you filter rows in Power BI based on specified conditions during data transformation?

Utilize the Sort option.
Use Filter rows and specify the conditions. (CORRECT)
Apply the Exclude values transformation.
Apply the remove rows transformation operation.

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. 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?

Custom column (CORRECT)
Conditional split
Group by
Extract

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. You have an HR Power BI data model containing a fact table with information about employee performance reviews and dimension tables for employees and departments. What type of data is likely stored in the dimension tables?

Detailed performance review data
Aggregated metric for employee performance
Transactional data about employees
Descriptive information about employees and departments (CORRECT)

That’s correct! The dimension tables store descriptive information about employees and departments, providing context to the performance review data in the fact table.

11. Which Power BI interface do you need to use to identify the data anomalies present within your imported dataset from an Excel workbook?

The Model view of Power BI desktop.
The Power query editor (CORRECT)
The Data view of Power BI desktop.
Advanced editor of Power query editor.

That’s correct! The Power query editor displays the column distribution and column quality graphs where you can identify any anomaly present within the imported dataset.

12. In the Power query editor, the column statistics show a count of 1000 rows, but your query is retrieving data from a data source that contains 5000 rows. What should you do for the column statistics to show the statistics based on entire data rows?

Add a Table.Buffer applied step using M in the query.
Create a Top N row count parameter for the query.
Change the query load from Import to DirectQuery.
From the query window, select Column profiling on the entire dataset. (CORRECT)

That’s correct! Selecting the Column profiling for the entire dataset will change the column profiler to analyze the entire query dataset.

13. You connect the Power query editor to a database table. You need to remove the Row ID column. You need to make sure that the new columns do not display in the table model during a scheduled data refresh in the future. What transformation should you use?

Use the Transpose command, then filter the rows to remove Row ID.
Use the Remove Column command on the Row ID column.
Use the Select columns command to select the columns to keep. (CORRECT)
Select Row ID and use the Remove Other Columns command.

That’s correct! In the query editor, only the Select columns command lets you keep the columns, delete the columns you do not want, and prevent new columns from showing up in the table.

14. Which statement is true about reference queries in Power BI?

Reference queries enable faster data load.
Reference queries allow you to integrate data efficiently.
Reference queries allow you to combine tables with similar structures.
Reference queries allow you to reuse query logic and transformation. (CORRECT)

That’s 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. You have a Power BI data model containing two tables Sales and Employees. The tables are related via a one-to-many relationship based on the EmployeeID column. You want to analyze the sales performance for each employee. Which cross-filter direction will you choose?

None
Single (CORRECT)
Both

That’s correct! To analyze sales performance for each employee, you need to set a single cross-filter direction which ensures selecting an employee will filter the sales amount for that employee.

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?

Managing the relationship from the Manage relationship window
Using the CROSSFILTER function.
Using the USERRELATIONSHIP function. (CORRECT)
Using the KEEPFILTERS function.

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. 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?

=List.Dates(#date(2021,05,31), 365, #duration(1,0,1,0))
=List.Dates(#date(2021,05,31), 365, #duration(0,0,0,1))
=List.Dates(#date(2021,05,31), 1, #duration(1,0,0,0))
=List.Dates(#date(2021,05,31), 365, #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. In the model view of Power BI desktop, what are the categories to configure column properties?

General and Advanced.
Formatting and Advanced.
General, Formatting, and Advanced. (CORRECT)
General and Formatting.

That’s correct! In the model view of Power BI desktop, you can format and configure column properties based on three broad categories that are General, Formatting, and Advanced.

19. Which function allows you to know the username of the person who is signed into Power BI service?

LOOKUPVALUE( )
USERPRINCIPALNAME( ) (CORRECT)
USEROBJECTID( )

That’s correct! This function will tell you which user is online to view the report.

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?

CALCULATE and SUM
SUMX (CORRECT)
CALCULATE
SUM

That’s correct! SUMX will iterate each row of the table to compute the total sales by implementing the calculations of the measure.

21. Which of the following elements can you use to develop a quick measure in Power BI desktop? Select all that apply.

Fields (CORRECT)
DAX
Power query M functions
Calculations (CORRECT)
Conditional columns

That’s right! In Power BI Desktop, you can apply automatic calculations to fields without needing to write a DAX formula.

Exactly! When creating quick measures in Power BI Desktop, you can use predefined calculations from six different categories available for quick measures.

22. Profit margin is a non-additive measure, which DAX function should you use to handle this?

DIVIDE (CORRECT)
SUMX
FIRSTNONBLANK
AVERAGE

That’s correct! You can use the DIVIDE function to compute the profit margin of the company by implementing sales and profit measures.

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.

SAMEPERIODLASTMONTH
DATESBETWEEN (CORRECT)
DATESINPERIOD (CORRECT)
TOTALYTD

Exactly! You can define two time periods, one as the start and the other as the end, to calculate the hospital visits.

Correct! This function uses today’s date as a parameter. Then, you need to specify the number of intervals, which is 30 for the current measure.

24. You are working on a Power BI data model that contains three data tables. A Salestable containing sales transactions, a Date table, and a Producttable.You want to create a summary table to display the following:

The total sales by each product category per year.
Total quantity of each product within the category.

You have created the following DAX measure:

Annual Sales Summary =

ADDCOLUMNS (

SUMMARIZE ( Sales, Date.[Year], ‘Product'[Category] ),

“Total Quantity”, SUM ( Sales[Quantity] ) )

)

Which of the following DAX functions you should include in the DAX expression to compute accurate results?

CALCULATE (CORRECT)
FILTER
TOPN
CALCULATETABLE

That’s correct! You need to add CALCULATE before SUM to compute accurate results. Remember CALCULATE alters the filter context of the DAX calculations.

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.

True
False (CORRECT)

26. What Power BI feature can you use to store pre-aggregated data for improved query performance when working with DirectQuery sourced dataset?

DAX calculated columns
DAX calculated tables
Aggregated tables (CORRECT)
DAX measures

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. 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.

Create aggregations based on DirectQuerysourced tables. (CORRECT)
Query the original data source for all analytical requirements
Connect Power BI via DirectQuery mode. (CORRECT)
Import the data to Power BI memory.Reduce the data volume by importing only necessary columns. (CORRECT)

Exactly! Aggregating data on DirectQuery-sourced tables enhances query performance and efficiency.

Correct! By creating a DirectQuery connection, you can access real-time data from SQL Server.

That’s right! Importing only the necessary columns for analysis reduces the model size, thereby improving query performance.

28. Which of the following Data types offers an optimal performance for the currency field of your data model?

Text
Decimal number
Fixed decimal number (CORRECT)
Whole number

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. 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?

Waterfall chart (CORRECT)
Combo chart
Scatter plot
Funnel chart

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. What are the ways you can use Python in Power BI? Select all that apply.

To create a functional data model
To retrieve data from data sources (CORRECT)
To create custom visualizations (CORRECT)
To perform report optimization
To perform complex data transformations (CORRECT)

That’s correct! You can access data sources through Python scripting by using Python connector.

That’s correct! Python along with its rich visualization libraries like Matplotlib and Seaborn provides a way to create custom visualizations that are not available from the core Visualizations pane of Power BI.

That’s correct! You can perform complex data transformations using Python script from Power query editor.

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?

Create a color scheme in Power BI desktop and save it as a template for later use.
Save the color scheme as CSS and upload it to Power BI as a Customtheme.
Replace the report colors with the company’s color scheme from the Theme panel.
Save the color scheme as JSON (JavaScript Object Notation) and upload it to Power BI as a Custom theme (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. Which Power BI Map visuals allow you to create a geographical hierarchy in your report page? Select all that apply.

Filled map (CORRECT)
Heat maps
Azure maps (CORRECT)
Shape maps

That’s correct! You can create a geographical hierarchy by using a Filled map visual from the Power BI Visualizations pane.

That’s correct! Azure maps also let you create geo-hierarchy for your analytical work in Power BI desktop.

33. You are using Power BI desktop to configure a Stacked column chart that displays gross sales data with Date hierarchy. The hierarchy levels are Year, Quarter, Month, and Day. You need to prevent users from viewing the hierarchy based on the Year. What should you do?

In the Visualizations pane, remove the Year from the Date hierarchy field in the horizontal axis (CORRECT)
In the Format pane, modify the maximum range settings.
In the Filters pane, add a filter based on the Quarter, Month, and Day.
In the Filters pane, add a filter based on the Year.

That’s correct! To prevent users from viewing the hierarchy based on the Year, you remove just the Year from the Date hierarchy field in the X-axis from the Visualizations pane. The Quarter, Month, and Day fields remain populated and functional.

34. True or False: Power BI allows you to add visual elements and images to your report tooltip.

True (CORRECT)
False

That’s correct! Your report tooltip can contain visuals, images, and any other collection of items you create on the report page.

35. How is drill-through different from drill-down functionality in Power BI?

Drill-through provides a more detailed view while drill-down is used to expand hierarchies. (CORRECT)
A drill down and drill through can be used interchangeably.
A drill-down is used for visuals, while a drill-through is used for tabular data.
Drill-through is used to expand hierarchies while drill-down provides detailed navigation.

That’s correct! Drill-through allows you to navigate data points for a detailed and focused report page while drill-down is used to expand the visual hierarchy to see the granular details within the same visual.

36. True or False: When you create page navigation in Power BI desktop reports, you also need to manually sync the page navigator with your report pages?

True
False (CORRECT)

That’s correct! The Page navigator automatically syncs with all your report pages by matching the tiles and order of the report pages with the Buttons.

37. You have a Power BI dataset where each employee is reporting to multiple managers in the organizational hierarchy. How does a PATH function of DAX handle such a situation?

It chooses the shortest path for each employee.
It creates a separate path for each employee-manager relationship. (CORRECT)
The PATH function cannot handle multiple reporting relationships.
It concatenates all paths for each manager.

That’s correct! The PATH function creates a separate path for each employee-manager relationship in the parent-child hierarchy.

38. True or False: You have a Power BI report with a live connection. One of the managers of the company is more comfortable using Excel for analyzing data. Power BI allows you to utilize the Analyze in Excel feature with a live-data connection to export the refreshable data from Power BI to Microsoft Excel.

True (CORRECT)
False

That’s correct! You can export refreshable data with a live connection to the data source in the Excel workbook by selecting the Analyze in Excel feature of Power BI.

39. A Power BI desktop report needs to be optimized for cellular devices. Which Power BI component can you use to optimize the report for mobile devices? Select all that apply.

Power BI desktop (CORRECT)
Power BI report builder
Power BI mobile appPower BI service (CORRECT)

That’s correct! In Power BI Desktop, you can optimize reports for mobile viewing through the View tab, and the mobile icon in the bottom left corner of the interface helps guide you to mobile-specific settings.

That’s correct! In the Power BI service, you also have the ability to optimize reports for mobile devices, ensuring users can interact with the reports seamlessly across different platforms.

40. You have a Waterfall chart showing the increase and decrease of Sales by States in Power BI report in Power BI service and want to analyze the data using the Analyze feature of Power BI. You selected the first data point of the Waterfall chart and the Analyze option is not available in the context menu. What could be the probable reason?

The Waterfall chart does not support the Analyze feature.
The Analyze feature cannot be used for the first data point of the visual. (CORRECT)
The Analyze feature can only be used in Power BI desktop.

That’s correct! The insights obtained from the analyze feature of Power BI service are based on the change from the previous data point, so it cannot be used for the first data point of the visual.

41. You need to create a Histogram in your report that displays ranges of integers in groups. What resource do you need to create the Histogram? Select all that apply.

A List group type
A Bin group type (CORRECT)
A Date/time columnA numerical column (CORRECT)

That’s correct! The Bin group type is an auto-grouping of items into Bins (groups). It will display well as a Histogram.

That’s correct! The group is created against a numerical column using Bins.

42. In Power BI where can you find time series charts?

In the Filter pane of Power BI Desktop.
You need to import time series charts from AppSource. (CORRECT)
Time series charts are in the Visualizations pane.
The Fields pane contains the time series charts.

That’s correct! The core visualization pane does not have time series charts, you need to import them from AppSource.

43. You manage a Power BI workspace. You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege. Which role should you use?

Admin
Member (CORRECT)
Viewer
Contributor

44. Which of the following features are not supported in Power BI dashboards? Select all that apply.

Creation of multiple pages (CORRECT)
Use of slicers and filters (CORRECT)
Setup of data Alerts
Natural language queries

That’s correct! You cannot create multi-page dashboards in Power BI service.

That’s correct! You cannot filter or slice a dashboard. You can only use filters in focus mode but cannot save them.

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.

True (CORRECT)
False

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:

Paginated reports (CORRECT)
Dataflows (CORRECT)
Semantic models (Datasets) (CORRECT)
Workbooks

That’s correct! Sensitivity labels can be applied to paginated reports in Power BI service to ensure data protection and compliance.

That’s correct! Sensitivity labels are also supported in dataflows within Power BI service, helping to safeguard sensitive information.

That’s correct! Semantic models in Power BI service are capable of supporting sensitivity labels, allowing for secure data management and access control.

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

The system logs them out.
Their access level is automatically upgraded.
They see blank visuals. (CORRECT)

Correct! Due to row-level security settings, users see blank visuals when attempting to access data outside their assigned region.

24. What is the primary purpose of the USERPRINCIPALNAME function in Dynamic Row Level Security in Power BI?

Quick insights
Usage metrics report
Query cachingLineage view (CORRECT)

That’s correct! Lineage view in Power BI service allows you to view and troubleshoot the data flow from its source to destination.

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.

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. You have a Power BI data model that imports data from an on-premises SQL Server. You have implemented a scheduled refresh of the dataset. What happens to the Power BI report after each scheduled refresh? Select all that apply.

Query caches are refreshed
Schema refresh that is change in data source table structure is shown (CORRECT)
Report visuals are refreshed
Data is refreshed from the data source (CORRECT)Queries used to populate visuals are refreshed (CORRECT)

That’s correct! Any new column added, deleted, or renamed will be reflected in the schema after the scheduled refresh.

That’s correct! With each scheduled refresh, data is retrieved and updated from the data source to ensure the report is up to date.

That’s correct! The queries that you define to populate visuals in your report will be refreshed during the scheduled refresh process.

50. Which of the following security groups cannot add to row-level security in Power BI?

Mail-enabled group
Azure Active Directory Security Group
Microsoft 365 Group (CORRECT)
Distribution group

That’s correct! Microsoft 365 groups are not supported and cannot be added to any roles in row-level security.

51. You need to create a data source that can be used offline. Which type of data source should you use?

SharePoint
Microsoft OneDrive (CORRECT)
SQL Server
Common data services

That’s correct! OneDrive, a cloud-based service by Microsoft, allows users to store and access files from anywhere, even offline. OneDrive also can sync files between devices making it an ideal choice for creating an offline data source.

52. 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?

Change the data type of the logged column to Date. (CORRECT)
Apply transformation to extract the column’s first characters that only contain the date.
Split the logged column using ‘at’ as a delimiter.
You can use the same column as the date hierarchy.

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.

53. Your Power BI dataset has a table where each row represents a city, and there are columns for the population in different years like Population_2019, Population_2020, and so on. You want to display the data with a single column for the year and another column for the population. What transformation step can you achieve in Power BI?

Pivot column
Unpivot columns (CORRECT)
Merge queries
Split columns

That’s correct! Unpivot columns is the most suitable transformation operation in the query editor to convert multiple columns into rows, allowing you to reshape the data as per the requirements.

54. You want to make changes to your data sources. What are the changes you can apply to the data source from the Data source settings of the Power query editor? Select all that apply.

Adding a column
Renaming a column
Clearing permissions (CORRECT)
Modifying the file path (CORRECT)
Editing permissions (CORRECT)

That’s correct! You can clear permissions to the data source file from the data source settings in the query editor.

That’s correct! The data source settings allow you to modify the file path of the data source file if needed.

That’s correct! You can edit permissions from the data source settings in the query editor to manage access control.

55. You imported an Excel workbook in Power BI, and during import, you received the following message: “We could not find any data formatted as a table.” What should you do to resolve this error?

In Power BI, add a template app.
In Power BI, add an organizational app.
In the Excel workbook, select the data you want to import, select the Data validation button, and save the change.
In the Excel workbook, select the data you want to import, create a table, and save the changes. (CORRECT)

That’s correct! The error message indicates the Excel workbook does not contain a table. To create a table in the Excel workbook you can select the data you want to import and press “Ctrl + T or choose the Table button from the Insert ribbon of Excel and save the changes.

56. 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?

Group by column from the query editor.
Sort by column from the query editor.
Sort by column from the Power BI desktop. (CORRECT)
Group by column from the Power BI desktop.

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.

57. You developed a query in Power BI desktop that retrieves data from an Excel spreadsheet. During the data analysis, you identify the need to view and modify multiple steps of data transformation in the entire M code. Which Power BI interface allows you to accomplish that?

The Model view of Power BI desktop.
The Power query editor.
Advanced editor of Power query editor (CORRECT)
The Formula bar of the query editor.

That’s correct! The Advanced editor within the Power query editor provides the ability to view and modify the M script generated during the data transformation.

58. You want to create a common date table within your Power BI data model. The start and end of the date table must match the date range available in the fact table of the data model. How can you create this table?

Use CALENDARAUTO and specify the dates.
Use the CALENDAR function and specify the dates.
Use CALENDAR with MIN and MAX to specify the dates. (CORRECT)
Use CALENDARAUTO with MIN and MAX to specify the dates.

That’s correct! In the CALENDAR function, you can use MIN and MAX functions to extract the minimum and maximum dates from the fact table.

59. Which of the following Power BI components can you use to configure the column and table properties of your data model? Select all that apply.

Visualizations pane of Power BI desktop.
Advanced editor.
The Power query editor. (CORRECT)
The Model view of Power BI desktop. (CORRECT)

That’s correct! In Power BI Desktop, you can configure fundamental table and column properties in the query editor.

That’s correct! The Model view of Power BI Desktop provides more advanced options to configure and format the properties of tables and columns in greater detail.

60. Which of the following statements about Measures in Power BI is true? Select all that apply.

Measures can only be created using DAX in Power BI.
Measures are dynamic calculations that do not take space in the data model (CORRECT)
Measures can reference columns directly.
Measures can reference other measures during calculations. (CORRECT)

That’s correct! Unlike Calculated columns, measures do not take up space and compute the value on the fly.

That’s correct! You can reference previously computed measures to calculate the new measures.

61. 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.

Variables allow users to change the data source connection in the DAX measure.
Variables improve the overall performance of the resulting DAX measure. (CORRECT)
Variables improve the overall readability of the resulting DAX measure. (CORRECT)
Variables have additional functions that can be used in the DAX measure.

That’s correct! By using variables in DAX, you can improve performance and make your code more efficient by avoiding the repeated evaluation of the same expression.

That’s correct! Variables also contribute to better readability and maintainability of DAX code by allowing you to use shorter names for complex expressions.

62. You need to create aggregations to improve model performance of a DirectQuery sourced dataset in Power BI. Which Power BI component allows you to create aggregations?

Power BI desktop table view
Power query editor (CORRECT)
Power BI desktop model view
Power BI desktop report view

That’s correct! You can only create aggregations in the Power Query editor from a DirectQuery sourced dataset. Remember you need to manage the aggregations after you create them. You can manage aggregations in Power BI desktop model view.

63. True or False: You have imported a Power BI data model from a huge Excel spreadsheet. You need to create aggregations to improve model performance but creating and managing aggregations is limited to DirectQuery sourced datasets.

True
False (CORRECT)

That’s correct! You can create and manage aggregations for model optimization based on any dataset even if it is an Excel workbook.

64. You have developed a Power BI report for the sales team of your company. The salespeople are frequently interacting with the report and complain that the report elements are taking too long to display upon each interaction. You have recorded the report performance from the performance analyzer. How do the results assist you in improving the report’s performance?

The results recommend reducing the data size.
The results suggest you replace the visual elements.
The results show you the impact of user interaction on report elements so you can optimize. (CORRECT)
The results recommend the data fresh frequency.

That’s correct! The Performance analyzer captures the impact of user interaction with the report elements which helps you identify the issues and optimize accordingly.

65. You are creating a report to visualize sales by salespersons, trending over months. The visual must clearly show how salespersons are performing against each other and have a ranking for each period. Which visual from Power BI core visualization should you choose?

Clustered bar chart
Ribbon chart (CORRECT)
Treemap
Scatter plot

That’s correct! A Ribbon chart places the highest value at the top of the stacked column each month and shows those ranked changed over time, so it’s the best option to fulfill the requirements.

66. You developed a Table visual in a Power BI report and you want to highlight the valuable information about the profit margin in one of the columns of the table. You are asked to change the background color of the column displaying the red color if the profit margin is below a certain limit. How can you achieve this with minimal developmental efforts?

Format the background color from the Format visual of Power BI desktop
Change the background color with Conditional formatting (CORRECT)
Selectively change the background color from the Theme panel
Define DAX measures for various colors to display in the Table visual

That’s correct! In the Conditional formatting window, you can format the background color of the cells conditionally displaying red when the profit margin falls below a certain limit.

67. You are developing a Power BI desktop report to visualize the sales performance of salespeople. The sales team is comprised of over 20 salespeople. You also need to make sure the sales values are visualized monthly. What should you do?

Create a Column chart displaying Date hierarchy on the X-axis and create a Slicer drop-down for salespersons. (CORRECT)
Create a Bar chart displaying the salesperson on the Y-axis.
Create a Column chart displaying salespersons on the X-axis and create a Slicer for data hierarchy.
Create a Column chart displaying the month on the X-axis.

That’s correct! Creating a Date hierarchy on the horizontal axis makes it easier to drill down to visualize the granular sales values and the slicer drop-down will interactively display the sales performance for each salesperson eliminating the clutter from the report.

68. You are analyzing the sales of your company in a Power BI desktop report. You need to identify the types of data you will be able to use to create Bins that group sales data. Which Data types should you identify? Select all that apply.

Text
Binary
Boolean
Numeric (CORRECT)
Date/time (CORRECT)

That’s correct! The NumericData type is also used for grouping in Bins.

That’s correct! The date/time data type supports bin-based grouping.

69. In Power BI desktop, what types of fields can you use to create a data hierarchy enabling users to drill down to granular details of analysis?

Only numerical values
Hierarchies can only be created with Data/time data fields
Both categorical and numerical data fields can be used (CORRECT)
Only text-based data

That’s correct! To create a hierarchical structure and enable the drill-down function, you can use both numerical and categorical data fields in your visuals.

70. 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.

Set the button type to Bookmark and then use Conditional formatting to specify the destination.
Use Conditional formatting to set the Button text. (CORRECT)
Create a DAX measure that outputs the correct page name based on the value of [Delayed response]. (CORRECT)
Set the Button type to page navigation and then use Conditional formatting to specify the destination. (CORRECT)

That’s correct! Conditional formatting in Power BI can be used to dynamically change the button text based on the DAX measure you’ve created, ensuring the button’s label matches the page name.

That’s correct! The first step is creating a DAX measure that outputs the correct page name or any other dynamic text that you want to display on the button.

That’s correct! After creating the DAX measure, you can configure the button to navigate between pages, using the measure to drive the navigation logic.

71. You have a Power BI report displaying a Column chart of Sales on the Y-axis and Countries on the X-axis. When users hover the cursor on any data point the tooltip displays the sales values along with the name of the country. How can you display the sales breakdown by each category within the same country?

Add a separate visual displaying sales breakdown by product category.
Create a separate report page for each product category.
Add a Category slicer where users can select a category.
Add a visual for sales breakdown by category on a Tooltip. (CORRECT)

That’s correct! You can create a Custom tooltip with a visual showing a breakdown of sales by category for each country. When users hover the cursor on the data point, the Tooltip displays the sales breakdown by each category for that country.

72. 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?

Max line
Min line
Average line
Constant 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.

73. AI visuals are Power BI components designed to provide advanced analytics and insights by leveraging machine learning models and techniques. You are a sales manager of the company and want to analyze the revenue by region, category, and sales channel. Which of the following AI visuals is used to break down a specific value (revenue in this case) into its components?

Decomposition tree (CORRECT)
Waterfall chart
Q&A visual
Key influencer visual

That’s correct! With the Decomposition tree, AI visual of Power BI, you can break down a single value into its components like Sales revenue into regions, categories, and sales channels which can reveal the strengths and weaknesses of your business operation.

74. You manage a Power BI workspace. You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege. Which role should you use?

Allow contributors to update the app
Workspace OneDrive (CORRECT)
Develop a template app
License mode

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.

75. 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?

Import mode (CORRECT)
DirectQuery mode
Live Connection mode

76. You want to create Alerts to notify users if the data on the dashboard changes above or below a certain threshold. Which Power BI visual allows you to set and manage Alerts in Power BI service? Select all that apply:

Custom visuals
KPI (CORRECT)
Gauge (CORRECT)
Card visual (CORRECT)
Python visual

That’s correct! In Power BI service, you can set and manage Alerts for the KPI visual to track performance against specific targets.

That’s correct! Alerts can also be configured in the Gauge visual to notify users when certain thresholds are reached or exceeded.

That’s correct! The Card visual is another element in Power BI where you can set and manage Alerts, allowing you to track key metrics effectively.

77. True or False: You can only subscribe to external users to a Power BI report or dashboard if your report or dashboard is hosted in a Premium capacity.

True (CORRECT)
False

78. What is the primary advantage of deployment pipelines in Power BI?

Less manual work and fewer errors. (CORRECT)
Enhanced user access to BI report source data.
Reports can be published from multiple workspace environments.
Semantic model (dataset) creation is streamlined.

That’s correct! Implementation of deployment pipelines reduces manual work and errors.

79. Your company has a SharePoint server located in a data center in Toronto. You are creating a report in Power BI service that uses Microsoft Excel files stored on the SharePoint server. You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily. What should you include in the recommendation?

Azure Data box
A virtual private network (VPN)
An on-premises data gateway (CORRECT)

That’s correct! With an on-premises data gateway installed on your local machine, you can achieve daily refresh of the data regardless of where the data is hosted.

80. 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.

True (CORRECT)
False

81. Row-level security is commonly applied to which type of tables in Power BI?

Dimension tables
Fact tables
Lookup tables (CORRECT)
Data tables

That’s correct! Row-level security is typically applied to lookup tables in Power BI.

82. 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?

An Excel workbook
A Power BI dataset
A SharePoint folder (CORRECT)
Power BI dataflows

83. 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.

Import mode supports the Q&A feature. (CORRECT)
Import mode has minimal need for data refresh.
Importmode supports per-table configuration.
Import mode minimizes disk space usage.Import mode supports Quick insights. (CORRECT)

That’s correct! Import storage mode is fully supported with the Q&A feature in Power BI service.

84. What is the best way to organize related datasets?

Use naming conventions to identify datasets.
Use a separate workspace for each dataset.
Use folders to group related datasets. (CORRECT)
Use tags to categorize datasets.

That’s correct! A folder with related datasets is the best option to organize similar datasets that may resemble each other in structure and content.

85. How can you ensure data accuracy before analysis?

Using data profiling tools (CORRECT)
Use data modeling tools
Use data visualization tools
Use data transformation tools

That’s correct! Data profiling tools are designed to analyze and assess the data quality and help identify any data inconsistencies, errors, and missing data in the datasets.

86. Your data model contains a huge dataset that you want to reduce. Which Power BI interface can you use to reduce the data?

Power query editor. (CORRECT)
Data modeler.
Data view of Power BI desktop.
Advanced editor.

That’s correct! In the Power query editor, you can remove unnecessary columns and rows, duplicates, and enact other transformation steps to reduce the size and volume of the dataset before loading it to the Power BI model.

87. You have two Excel sheets with data from separate reporting units. Both spreadsheets contain the same column names and structure. What Power query editor feature will you use to create a unified dataset?

Merge
Group
Manage
Append (CORRECT)

That’s correct! Append queries allow you to combine two tables with similar column names and structures into a single unified data table.

88. 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?

Measure table
Fact table
Dimension table (CORRECT)
Look up table

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.

89. You have a dataset representing each month (January, February, March) as individual columns. What transformation in the query editor can you use to rearrange the data, making months appear as rows instead of columns?

Extract
Transpose (CORRECT)
Pivot
Reverse rows

That’s correct! The Transpose function in the query editor converts rows to columns and columns to rows.

90. Which Power BI component allows you to create and manage dataflows?

Power BI Service (CORRECT)
Power BI desktop interface
Power BI data modeler
Power query from Power BI desktop

That’s correct! You can only create and manage dataflows in the Power BI service and use them from Power BI desktop.

91. You have a Power BI data model that contains three data tables: Sales, Products, and Date. Both the Product and Date table are related to the Sales table via one-to-many relationships. You want to analyze products sold by year. What should you do to analyze annual product sales? Select all that apply.

Use USERRELATIONSHIP to handle the cross-filter direction. (CORRECT)
Set up a many-to-many relationship between the Date and the Sales tables.
Set up cross filter direction to Both between Date and Sales tables.
Set up a Both cross-filter direction between the Product and Sales tables. (CORRECT)
Set up a many-to-many relationship between the Product and the Sales tables.

That’s correct! The use of the USERRELATIONSHIP function while defining a DAX measure will not change the cross-filter direction for the entire data model and only temporarily switch the cross-filter direction for the calculations under consideration.

That’s correct! Changing the cross-filter direction between the Product and the Sales tables will display the correct sales amount for each product sold per year.

92. You imported a data model to Power BI. The mode does not have a date dimension table that is needed to create complex time intelligence calculations. Which of the following tools can you use to create a date dimension table? Select all that apply:

Python (CORRECT)
DAX in the query editor.
M language in the query editor. (CORRECT)
SQL
DAX in the Power BI desktop. (CORRECT)

That’s correct! You can use Python to create a date table and import it into your Power BI data model for more advanced date-related calculations.

That’s correct! In Power Query Editor, you can use M language to create a common date dimension, which helps in organizing and managing time-based data.

That’s correct! DAX, which is only available in Power BI Desktop, allows you to create a common date table to enhance your data model and improve date-related analysis.

93. What is the default summarization of a numerical column in Power BI?

SUM (CORRECT)
Average
Count
MIN

That’s correct! Power BI applies SUM summarization by default to each numeric column that you can change according to your analytical needs.

94. Which Power BI component lets you test the row-level security using different security roles?

Both Power BI desktop and Service. (CORRECT)
Power BI mobile app.
Power BI desktop.
Power BI service.

That’s correct! You can test row-level security in both Power BI Service and desktop.

95. You have a Power BI model where you need to decide when to use implicit measures over explicit measures. What is the feature of implicit measures that explicit measures do not have?

Implicit measures can be used as a drill-through field.
End users can change the aggregation type of implicit measures from the Values well of the visual. (CORRECT)
Implicit measures can be used with Field parameters.
Implicit measures can be used to create Quick measures.

That’s correct! In implicit measures, you can select one of the nine aggregations when placed in the Values well of the visual used. Therefore, users can alter the aggregation type according to their needs.

96. You have a warehouse Power BI data model that contains a table named Warehouse. The table has a column named Inventory count, which contains the current number of items for each row of a particular product type on a given day.The model has a DAX measure that calculates the sum of all values in the Inventory count column of the Warehouse table:

Current Inventory =

CALCULATE ( SUM ( ‘Warehouse’[Inventory Count] ) )

You must ensure that Current Inventory returns only the current total number of inventory items, rather than the sum of all inventory items.

What additional DAX function should you include in the query?

LASTDATE (CORRECT)
CALENDAR
CALENDARAUTO
DISTINCTCOUNT

That’s correct! The LASTDATE function ensures that the SUM function applies only to the last date of the period resulting in a semi-additive behavior.

97. True or False: You cannot create quick measures in Power BI service because only Power BI desktop supports the creation of quick measures.

True (CORRECT)
False

That’s correct! Power BI service does not support the creation of quick measures. You need to go back to Power BI desktop to create a quick measure for your analysis.

98. You have imported a large data model to Power BI desktop, and you want to reduce the model size. Which technique should you use to reduce the model size

Configure the Query reduction option filter settings.
Set the storage mode property of tables to import.
Set the storage mode property of tables to DirectQuery. (CORRECT)
Configure the Query reduction option Slicer settings.

That’s correct! Setting the storage mode property to DirectQuery reduces the model size since only the schema of the data is stored locally to Power BI memory.

99. You are planning to create a report in Power BI desktop to visualize the relationship between the number of orders received and the number of orders shipped by product category. You must identify the visual that will clearly identify the outliers in the dataset by displaying them away from the cluster of data. Which visual should you choose?

Scatter plot (CORRECT)
Gauge
Treemap
Card

That’s correct! A Scatter plot displays a relationship between values associated with two axes: one set of numerical data along a horizontal axis and another set of numerical data along the vertical axis. It displays outliers away from the bulk of the data.

100. 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?

Card visual
A Waterfall chart
A Scatter plot (CORRECT)
A KPI

That’s correct! A Scatter plot is the first step of applying the clustering technique that groups data into clusters.

101. Power BI desktop supports many accessibility tools. Which keyboard keys let you access the accessibility features?

Tab
Alt + A
Alt (CORRECT)
Tab + A

That’s correct! The Alt key displays the Keytips over each command in the current view of the Ribbon with a letter displayed on each tab which lets you navigate various tools via accessibility.

102. A fundamental principle of data storytelling is a cohesive report page and visuals should be placed in a logical order. Which Power BI element allows you to visualize the order of visuals in the report page and configure them according to the narrative of your data story?

Visualizations pane of Power BI desktop.
Selection pane from the query editor.
Page navigator from Power BI desktop.
Selection pane from Power BI desktop. (CORRECT)

That’s correct! The Selection pane of Power BI desktop enlists all the visuals present in the report canvas, where you can simply re-arrange the visuals by dragging and dropping them in an order that complements your data story.

103. How can you group layers of visual elements in your Power BI desktop report? Select all that apply.

Select all visuals to be grouped, navigate to the Format ribbon, and select Group. (CORRECT)
Drag and drop the visual elements.
Select all visuals to be grouped, right-click on any visual, and select Group from the context menu. (CORRECT)
Right-click on any visual and select Group from the context menu

That’s correct! You can also navigate to the Format ribbon and select Groupafter selecting the multiple visuals from the report canvas.

That’s correct! You need to select multiple visuals to be grouped by holding the Ctrl key and selecting Group from the context menu.

104. 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?

Power BI Desktop
Power BI report builder
Power BI mobile app
Power BI service (CORRECT)

That’s correct! You can only create and configure dashboards in Power BI service therefore mobile optimization can only be done in Power BI service.

105. 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.

True
False (CORRECT)

106. 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?

Contributor role
Admin role
Member role
Viewer role (CORRECT)

That’s correct! The Viewer role only has reader access to view reports and dashboards, and you need to select this one.

107. You are applying sensitivity labels to your Power BI reports, which of the following are sensitivity labels in Power BI? Select all that apply.

Certified
Highly confidential (CORRECT)
Personal (CORRECT)Confidential (CORRECT)

That’s correct! Highly confidential is a sensitivity label used for Power BI reports.

That’s correct! Personal is a sensitivity label used for Power BI reports.

That’s correct! Confidential is a sensitivity label used for Power BI reports.

108. You have developed a query named Customers in Power BI desktop to append the rows from three external tables having customer data into a single customer table. You want to ensure each row in the new customer table has a unique ID value. What is the best way to add an ID column to the customer table?

Modify the data model by adding a counter column.
Change the data model by extending the Customers table with a counter column.
Change the data model by extending the Customers table with an index column.
Modify the data model by adding an index column. (CORRECT)

You can modify the model by adding an index column from the Power query editor. The index column will assign a unique ID to each customer row.

109. You have accessed the data from a SQL Server as DirectQuery. The dataset contains millions of rows. The objective of the analysis is to group data by year and region. Creating aggregated tables has the capacity to reduce the dataset sourced through DirectQuery. Which Power BI element allows you to create aggregations?

Power query editor (CORRECT)
Data view of Power BI desktop
Model view of Power BI desktop
Page view of Power BI desktop

110. What happens when you make changes to the source query of a referenced query in Power BI?

The reference queries do not change.
The changes are automatically applied to all referencing queries (CORRECT)
The changes only affect the current report.
The referencing queries become read-only.

111. A manufacturing company data model contains a Machine dimension table related to the fact table. The team wants to analyze machine performance based on the installation date and maintenance date. How can you implement the role-playing dimension?

Import two separate datasets for maintenance and installation.
Use a single-machine table and create multiple relationships for installation and maintenance. (CORRECT)
Create two separate Machine dimension tables for installation and maintenance.
Use Calculated columns to distinguish between installation and maintenance dates.

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.

112. You have implemented role-based security that restricts access to a Power BI desktop dataset for users who are assigned the role named Salespersons. You need to validate that the implementation works properly. What should you do?

In Power query editor, add a conditional column to the Salesperson table.
In the Report view, activate the view as a feature. (CORRECT)
In the Report view, add a DAX expression filter to the Salesperson table.
In the Report view, create a what-if parameter.

113. You have a Power BI model of a marketing company. The data model contains two tables: Socials and Calendar. The Socials table has a column recording website visits and the Calendar table has a Date column. You want to compute the total number of visits during the last month. Which DAX expression can you use to compute this value?

= CALCULATE ( Socials[Website Visits] ), LASTMONTH ( Calendar[Date] )
= CALCULATE ( SUM ( Socials[Website Visits] ), LASTMONTH ( Calendar[Date] ) )
= CALCULATE ( Socials[Website Visits] ), PREVIOUSMONTH ( Calendar[Date] )
= CALCULATE ( SUM ( Socials[Website Visits] ), PREVIOUSMONTH ( Calendar[Date] ) ) (CORRECT)

That’s correct! CALCULATE and SUM computes the total number of website visits and PREVIOUSMONTH compares the dates to the previous month.

114. A Power BI data model has measures and calculated columns. What is the benefit of using measures over calculated columns?

Measures can be used for data transformation operations.
Measures can be used in the calculated columns to create complex calculations.
Measures are dynamic calculations and are not stored in the data model. (CORRECT)
Measures can assist in data load operations.

That’s correct! Measures are calculated at the query level, so they do not require memory. The calculations are executed on the fly.

115. What are the potential performance benefits of removing unnecessary columns from the data model? Select all that apply.

Increasing the refresh speed. (CORRECT)
Increasing DAX performance.
Decreasing report page load times.
Reducing the size of data model. (CORRECT)

That’s correct! Fewer columns mean reducing the data model size and it takes less time to refresh the model.

That’s correct! Fewer columns mean there is less data to import therefore reducing the model size.

116. You have a Power BI data model with a bunch of complex DAX measures. The report is responding very slowly. You need to optimize the report performance for which you want to know the performance of DAX measures. Which Power BI tool can you use to inspect the performance of DAX calculations?

Visualizationpane.
Power query profiling tool.
Performance analyzer. (CORRECT)
Power BI data Modeler.

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.

117. Your task is to edit a Power BI report by adjusting the behavior of report interactions. What type of interaction behavior can you change between visuals? Select all that apply.

Expand
Highlight (CORRECT)
Drill through
Filter (CORRECT)

That’s correct! Highlight is the default interaction between the visual which shows you both unfiltered and filtered values in the visual.

That’s correct! A Filter changes the behavior by showing you the filtered data in the visual.

118. In Power BI you can add symmetry shading along with x- and y-axis Constant lines to which of the following visuals?

Area chart
Scatter chart (CORRECT)
Line chart
Waterfall chart

119. What features can you configure in the Q&A feature of Power BI desktop? Select all that apply.

Review Questions (CORRECT)
Synonyms (CORRECT)
Visual formatting
ModelingRelationships (CORRECT)

That’s correct! By reviewing the questions users have asked, you can identify misunderstandings and clarify them to improve the overall user experience.

That’s correct! Adding synonyms for fields in your datasets helps Power BI Q&A recognize different terms users might use when asking questions, making it easier to interact with your data.

That’s correct! Defining relationships between tables and fields ensures that Power BI Q&A can understand the connections in your data and provide more accurate answers to user queries.

120. Anomaly detection is a powerful feature of Power BI where you can detect anomalies within your time series data. Which of the following features are not supported by anomaly detection? Select all that apply.

You cannot use drill down with anomaly detection. (CORRECT)
DirectQuery connectivity is not supported. (CORRECT)
Line charts are not supported.
Live connection to the dataset is not supported. (CORRECT)

That’s correct! Drilling down to a granular level with a hierarchical structure is not supported in anomaly detection in Power BI.

That’s correct! Anomaly detection cannot be used if the Power BI model is connected to a DirectQuery-sourced dataset.

That’s correct! Power BI’s anomaly detection feature does not support a Live connection to the dataset.

121. True or False: Only Power BI administrators can promote content in Power BI service.

True
False (CORRECT)

That’s correct! Any content owner or user with the Write permission can promote the content in Power BI Service.

122. You have an Azure SQL database that contains sales transactions. The database is updated frequently. You are asked to create a report from the data to detect fraudulent transactions. The data must be visible within five minutes of any update. How will you configure the data connection?

By adding a SQL statement.
By setting data connectivity to DirectQuery. (CORRECT)
By setting data connectivity to import mode.
By setting a command timeout in minutes.

That’s correct! With DirectQuery, you can ensure the data is refreshed within the required time frequency. Your reports will be automatically updated as the new data is updated to the source database.

123. You have a Power BI model with the following fact tables and corresponding storage modes:

FactStoreSales (Import mode)
FactInternetSales (DirectQuery mode)

The model contains a dimension table named DimDate that has a relationship to both fact tables of the data model. To combine data from the dimension table and the fact tables by minimizing the query execution time, which storage mode should you choose for the DimDate dimension table?

Dual (CORRECT)
DirectQuery
Import
None

That’s correct! Selecting a Dual storage mode ensures either an Import query can be executed when accessing data from the FactStoreSales fact table and a DirectQuery can also be executed when accessing data from the FactInternetSales table.

124. 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?

Merge the tables using full outer join kind based on the SalesOrderID.
Merge the tables using left outer join kind based on the SalesOrderID. (CORRECT)
Append the tables.
Merge the tables using inner join based on the SalesOrderID.

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

125. You have a Power BI desktop model that contains a Sales fact table and Product dimension table. You want to compute the total sales by product category by implementing the condition: “Only products that have a total sale of over $20K should be displayed.” What combination of DAX functions should you use to compute the measure?

FILTER and SUM.
FILTER and CALCULATE. (CORRECT)
SUM and CALCULATE.
FILTER and SUMX.

That’s correct! The FILTER function narrows down the sales values for the product according to the defined criteria and CALCULATE modifies the filter context to compute the final measure.

126. You have a warehouse Power BI data model that contains a table named Warehouse. The table has a column named Inventory count, which contains the current number of items for each row of a particular product type on a given day.

The model has a DAX measure that calculates the sum of all values in the Inventory count column of the Warehouse table:

Current Inventory =

CALCULATE ( SUM ( ‘Warehouse'[Inventory Count] ) )

You must ensure that the Current Inventory returns only the current total number of inventory items, rather than the sum of all inventory items. You also need to make sure the state holidays and weekends should be excluded from the calculation. What additional DAX function should you include in the query?

CALENDARAUTO
DISTINCTCOUNT
LASTDATE
LASTNONBLANK (CORRECT)

127. You have created a data model in Power BI desktop that contains DAX-calculated columns and measures. You want to create a report from the model. Where can you use DAX-calculated columns, without being able to use measures? Select all that apply.

As an item in the Fields well of a slicer. (CORRECT)
As a filter in the Filters on this Page well of the Filters pane. (CORRECT)
As an item in the Add drill-through fields here well of the Visualizationpane.
As a filter in the Filters on this visual well of the Filters pane.

That’s correct! Unlike measures, calculated columns can be used in the slicer to place filter options on the report page.

That’s correct! DAX measures cannot be placed in the Filters on this page well of the report.

128. You have developed a CustomTheme in Power BI desktop and created reports based on this theme. When you publish your reports to Power BI service and create dashboards out of the reports, will Power BI service alter the theme and adapt your reports to the dashboard default theme?

True
False (CORRECT)

That’s correct! You can keep the original theme of your reports and its visual elements while publishing and creating dashboards in Power BI service.

129. You have a Power BI report that uses a dataset imported from the database. The report contains a Slicer that you need to sync so that it can be used on other report pages. What is required to sync the slicers between report pages?

Each Slicer must be the same slicer type.
Each Slicer must have the same title.
Each Slicer must use the same column (CORRECT)
Each Slicer must be visible.

That’s correct! The same column must be used to create a Slicer for them to recognize each other in sync slicer settings.

130. When might you choose to use a Paginated report over an interactive report in Power BI?

When you need to print the report in tabular format (CORRECT)
For real-time data analysis.
When designing for mobile devices.
For ad-hoc queries.

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.

131. You have created a Bookmark for your Power BI report. After creating a Bookmark, you added a new page to your report and reordered the pages. What should you do to update the Bookmark?

You don’t need any formatting because any additional page and reorder of pages automatically synced with the Bookmark. (CORRECT)
You need to update the order of buttons in Bookmark, but the new page was automatically added to Bookmark.
Navigate to the format Bookmark and update the settings.
You need to add the new page to the Bookmark manually, but the order of pages automatically syncs with the Bookmark.

132. You are working on a Power BI report that contains multiple Slicers. A new user of the report might not be able to visualize the entire data because of the active selection of Slicers. What should you do to enhance the user experience?

Add a Bookmark
Duplicate the report page and remove the Slicers from the duplicated page
Add a Button to clear all the Slicers (CORRECT)

That’s correct! You can add a Button to the report page to clear all Slicers from the report which will enhance the user experience.

133. 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?

You cannot analyze data in Excel as summarization with a live connection.
Five hundred thousand (CORRECT)
The same as the source dataset.
Three hundred thousand

That’s correct! Power BI allows you to analyze in Excel with summarization for a maximum of five hundred thousand rows.

134. Which content type can be endorsed in Power BI? Select all that apply.

Reports (CORRECT)
Semantic model (CORRECT)
Excel workbook
Dataflows (CORRECT)
Live streaming dataset

That’s correct! Power BI also supports the endorsement of Power BI reports.

That’s correct! You can endorse (promote or certify) a semantic model in Power BI.

That’s correct! Dataflows can also be endorsed (promoted or certified) in Power BI.

135. One of your columns in the data model contains information about the mailing address’s city, state, and postal code. You must separate the fields to access the geospatial elements for map visualization. What transformation should you apply?

Replace values
Modify data type
Split column (CORRECT)
Modify data category

That’s correct! You can split the column based on the delimiter present in the original column and use the resulting columns for geospatial visualization.

136. Which of the following DAX functions can be used as filter modification functions within CALCULATE? Select all that apply.

CROSSFILTER (CORRECT)
FILTERS
KEEPFILTERS (CORRECT)
EARLIERUSERRELATIONSHIP (CORRECT)

That’s correct! The KEEPFILTERS function modifies the filter direction and can also be used to disable the filter direction between tables. It must be used within the CALCULATE function.

That’s correct! KEEPFILTERS adds a filter without removing the existing filter when used within CALCULATE.

That’s correct! The KEEPFILTERS function engages the inactive relationship between two related tables in the data model and must be used within the CALCULATE function when defining a DAX measure.

137. You have a Power BI data model from which you need to create reports and dashboards. In which scenario do you need a dashboard for a report in Power BI?

You need to add filters.
You need to display visuals that use different datasets. (CORRECT)
You need to display visuals from multiple pages.
You need to add slicers.

That’s correct! Power BI dashboards can combine data from multiple datasets and do not support reports.

138. Which of the following statements regarding publishing reports from Power BI desktop to Power BI service is true?

Only reports are published to Power BI service.
Both reports and datasets are published to Power BI service. (CORRECT)
Only datasets are published to Power BI service.

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.

139. You are setting a data gateway for your organization, and you need to decide between a personal and enterprise gateway. What factors influence your decision?

Both gateways provide the same features
The physical location of the data centers
The type of data sources, for example, SQL and SharePoint
The number of users and the need for centralized management (CORRECT)

That’s correct! The enterprise data gateway supports multi-user scenario and is useful for centralized management therefore personal data gateway should not be opted.

140. Which Power BI refresh options require you to set parameters?

Incremental refresh (CORRECT)
On-demand refresh
Scheduled refresh

That’s correct! In incremental refresh you need to ensure the dataset is partially refreshed according to the parameters you must define.

141. You need to create a data source that external users can access. Which type of data source should you use?

Common data services (CORRECT)
OneDrive
SharePoint
SQL Server

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.

142. You have a Power BI file that imports several tables from Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the Power BI file. The solution must minimize the administrative efforts. What should you do?

Create new queries from the Power query editor.
Create a Power BI file, open the file, and change the data source when prompted.
Modify the source of each query in the Power query editor.
Modify the data source settings. (CORRECT)

That’s correct! You need to modify the data source settings to change the connection before creating reports in Power BI.

143. 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?

Duplicate query from the query editor.
Duplicate the data model.
Reference query from the query editor (CORRECT)
Duplicate and save Power BI file with a different name.

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.

144. 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?

Create a separate report for each employee-manager relationship.
Utilize the PATH DAX function to handle the organizational hierarchy. (CORRECT)
Implement only the most important employee-manager relationship in your report.
Utilize the PATHLENGTH DAX function to handle the organizational hierarchy.

TROUBLESHOOTING DAX FORMULAS WITH BING COPILOT

1. What was the primary benefit of using Microsoft Copilot in Bing for troubleshooting DAX formulas in Power BI?

To provide insights on data trends
To quickly identify and correct errors (CORRECT)
To increase the scalability of DAX formulas across multiple reports
To automate report generation

That’s correct. Microsoft Copilot accelerates the troubleshooting process by quickly identifying errors and suggesting corrections for DAX formulas. This tool utilizes AI capabilities to enhance the accuracy and efficiency of DAX formulas in Power BI.

2. What step did you take first when using Copilot in Bing to troubleshoot the CALCULATE formula?

Adjust the report’s parameters to match expected outcomes
Cross-verify the formula with similar ones used in other reports
Copy the formula to be refined (CORRECT)
Update the dataset to ensure data integrity

That’s correct. The first step in troubleshooting with Copilot was to ensure you’re working with the accurate version of the formula. Copying the CALCULATE formula allows for a precise review and adjustment process.

3. What actions did you perform after receiving the revised CALCULATE formula from Microsoft Copilot? Select all that apply.

Apply the updated formula to the SalesCalculation column. (CORRECT)
Implement filters to the dataset to enhance the formula’s performance.
Prompt with a follow-up question about the cause of the issue. (CORRECT)
Archive the previous version of the report as a backup.

That’s correct. Applying the revised formula to your report is crucial to directly test the modifications in the operational environment and assess their impact on the dataset.

That’s correct. Asking Copilot follow-up questions to uncover the root cause of the error and learn best practices for formula construction helps improve your understanding and problem-solving skills for future tasks.

LESSON QUIZ: MICROSOFT GENERATIVE AI FOR POWER BI

1. You’re a data analyst at Adventure Works, tasked with crafting an engaging report theme for the product team introducing a new line of eco-friendly products. The campaign’s success hinges on connecting emotionally with consumers and conveying sustainability efforts. Which mode of Microsoft Copilot is best suited for this?

Creative mode (CORRECT)
Manual mode
Precise mode
Balanced mode

That’s correct. Creative mode is tailored for creative tasks like composing engaging narratives, where innovation and flair are essential. It enhances responses with stylistic elements like wordplay, making it ideal for tasks requiring a high degree of creativity.

2. During a routine review of your Power BI dashboards at Adventure Works, you encounter several errors in DAX that are causing discrepancies in sales data visualization. How can Copilot assist when errors occur in DAX formulas?

By rewriting queries to reduce the need for data analysis.
By increasing the computing resources allocated to DAX formulas.
By providing explanations and recommendations on formulas. (CORRECT)
By reducing the need for complex DAX formulas in reports.

That’s correct. When DAX formulas result in errors, Copilot utilizes its NLP capabilities to provide clear explanations and propose corrections. This helps understand the root causes of errors and learn how to avoid similar issues in the future.

3. As the lead data analyst at Adventure Works, you are overseeing the integration of Microsoft Copilot into your development process. While Copilot provides innovation, you maintain a critical role. Why is human oversight important when using AI tools like Copilot for report development? Select all that apply.

To ensure recommendations align with industry standards. (CORRECT)
To reduce the impact of AI on business-critical processes.
To correct inaccuracies in AI-generated content. (CORRECT)
To streamline the frequency of reporting within the organization.

That’s correct. Human judgment is essential for interpreting and applying AI-generated insights accurately, especially in complex scenarios like report development, ensuring that the insights align with organizational goals and industry standards.

That’s correct. Human oversight is crucial for identifying and correcting any inaccuracies or misinterpretations in AI-generated content, ensuring the data in the report correctly reflects the intended message.

4. You’re refining a financial model in Power BI at Adventure Works, and you’ve used Microsoft Copilot to suggest enhancements based on the initial data inputs. While the suggestions are helpful, they aren’t perfect. What purpose does asking detailed follow-up questions serve after receiving suggestions from Copilot? Select all that apply.

To tailor the suggestions more closely to the specific report needs.
To minimize the need for manual adjustments later. (CORRECT)
To simplify processing and improve the quality of the conversation.
To facilitate a faster revision cycle for the report. (CORRECT)

That’s correct. Detailed questions can help refine the suggestions so that fewer manual adjustments are necessary later on by ensuring they are precisely what is needed.

That’s correct. Asking detailed questions helps tailor Copilot’s suggestions to your report’s specific needs and context, enhancing its advice’s relevance and applicability.

5. In your role as a data analyst, while revising a complex DAX formula for calculating bonus payouts based on multiple performance metrics and thresholds, you encounter several deeply nested IF statements. A key challenge of using deeply nested IF statements in DAX is __________.

Incompatibility with other DAX functions.
Difficulty in managing and troubleshooting due to complexity. (CORRECT)
Increased processing time for simple calculations.
Limitation in the number of conditions that can be checked.

That’s correct. Deeply nested IF statements are well-known for their intricacy, which can make managing and troubleshooting these formulas a daunting task. The complexity of multiple nested conditions can lead to errors that are hard to detect and resolve.

6. You are a data analyst at an e-commerce company that’s exploring the integration of generative AI to personalize shopping experiences. In discussions with the IT department, you are tasked with assessing risks related to deploying this technology. What are the primary concerns associated with Generative AI? Select all that apply.

Displacement of jobs. (CORRECT)
Ethical considerations and data privacy. (CORRECT)
Over-reliance on traditional computing methods.
Increased manual interventions and reduced output.

That’s correct. Generative AI presents challenges related to job displacement, particularly as automation takes over tasks that were previously performed by humans, leading to concerns about unemployment in certain industries.

That’s correct. Ethical concerns surrounding Generative AI include issues of data privacy and the potential for creating misleading or harmful content. These concerns highlight the need for strong governance and regulatory frameworks to ensure responsible use of AI technologies.

7. As a data analyst at a tech startup, you are researching different AI models to recommend for a new project. Generative Adversarial Networks (GAN) have emerged as a promising option. What is the primary role of Generative Adversarial Networks (GANs) in generative AI?

To simulate interactions and enhance encryption techniques.
To generate highly realistic outputs through neural networks. (CORRECT)
To automate decision-making processes.
To improve interfaces and optimize content dynamically.

That’s correct. GANs consist of a generator and a discriminator working together to create outputs that are convincingly realistic, making them highly valuable in tasks requiring detailed image or content generation.

8. As a data analyst for a healthcare analytics firm, you’re evaluating the implementation of neural networks to analyze complex medical data. What is the primary function of Neural Networks (NN) in artificial intelligence?

To minimize the need for data preprocessing.
To recognize patterns and interpret data. (CORRECT)
To provide real-time analytics and operate autonomously.
To generate data indistinguishable from real data.

That’s correct. Neural networks are designed to process input data through interconnected nodes, effectively recognizing patterns and interpreting complex data structures.

9. As a data analyst in a creative agency, you’re assisting the marketing team in exploring the use of generative AI to design unique advertising content. The team wants a model that can independently create innovative designs without explicit instructions. Which machine learning approach allows Generative AI to create content without predefined labels?

Reinforcement learning
Unsupervised learning (CORRECT)
Decision trees
Supervised learning

That’s correct. Unsupervised learning involves models learning from unlabeled data, allowing them to discover patterns and relationships independently, which is crucial for innovative content generation.

10. As a data analyst at a financial institution, you are leading a project to implement AI-driven decision-making tools. What are the reasons for rigorous testing and auditing of AI systems in organizations? Select all that apply.

To enhance the speed of AI systems
To reduce the complexity of AI models
To protect data privacy (CORRECT)
To identify and correct biases (CORRECT)

That’s correct. Rigorous testing and auditing are critical for ensuring that AI systems adhere to privacy standards and protect sensitive information.

That’s correct. Rigorous testing and auditing are essential to ensure AI systems operate fairly and do not perpetuate or amplify biases.

11. True or False: If the initial color palette generated by Microsoft Copilot for a new marketing report at Adventure Works does not fully capture the vibrant, earthy tones envisioned for the brand’s sustainability theme, you should modify the prompt to include specific color requirements.

True (CORRECT)
False

That’s correct. Modifying your prompt to specify additional needs is recommended if the initial color palette generated by Copilot does not meet your requirements. This allows for a more tailored output that aligns with specific branding.

12. You are a data analyst at Adventure Works tasked with creating a detailed performance dashboard using Power BI. In your report, you extensively use the CALCULATE function to adjust sales data based on various time periods and product categories. What common issues may arise when using the CALCULATE function in DAX? Select all that apply.

Inability to handle null values effectively.
Syntax errors leading to failure in executing the formula. (CORRECT)
Skewed analysis due to improper filter context settings. (CORRECT)
Conflicts with calculated columns and integrating with external sources.

That’s correct. CALCULATE is a highly versatile DAX function that can modify the context of data calculations, but it must be used with precise syntax. Any errors in syntax can cause the function to fail entirely, making it essential to carefully structure the formula.

That’s correct. CALCULATE adjusts the filter context for calculations, so if the filter context is set incorrectly, it can lead to inaccurate or misleading results. Properly defining and managing the context is key to ensuring the desired outcome in your calculations.

13. As a data analyst at a digital marketing firm, you’ve been assigned to evaluate the impact of generative AI on various sectors. During your research, you notice a significant surge in AI-driven artistic tools. Which sector is experiencing a renaissance due to Generative AI’s ability to participate in processes?

Healthcare
Transportation
Real estate
Creative (CORRECT)

That’s correct. The creative industries are undergoing a transformation due to Generative AI, which enhances the production of art, music, and literature. This allows for new forms of expression and collaboration.

14. As a data analyst at a manufacturing company, you’ve been involved in discussions about integrating generative AI into the production process. Why is understanding the technical foundations of generative AI important for businesses? Select all that apply.

To enhance productivity and customer engagement. (CORRECT)
To ensure compliance with international data standards.
To leverage it for optimal decision-making. (CORRECT)
To develop new software products and improve training.

That’s correct. A deep understanding of generative AI’s technical aspects enables businesses to harness its full potential, leading to improved operational efficiency, better customer engagement, and stronger business outcomes.

That’s correct. By leveraging insights into generative AI, businesses can optimize their decision-making processes, automate complex tasks, and enhance their overall effectiveness in achieving strategic goals.

15. In your role as a data analyst at a tech startup, working alongside data scientists to develop a model for generating realistic digital images for a virtual reality platform, it’s essential to understand the composition of a generative adversarial network (GAN). A GAN is composed of __________.

Creating more complex user interfaces.
Reducing the cost of AI technologies.
Decreasing the volume of data AI requires.
Integrating AI with existing IT systems. (CORRECT)

That’s correct. Technical challenges, such as integrating AI with existing IT infrastructure, are significant hurdles in AI implementation.

16. You work as a data analyst for a healthcare provider looking to combine generative AI into its diagnostic systems. What is the primary challenge in implementing generative AI in the workplace?

Compliance
Operational (CORRECT)
Technical (CORRECT)
Managerial (CORRECT)

17. As a data analyst, you are preparing a presentation for stakeholders about upcoming strategic initiatives. The presentation must be informative yet engaging, blending detailed data with narratives about company growth. Which Microsoft Copilot mode is designed to weigh detailed expressiveness with succinct responses?

Manual mode
Balanced mode
Creative mode (CORRECT)
Precise mode

That’s correct. Balanced mode perfectly balances Creative Mode’s creative flair and Precise Mode’s straightforwardness. It is designed to deliver accurate and informative responses yet contains a creative twist.

19. At Adventure Works, you’re optimizing a large financial model that relies heavily on the FILTER function to generate customized financial reports. The model processes data from over a million transactions, applying criteria to segment and analyze trends. Why is the FILTER function considered computationally expensive in DAX?

To provide real-time data updates on DAX errors.
To enhance the efficiency of report generation. (CORRECT)
To assist in troubleshooting DAX formulas. (CORRECT)
To autonomously manage data storage in reports.

That’s correct. Copilot enhances report generation by assisting in troubleshooting DAX formulas and suggesting report layout improvements, making the workflow more efficient and elevating the quality of reports.

That’s correct. One key benefit of integrating Copilot is its ability to assist in troubleshooting complex DAX formulas. Copilot helps ensure that data analysis is accurate and efficient by interpreting and correcting errors in these formulas.

19. At Adventure Works, you’re optimizing a large financial model that relies heavily on the FILTER function to generate customized financial reports. The model processes data from over a million transactions, applying criteria to segment and analyze trends. Why is the FILTER function considered computationally expensive in DAX?

It has a high error rate when used with IF statements.
It only operates on numerical data.
It iteratively examines each row in a dataset. (CORRECT)
It requires high memory usage to store data.

That’s correct. The FILTER function in DAX is known for its row-iterative nature, which means it processes each row individually. This can be time-consuming and resource-intensive when working with large datasets.

20. You’re a data analyst at a multinational corporation that is incorporating AI into its customer service operations. The project involves analyzing and implementing transformer models to improve response times. What are the unique characteristics of the transformer models in natural language processing? Select all that apply.

They rely on traditional recurrence methods.
They process words sequentially.
They utilize a self-attention mechanisms. (CORRECT)
They process all words in parallel, regardless of position. (CORRECT)

That’s correct. One feature of transformers is the self-attention mechanism, which assesses the importance of each word in the context of all other words in a sentence.

That’s correct. Transformers handle words in parallel, significantly improving efficiency and contextual understanding over longer text spans.

21. You are a data analyst at a recruitment firm that is considering using generative AI to enhance candidate screening processes. What is a primary ethical concern when deploying generative AI in the workplace?

Reduced software quality outputs
Reduction in operational costs
Bias in AI-generated content (CORRECT)
Decrease in employee satisfaction

That’s correct. Since AI models learn from the data they are trained on, they can inherit biases present in these datasets, leading to potential discriminatory practices.

22. Imagine you are a data analyst at Adventure Works, building a Power BI report for quarterly financial projections. While reviewing the projections, you realize that the existing data contains subtle errors that could impact the overall results. Considering the scenario, what purpose is Precise mode particularly essential for in Microsoft Copilot? Select all that apply.

For troubleshooting complex formulas. (CORRECT)
For providing brief, straightforward responses. (CORRECT)
For generating creative marketing content.
For designing graphics that enable visual appeal.

That’s correct. Precise mode effectively addresses technical queries involving complex formulas, where precision and conciseness are key. This mode provides accurate responses that help to quickly understand the issue and apply the best techniques to solve it.

That’s correct. Precise mode is crucial for scenarios where clarity and accuracy are paramount, making it ideal for technical or data-heavy inquiries. This mode ensures that responses are concise, focusing solely on the essential information.

23. As a senior data analyst at Adventure Works, you are guiding your team in using Microsoft Copilot to improve Power BI reports. What is a key factor for effective Copilot recommendations for the enhancements of Power BI report?

The processing capabilities of the user’s computer
The quality and specificity of the user inputs (CORRECT)
The number of reports uploaded to Copilot for analysis
The complexity of the data within the Power BI report

That’s correct. The effectiveness of Copilot’s recommendations heavily relies on how specific and detailed the user inputs are. Vague or incomplete prompts may lead to less useful guidance.

24. You are a data analyst for a tech consultancy firm that advises businesses on emerging technologies. Recently, clients have been growing increasingly interested in understanding how generative AI will impact the industry. What is an important future implication of Generative AI for the workforce?

Reduced workplace diversity.
Increasing demand for AI literacy. (CORRECT)
Decreased need for technical skills.
Increased job specialization.

That’s correct. The evolution of Generative AI technologies makes AI literacy an essential skill in the workforce. Understanding and collaborating with AI will be crucial as AI becomes more integrated into various industries.

25. As a data analyst at an AI research lab, reviewing various machine learning models for a study on natural language processing, it’s crucial to identify which model is specifically recognized for its use of multiple layers to learn from large amounts of unstructured data. This model is known as __________.

Deep Learning (DL) (CORRECT)
Linear Regression
Support Vector Machines (SVM)
Decision Trees

That’s correct. Deep learning uses multiple layers in its neural networks to learn complex patterns in large datasets of unstructured data.

26. You’re a data analyst at a news media company that is evaluating the use of generative AI for content creation. What challenge is associated with the deployment of Generative AI technologies? Select all that apply.

Biases in training data (CORRECT)
High costs of data acquisition
Potential for AI-generated misinformation (CORRECT)
Insufficient computing power

That’s correct. The presence of biases in the training data used for Generative AI can lead to discrimination and perpetuation of stereotypes, posing ethical and operational challenges.

That’s correct. A significant challenge with Generative AI is its potential to generate and spread misinformation, which can have far-reaching consequences on public opinion and democratic processes.

27. True or False: When encountering errors in DAX formulas during a routine review of Power BI dashboards at Adventure Works, Microsoft Copilot can assist by providing explanations and recommendations on formulas.

True (CORRECT)
False

28. As a lead data analyst at Adventure Works, you are managing a team that increasingly relies on artificial intelligence (AI) tools like Microsoft Copilot for daily operations. What is a potential risk associated with an over-reliance on AI tools like Microsoft Copilot?

Increase in complexity of IT infrastructure.
Decline of manual skill sets. (CORRECT)
Higher operational costs.
Reduces the ability for quick decision-making.

That’s correct. Over-reliance on AI tools can lead to a decline in manual skills as dependency on these technologies grows. Such dependency can become problematic during outages or when AI tools are unavailable.

29. As a data analyst at a content creation company, you’re tasked with implementing a new tool that utilizes generative AI to produce written content. The company is particularly interested in the AI’s ability to mimic various writing styles to suit different client needs. Which feature of generative AI enhances its capability to mimic specific styles?

Its feedback loop mechanisms and adaptive learning.
Its integration with real-time data processing.
Its use of transformer-based models. (CORRECT)
Its reliance on large-scale data storage systems.

That’s correct. Transformer-based models use attention mechanisms and are especially adept at generating stylistically coherent text adapted to specific contexts. This makes them ideal for mimicking writing styles.

CONCLUSION – Practice Exam

In conclusion, this module provides a comprehensive set of resources designed to support your preparation for the Microsoft Exam PL-300: Microsoft Power BI Data Analyst. By utilizing the in-depth tutorials, practice tests, and expert insights offered, you will be thoroughly equipped to approach the exam with confidence and successfully achieve your certification goals.