microsoft pl 300 mock exam answers

PL-300 Mock Exam

1. For the sales department of your organization, you publish a report that imports data from Microsoft Excel located in a Microsoft SharePoint folder. The data model contains several DAX measures. You must create a Power BI report from the existing data with minimal development efforts. Which type of data source should you use?

  • A Power BI dataset
  • A SharePoint folder
  • Power BI dataflows
  • An Excel workbook

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
  • Model view
  • Page view
  • Report view

3. You need to decide between DirectQuery mode and Import mode for your dataset’s import mode. What are the benefits of Import storage mode versus DirectQuery storage mode? Select all that apply.

  • Import mode supports the Q&A feature.

  • Import mode supports Quick insights.

  • Import mode has minimal need for data refresh.
  • Import mode minimizes disk space usage.
  • Importmode supports per-table configuration.

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?

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

5. You have a CSV file that contains user complaints. The table contains a column called Logged, which has data and the time of each complaint. The data is logged in the following format: 2022-12-21 at 08:35. You want to analyze the complaints by the logged date and utilize Power BI’s built-in date hierarchy. What should you do?

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

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 quality
  • Column distribution
  • Column profile
  • Show whitespaces

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

  • 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 a counter column.
  • Modify the data model by adding an index column.

8. How can you filter rows in Power BI based on specified conditions during data transformation?

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

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

  • Clearing permissions
  • Adding a column
  • Renaming a column
  • Editing permissions
  • Modifying the file path

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
  • Transactional data about employees
  • Aggregated metric for employee performance
  • Descriptive information about employees and departments

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

  • Pivot
  • Transpose
  • Reverse rows
  • Extract

12. 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 Power query editor.
  • Advanced editor of Power query editor
  • The Model view of Power BI desktop.
  • The Formula bar of the query editor.

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?

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

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

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

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?

  • Both
  • None
  • Single

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?

  • Using the USERRELATIONSHIP function.
  • Using the CROSSFILTER function.
  • Using the KEEPFILTERS function.
  • Managing the relationship from the Manage relationship window

17. 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 the CALENDAR function and specify the dates.
  • Use CALENDAR with MIN and MAX to specify the dates.
  • Use CALENDARAUTO and specify the dates.
  • Use CALENDARAUTO with MIN and MAX to specify the dates.

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

  • Advanced editor.
  • The Model view of Power BI desktop.
  • Visualizations pane of Power BI desktop.
  • The Power query editor.

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

  • USERPRINCIPALNAME( )
  • LOOKUPVALUE( )
  • USEROBJECTID( )

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?

  • SUM
  • CALCULATE
  • SUMX
  • CALCULATE and SUM

21. You are working on a complex data model that requires various DAX measures to define a range of business metrics. You decided to use variables while creating DAX formulas. What are the benefits of using variables in DAX expressions over using original expressions? Select all that apply.

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

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

  • FIRSTNONBLANK
  • AVERAGE
  • SUMX
  • DIVIDE

23. 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 ( SUM ( Socials[Website Visits] ), PREVIOUSMONTH ( Calendar[Date] ) )
  • = CALCULATE ( Socials[Website Visits] ), PREVIOUSMONTH ( Calendar[Date] )
  • = CALCULATE ( SUM ( Socials[Website Visits] ), LASTMONTH ( Calendar[Date] ) )
  • = CALCULATE ( Socials[Website Visits] ), LASTMONTH ( Calendar[Date] )

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

  • True
  • False

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

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

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

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

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

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

28. 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 show you the impact of user interaction on report elements so you can optimize.
  • The results recommend reducing the data size.
  • The results suggest you replace the visual elements.
  • The results recommend the data fresh frequency.

29. 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
  • Treemap
  • Ribbon chart
  • Scatter plot

30. What are the ways you can use Python in Power BI? Select all that apply.

  • To perform complex data transformations
  • to perform report optimization
  • To create a functional data model
  • To retrieve data from data sources
  • To create custom visualizations

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?

  • Replace the report colors with the company’s color scheme from the Theme panel.
  • 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.
  • Save the color scheme as JSON (JavaScript Object Notation) and upload it to Power BI as a Custom theme

32. Which Power BI Map visuals allow you to create a geographical hierarchy in your report page? Select all that apply.

  • Heat maps
  • Filled map
  • Azure maps
  • Shape maps

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
  • In the Filters pane, add a filter based on the Year.
  • In the Filters pane, add a filter based on the Quarter, Month, and Day.
  • In the Format pane, modify the maximum range settings.

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

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

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

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

36. You have a Power BI desktop report containing three pages: Main, Delayed Response, and On-time Response. You have added a Button to the Main page for navigation.

You need to implement a solution that meets the following criteria:

The navigation destination must change based on the output of a DAX measure name [Delayed Response].

If [Delayed Response] is greater than 5%, the Button must display the text “Delayed Response” and navigate to the Delayed Response page.

Otherwise, the Button displays the text “On-time Response” and navigates to the On-time Response page.

What actions should you perform? Select all that apply.

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

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 creates a separate path for each employee-manager relationship.
  • The PATH function cannot handle multiple reporting relationships.
  • It concatenates all paths for each manager.
  • It chooses the shortest path for each employee.

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

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

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 report builder
  • Power BI mobile app
  • Power BI service
  • Power BI desktop

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

  • Area chart
  • Line chart
  • Waterfall chart
  • Scatter chart

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 Bin group type
  • A numerical column

  • A Date/time column
  • A List group type

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

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

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?

  • Viewer
  • Contributor
  • Member
  • Admin

44. 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 display visuals that use different datasets.
  • You need to add filters.
  • You need to display visuals from multiple pages.
  • You need to add slicers.

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

  • KPI
  • Gauge
  • Card visual
  • Python visual
  • Custom visuals

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:

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

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

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

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

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

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

  • On-demand refresh
  • Scheduled refresh
  • Incremental refresh

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

  • Azure Active Directory Security Group
  • Microsoft 365 Group
  • Mail-enabled group
  • Distribution group

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

  • Excel workbook
  • SharePoint folder
  • OneDrive for business
  • SharePoint list

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

  • SQL Server
  • OneDrive
  • Common data services

  • SharePoint

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

  • Power Query
  • Power Apps
  • Power BI
  • Power Automate

54. 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.
  • Modify the data source settings.
  • Modify the source of each query in the Power query editor.
  • Create a Power BI file, open the file, and change the data source when prompted.

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

  • Data view of Power BI desktop.
  • Data modeler.
  • Advanced editor.
  • Power query editor.

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

  • Left inner join
  • Right inner join
  • Left outer join
  • Right outer join

57. 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
  • Group by
  • Conditional split
  • Extract

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

  • Power query from Power BI desktop
  • Power BI Service
  • Power BI desktop interface
  • Power BI data modeler

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

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

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

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

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

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

62. 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(1,0,0,0))
  • =List.Dates(#date(2021,05,31), 1, #duration(1,0,0,0))
  • =List.Dates(#date(2021,05,31), 365, #duration(0,0,0,1))

63. 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 the Report view, create a what-if parameter.
  • In the Report view, add a DAX expression filter to the Salesperson table.
  • In the Report view, activate the view as a feature.
  • In Power query editor, add a conditional column to the Salesperson table.

64. 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 with Field parameters.
  • Implicit measures can be used to create Quick measures.
  • 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.

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

  • LASTDATE
  • CALENDARAUTO
  • DISTINCTCOUNT
  • LASTNONBLANK

66. 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
  • DATESINPERIOD
  • TOTALYTD

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

  • FILTER
  • CALCULATETABLE
  • TOPN
  • CALCULATE

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

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

  • DAX measures
  • DAX calculated columns
  • Aggregated tables
  • DAX calculated tables

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

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

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

  • Whole number
  • Decimal number
  • Text
  • Fixed decimal number

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

  • Install Python on your computer
  • Enable preview features in Power BI desktop.
  • Enable the script visuals options in the Model View of Power BI desktop.
  • Configure the global Python scripting option in Power BI desktop.

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

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

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

  • Alt + A
  • Tab
  • Tab + A
  • Alt

75. 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
  • Numeric
  • Boolean
  • Date/time
  • Binary

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

  • Filter
  • Drill through
  • Highlight
  • Expand

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

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

  • Selection pane from Power BI desktop.
  • Visualizations pane of Power BI desktop.
  • Selection pane from the query editor.
  • Page navigator from Power BI desktop.

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

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

80. 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 service
  • Power BI mobile app
  • Power BI report builder

81. 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 Analyze feature cannot be used for the first data point of the visual.

  • The Waterfall chart does not support the Analyze feature.
  • The Analyze feature can only be used in Power BI desktop.

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

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

  • Q&A visual
  • Waterfall chart
  • Key influencer visual
  • Decomposition tree

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

  • Workspace OneDrive
  • License mode
  • Allow contributors to update the app
  • Develop a template app

85. 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
  • False

86. 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.
  • Only datasets are published to Power BI service.

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

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

88. You are planning to get data from flat files for your company. The company wants a scheduled refresh for the dataset by using Microsoft 365 credentials. Which two of the following locations should you recommend? Select all that apply.

  • OneDrive for business
  • SharePoint – Team sites
  • Personal OneDrive account
  • Local file

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

  • Common data services
  • SQL Server
  • SharePoint
  • Microsoft OneDrive

90. How can you ensure data accuracy before analysis?

  • Use data visualization tools
  • Use data modeling tools
  • Using data profiling tools
  • Use data transformation tools

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

  • Split column
  • Replace values
  • Modify data type
  • Modify data category

92. 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 outer join
  • Left inner join
  • Right outer join

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

  • Model view of Power BI desktop
  • Page view of Power BI desktop
  • Power query editor
  • Data view of Power BI desktop

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

  • Fact table
  • Measure table
  • Dimension table
  • Look up table

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

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

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

  • M language in the query editor.
  • DAX in the query editor.
  • Python
  • SQL
  • DAX in the Power BI desktop.

97. In the model view of Power BI desktop, what are the categories to configure column properties?

  • General, Formatting, and Advanced.
  • Formatting and Advanced.
  • General and Advanced.
  • General and Formatting.

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

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

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

  • SUM and CALCULATE.
  • FILTER and SUMX.
  • FILTER and SUM.
  • FILTER and CALCULATE.

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

  • Funnel chart
  • Combo chart
  • Scatter plot
  • Waterfall chart

101. 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 text-based data
  • Only numerical values
  • Hierarchies can only be created with Data/time data fields
  • Both categorical and numerical data fields can be used

102. 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 Button to clear all the Slicers
  • Add a Bookmark
  • Duplicate the report page and remove the Slicers from the duplicated page

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

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

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

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

  • Trim
  • Extract
  • Date

  • Group By

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

  • DirectQuery
  • Import
  • None
  • Dual

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

  • The Data view of Power BI desktop.
  • The Model view of Power BI desktop.
  • The Power query editor
  • Advanced editor of Power query editor.

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

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

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

  • MIN
  • Average
  • SUM
  • Count

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

  • Power BI mobile app.
  • Power BI desktop.
  • Both Power BI desktop and Service.
  • Power BI service.

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

  • A KPI
  • Card visual
  • A Waterfall chart
  • A Scatter plot

112. 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 the month on the X-axis.
  • Create a Column chart displaying Date hierarchy on the X-axis and create a Slicer drop-down for salespersons.
  • 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.

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

  • Average line
  • Constant line
  • Min line
  • Max line

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

  • Review Questions
  • Relationships
  • Modeling
  • Synonyms
  • Visual formatting

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

  • Use of slicers and filters
  • Setup of data Alerts
  • Creation of multiple pages
  • Natural language queries

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

  • True
  • False

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

  • Personal
  • Highly confidential
  • Confidential
  • Certified

Leave a Reply