Power BI
Which Power Query feature allows you to add a new column even when you are uncertain about the specific transformations to apply? A. Column from example B. Custom column C. Conditional column D. Index column
A. Column from example
You plan to create a report in Power BI Desktop that will display sales opportunities by five sales stages, including lead, prospect, qualified, committed, and transacted. You need to identify the type of visualization that will display a linear process with sequentially connected stages, with one stage transitioning to the next. Which visualization should you use? A. funnel B. slicer C. treemap D. waterfall
A. funnel
You have a Power BI Desktop PBIX file that contains a single page report with multiple visuals. You plan to use Performance Analyzer to evaluate the performance of the visuals. You need to eliminate the impact of visual caching during the evaluation. What should you do first? A. Add a blank page to the PBIX file. B. Connect DAX Studio to the data model. C. Reopen the PBIX file. D. Start recording.
A. Add a blank page to the PBIX file.
You have a fact table that contains sales data. The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options. You load the fact table into Power BI Desktop. You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort. What should you do? A. Add a separate date dimension table. B. Add a year, month, and week columns to the fact table. C. Enable the Auto date/time current file option. D. Enable the Auto date/time global option.
A. Add a separate date dimension table.
You need to develop a quick measure in Power BI Desktop. Which two elements can you use? Each correct answer presents a complete solution. A. Calculations B. Conditional columns C. Data Analysis Expression (DAX) queries D. Fields E. Power Query M functions
A. Calculations D. Fields
You have a query named FactSales that retrieves data from a SQL Server table. You need to update the query to prevent new columns that may be added to the table in the future from getting imported during dataset refreshes. You select the existing columns in the query. Which two applied steps can you use in Power Query Editor to achieve the goal? Each correct answer presents a complete solution. A. Choose Columns B. Remove Columns C. Remove Other Columns D. Transpose
A. Choose Columns C. Remove Other Columns
You add a button to the Main page for navigation. You need to implement a solution that meets the following requirements: The navigation destination must change based on the output of a DAX measure named [Error Rate]. If [Error Rate] is greater than 5%, the button must display the text "Error Rate" and navigate to the Error Rate page. Otherwise, the button must display the text "On-time Rate" and navigate to the On-Time Rate page. What three actions should you perform? A. Create a DAX measure that outputs the correct page name based on the value of [Error Rate]. B. Set the button type to Page Navigation and then use conditional formatting to specify the destination. C. Set the button type to Bookmark and then use conditional formatting to specify the destination. D. Set the navigation destination to the Error Rate page. E. Use conditional formatting to set the button text.
A. Create a DAX measure that outputs the correct page name based on the value of [Error Rate]. B. Set the button type to Page Navigation and then use conditional formatting to specify the destination. E. Use conditional formatting to set the button text.
You need to reduce the size of a Power BI model that contains two dimension tables named Date and Location, and one fact table named Temperatures. You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships. You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location. What two actions should you perform? A. Create a column that contains the time values for the start of the hour of the Reading Time value. B. Disable the query load on the Temperatures query in the Power Query Editor. C. Remove the rows that occur exactly at 0 minutes and 0 seconds on the hour. D. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row. E. Use the Gro
A. Create a column that contains the time values for the start of the hour of the Reading Time value. D. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row.
You plan to publish a dataset from Power BI Desktop. You need to ensure that a server name can be changed after the dataset has been published to the Power BI Service. Which two actions should you perform? Each correct answer presents part of the solution. A. Create a parameter. B. Create a query for the server name. C. From the Data source settings in Power BI Desktop, update the permissions. D. From the Data source settings, update the server source to use a parameter. E. Update the Source applied step of all related queries to reference the server name query.
A. Create a parameter. D. From the Data source settings, update the server source to use a parameter.
You have a Power BI dashboard that is comprised of pinned visuals that are taken from a variety of reports. Which three objects from a report page can be pinned to the dashboard? A. Custom visual B. Filter C. Image D. Ribbon chart E. Slicer
A. Custom visual C. Image D. Ribbon chart
You have a dataset with location data that you intend to display on a map visual within your report. After adding a column that was created using the "Column From Examples" feature, you notice that the location data is not appearing on the map. Which feature should you modify for the column that you used in order to make the location data display correctly on the map? A. Data Category B. Data Type C. Summarization D. Edit Interactions
A. Data Category
In Power BI Desktop, you need to create a measure. Which two interfaces can you use? Each correct answer presents a complete the solution. A. Data view B. Page view C. Power Query Editor D. Report view
A. Data view D. Report view
Which statement accurately describes the differences between the storage modes in Power BI: Direct Query, Import, and Dual mode? A. Direct Query allows real-time data access by directly querying the data source, Import mode loads the entire dataset into Power BI, and Dual mode combines the advantages of both Direct Query and Import mode. B. Direct Query loads the entire dataset into Power BI for faster performance, Import mode queries the data source in real-time, and Dual mode combines the advantages of both Direct Query and Import mode. C. Direct Query and Import mode both load the entire dataset into Power BI, but Direct Query provides faster performance by directly querying the data source, while Import mode relies on cached data. Dual mode does not exist in Power BI.
A. Direct Query allows real-time data access by directly querying the data source, Import mode loads the entire dataset into Power BI, and Dual mode combines the advantages of both Direct Query and Import mode.
You have a fact table that contains sales data and the following two date columns: OrderDate ShipDate Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates. You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships. What should you do? A. Disable Make this relationship active for both relationships. B. Enable Apply security filter in both directions for both relationships. C. Enable Make this relationship active for both relationships. D. Set the cross-filter direction to both for each relationship.
A. Disable Make this relationship active for both relationships.
You have designed a star schema to simplify your data. You need to understand the relationship between the tables in the star schema. What is the relationship between the fact table and dimension tables? A. many-to-many B. many-to-one C. one-to-many D. one-to-one
B. many-to-one
You have a dataset containing information about 2,000 products in your inventory. The dataset includes the following fields: Product ID Product Name Category Price Quantity in Stock Supplier Name You import the dataset into Power Query Editor. You need to ensure that the dataset includes records for each Category to analyze and optimize your inventory management strategy. Which two actions should you take to satisfy this requirement? A. Enable Column profile B. Enable Column distribution C. Select close & apply D. Enable column profiling based on the entire dataset
A. Enable Column profile D. Enable column profiling based on the entire dataset
You need to prevent hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset. What two tasks should you perform? Each correct answer presents a complete solution A. Enable Mark as date table for the Calendar table. B. From the Current File options in Power BI Desktop, disable Auto Date/Time C. From the Global options in Power BI Desktop, disable Auto Date/Time for new files. D. Set the Data Category to None for all Date and DateTime fields.
A. Enable Mark as date table for the Calendar table. B. From the Current File options in Power BI Desktop, disable Auto Date/Time
You have a Power BI Desktop model. You need to determine when to use implicit and explicit measures. What is a feature of an implicit measure that explicit measure does NOT have? A. End-users can change the aggregation type of implicit measure from the Values well of a visual. B. Implicit measures can be used as a Drillthrough field. C. Implicit measures can be used to create Quick measures. D. Implicit measures can be used with Field Parameters.
A. End-users can change the aggregation type of implicit measure from the Values well of a visual.
You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1. You need to implement an incremental refresh of DS1. What should you do first? A. In Power BI Desktop, define filter parameters. B. In Power BI Desktop, define the incremental refresh policy. C. Publish the dataset to the Power BI service. D. Upgrade the Power BI workspace to the Premium SKU.
A. In Power BI Desktop, define filter parameters.
You are a data analyst working on a Power BI report for a retail company. The report aims to provide insights into sales performance, customer behavior, and product trends. As you design the report, you need to choose the appropriate visualizations for presenting different types of data. For analyzing the correlation between two or more metrics, which visualization should you choose? A. Scatter Plot B. Waterfall Chart C. Map D. Play Axis
A. Scatter Plot
Inside the Power Query Editor, there is an option called "Column Distribution" that will show you the total count of distinct values and unique values for all columns in the selected query. Within the Geography Key column, there are 249 distinct values and 67 unique values. Select the answer below that correctly describes the column distribution. A. There are 67 values that appear only once. B. There are 316 values that appear only once. C. There are 249 values that appear only once. D. There are 182 values that appear only once.
A. There are 67 values that appear only once
You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report. In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution. A. as a filter in the "Filters on this page" well of the Filters pane B. as a filter in the "Filters on this visual" well of the Filters pane C. as an item in the "Add drill-through fields here" well of the Visualizations pane D. as an item in the Fields well of a slicer
A. as a filter in the "Filters on this page" well of the Filters pane D. as an item in the Fields well of a slicer
In Power BI Desktop, you plan to use M-language to define a common date table spanning a period of 10 years. You need identify the M language function that would allow you to specify that rows in the table should represent consecutive days within the date range you designated. Your solution must minimize administrative effort. Which syntax should you use? A. #date B. #duration C. List.Combine D. List.Durations
B. #duration
You manage a Power BI workspace in a shared capacity. The workspace contains a dataset named DS1. You plan to schedule a refresh of DS1. What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule? A. 2 B. 4 C. 16 D. 64
B. 4
You've been tasked with creating a data model for your company Pragmatic Works Gaming. You have an Excel file containing data for sales, products, customers, and sales territory all in one worksheet titled PWGaming. Listed below are the steps needed to create the product dimensions. 1- Merge the Product Key back to PWGaming 2- Remove all columns except for those specific to Product 3- Add an index column. Rename to Product Key 4- Multi-select Product columns, then remove duplicates 5- Remove columns used in newly created dimension table 6- Duplicate the PWGaming query and rename the duplicated query to Product Select the answer choice that lists the steps needed to create a dimension table in the correct order. A. 6,5,4,3,2,1 B. 6,2,4,3,1,5 C. 2,4,6,1,3,5 D. 5,2,4,3,1,6
B. 6,2,4,3,1,5
You are a data analyst working on a Power BI report to analyze sales data for a retail company. While reviewing the report visuals, you notice significant fluctuations in sales values, with some visuals showing large increases and sharp drops. Which of the following features allows will explain the fluctuations? A. Binning B. Analyze C. Forecasting D. Edit Interactions
B. Analyze
You are a data analyst working in a large organization that uses Power BI as its primary data visualization tool. The organization has various reporting needs, and you are responsible for determining when to use paginated reports to meet specific requirements. What is a typical use case for paginated reports in Power BI? A. Creating dynamic and interactive reports with drill-through capabilities. B. Generating invoices, sales receipts, and financial statements with precise formatting. C. Designing reports with rich visuals and animated transitions. D. Building reports that require complex data modeling and DAX calculations.
B. Generating invoices, sales receipts, and financial statements with precise formatting.
You have a Power BI Desktop dataset based on a star schema data source. You need to use Data Analysis Expression (DAX) to create a date table in the dataset and populate the table with a range of dates based on the earliest and latest date within the dataset. Which function should you use? A. CALENDAR B. CALENDARAUTO C. DATE D. DATEDIFF
B. CALENDARAUTO
Power BI offers two methods to endorse your valuable and high-quality content, enhancing its visibility: promotion and certification. Select the answer choice that correctly describes the difference between the two. A. There is no difference between promoting and certifying content. Promotion highlights content you think is valuable for others to use. B. Certification means that the content meets the organization's quality standards and can be regarded as reliable, authoritative, and ready for use across the organization. C. Certification highlights content you think is valuable for others to use. Promotion means that the content meets the organization's quality standards and can be regarded as reliable, authoritative, and ready for use across the organization.
B. Certification means that the content meets the organization's quality standards and can be regarded as reliable, authoritative, and ready for use across the organization.
You plan to run Power BI Desktop Performance Analyzer. You need to ensure that the data engine cache will NOT impact the test results without restarting Power BI Desktop. What should you do first? A. Add a blank page to the .pbix file and select it. B. Connect DAX Studio to the data model. C. Invoke the Clear Cache function. D. Invoke the Refresh Metadata function.
B. Connect DAX Studio to the data model.
You need to create a visual that will display information on a continuous axis. Which two data types can be used to display a continuous axis on a visual? Each correct answer presents a complete solution. A. Binary B. Date C. Decimal Number D. Text
B. Date C. Decimal Number
Which statement correctly describes the difference between the "Drill Down" and "Drill Through" features in Power BI? A. Drill Down allows you to navigate to a different report page for more detailed information, while Drill Through allows you to view summarized data at different levels of granularity within the same visual. B. Drill Down allows you to view summarized data at different levels of granularity within the same visual, while Drill Through allows you to navigate to a different report page for more detailed information. C. Drill Down and Drill Through are the same features, and they both allow you to view more detailed information within the same visual. D. Drill Down and Drill Through are unrelated features in Power BI and have no impact on data exploration or navigation.
B. Drill Down allows you to view summarized data at different levels of granularity within the same visual, while Drill Through allows you to navigate to a different report page for more detailed information.
You have a Power BI model with the following fact tables and storage modes. FactStoreSales (Import mode) FactOnlineSales (DirectQuery mode) You have a dimension table named DimCalendar that has a relationship to both fact tables. You need to assign a storage mode for DimCalendar. The solution must minimize the time to execute queries that combine data from the dimension table and the fact tables. Which storage mode should you use? A. DirectQuery B. Dual C. Import D. none
B. Dual
You need to create a new hierarchy in Power BI Desktop. What should you do first? A. From the Model view, drag-and-drop one column onto another column in the Fields pane. B. From the Model view, right-click and select Create hierarchy. C. From the Report view, drag-and-drop one column onto another column in the Fields pane.
B. From the Model view, right-click and select Create hierarchy.
Which option describes the correct process of connecting to a shared dataset in the Power BI Desktop? A. Navigate to the "Modeling" tab, click on "Connect to Shared Dataset," and choose the desired dataset from the list. B. Go to the "Home" tab, click on "Get Data," and select "Power BI Dataset" from the data source options. C. Open the "Transform Data" window, click on "Manage Parameters," and specify the dataset location and credentials. D. Access the "View" tab, click on "Data Source Settings," and select the shared dataset connection from the available options.
B. Go to the "Home" tab, click on "Get Data," and select "Power BI Dataset" from the data source options.
You are modifying a report in Power BI Desktop. The report contains a single report page that has three card visuals and one clustered bar chart. You need to create a bookmark that displays only the clustered bar chart and hides the cards. The solution must minimize development effort. What should you do first? A. Add a bookmark in the Bookmarks Pane. B. Hide the three cards in the Selection Pane. C. Publish the report to the Power BI Service. D. Select the Spotlight option on the clustered bar chart.
B. Hide the three cards in the Selection Pane.
When importing data from an Excel workbook into Power BI, you receive the error message: "We couldn't find any data formatted as a table." What should you do to resolve the error? A. In the Excel workbook, select the data you want to import, select the Data Validation button, and save the change. B. In the Excel workbook, select the data you want to import, create a table, and save the change. C. In Power BI, add a template app. D. In Power BI, add an organizational app.
B. In the Excel workbook, select the data you want to import, create a table, and save the change.
You have implemented role-based security that restricts access to a Power BI Desktop dataset for users who are assigned the role named Salespeople. You need to validate that the implementation works. What should you do? A. In Power Query Editor, add a conditional column to the Salesperson table. B. In the Report view, activate the View as feature. C. In the Report view, add a DAX expression filter to the Salesperson table. D. In the Report view, create a what-if parameter.
B. In the Report view, activate the View as feature.
Which native AI visual helps explain correlations for a metric within the dataset? A. Decomposition Tree visual B. Key influencers visual C. Q&A visual D. Smart Narrative visual
B. Key influencers visual
You have a Power BI dataset that gets data from a table in a SQL Server database. From which view in Power BI Desktop can you modify the storage mode of the table? A. Data view B. Model view C. Page view D. Report view
B. Model view
In Power BI Desktop, you need to create a role. Which two interfaces can you use? Each correct answer presents a complete solution. A. Data view B. Model view C. Page view D. Power Query Editor E. Report view
B. Model view E. Report view
You plan to get data for a Power BI dataset from flat files. You need to select a location for the files. The location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365 credentials. Which two location types should you recommend? Each correct answer presents a complete solution. A. local file B. OneDrive for Business C. Personal OneDrive account D. SharePoint - Team Sites
B. OneDrive for Business D. SharePoint - Team Sites
From Power BI Desktop, you create a data source by importing an Excel file. You plan to identify data anomalies within the data source. Which interface should you use to display the column distribution and column quality graphs? A. Advanced Editor in Power Query Editor B. Power Query Editor C. the Data view D. the Model view
B. Power Query Editor
You're working on the data model for a company sales report. You need to create a DAX measure that will calculate the total sales. Which DAX expression below will generate the intended result? A. AVERAGE('Internet Sales'[Sales Amount]) B. SUM('Internet Sales'[Sales Amount]) C. COUNT('Internet Sales'[Sales Amount]) D. COUNTX('Internet Sales'[Sales Amount])
B. SUM('Internet Sales'[Sales Amount])
You plan to certify a Power BI dataset. You need to identify at which level within your organization the permissions to certify a dataset are assigned. Which level should you identify? A. Dataset B. Tenant C. Workbook D. Workspace
B. Tenant
You are a data analyst working on a complex Power BI report for a retail company. The report contains multiple visuals, DAX calculations, and large datasets. The company's management has expressed concerns about the report's performance and responsiveness. To address these issues, you decide to use the Performance Analyzer in Power BI Desktop. You open the Performance Analyzer in Power BI Desktop while interacting with your report. What type of information will you be able to analyze using the Performance Analyzer? A. Real-time monitoring of user interactions with the report on the Power BI service. B. The data load time and data refresh durations for datasets in the report. C. The internet connectivity details of users accessing the report. D. Hardware specifications of the computer running Power BI Desktop.
B. The data load time and data refresh durations for datasets in the report.
You create a Power BI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. After you import data from the data source into Power BI, you notice that one of the columns in the resulting dataset appears blank. You verify that the source table does include data. What should you do to resolve the issue? A. Clear permissions on the data source in Power BI. B. Use the CAST function in the SQL statement. C. Use the DATALENGTH function in the SQL statement. D. Set the privacy levels on the data source.
B. Use the CAST function in the SQL statement.
You have the following Power Query M formula that generates a range of dates. = List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0)) What is the resulting date range? A. a list of days ending on May 31, 2020 and starting 365 days earlier B. a list of days starting on May 31, 2020 and ending 365 days later C. a list of months ending in May 2020 and starting 12 months earlier D. a list of months starting in May 2020 and ending 12 months later
B. a list of days starting on May 31, 2020 and ending 365 days later
You upload reports to the Power BI service and pin several visuals to a dashboard. You plan to create alerts rules for several visuals. What are two locations you can view the alerts? Each correct answer presents a complete solution. A. a report B. an email C. Microsoft Teams D. the Notification Center
B. an email D. the Notification Center
You need to make changes to your data sources. Which three changes are supported by the Data Source Settings in the Power Query interface? Each correct answer presents a complete solution. A. adding a column B. clearing permissions C. editing permissions D. modifying the file path E. renaming a column
B. clearing permissions C. editing permissions D. modifying the file path
You import an Excel file into Power BI Desktop and begin to analyze the data in Power Query Editor. You need to identify outliers in a text column within the data source. Which information should you use from Power Query Editor? A. the min and max values in Column profile B. the top and bottom entries in Value distribution C. the value of the Distinct entry in Column statistics D. the value of the Unique entry in Column statistics
B. the top and bottom entries in Value distribution
You manage a Power BI workspace in shared capacity. The workspace contains a dataset named DS1. You plan to schedule the refresh of DS1. What is the maximum number of data refreshes per day? A. 1 B. 4 C. 8 D. 24
C. 8
Your company has a SharePoint server located in a datacentre in Montreal. You plan to create a report in the Power BI service that will use 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. a Point to Site virtual private network (VPN) B. a Site-to-Site virtual private network (VPN) C. an on-premises data gateway D. Azure Data Box
C. an on-premises data gateway
You have a Power BI Desktop dataset that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson's Microsoft Entra ID account. You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name. Which two actions should you perform? Each correct answer presents part of the solution. A. Add a calculated column to the Salesperson table. B. Add a conditional column to the Salesperson table. C. Add a DAX expression filter to the Salesperson table. D. Create a role. E. Create a what-if parameter.
C. Add a DAX expression filter to the Salesperson table. D. Create a role.
You are developing a Power BI report that contains a column chart, map, and card visual. The interactions for each are set to the default behaviors for all visuals. How should you configure the interactions, so that when a selection is made on the map, the column chart renders to only show the selected data? A. Change the column chart to no interaction. B. Change the map to highlight. C. Change the column chart to filter. D. Change the map to no interaction.
C. Change the column chart to filter.
You are a data analyst working on a Power BI report for a retail company. The report aims to provide insights into sales performance, customer behavior, and product trends. As you design the report, you need to choose the appropriate visualizations and elements for presenting different types of data. You have a bar chart displaying the current year's sales by country, but you need to add a reference line to show the target sales goal. Which option should you choose? A. Average line B. Median line C. Constant line D. Min line
C. Constant line
Which of the following options correctly explains the difference between distinct and unique values in Power BI? A. Distinct values refer to the total number of occurrences of a specific value in a column, while unique values indicate the number of different values present in that column. B. Distinct values and unique values have no relevance in Power BI and are not used in any data analysis or calculations. C. Distinct values indicate the number of different values present in a column, while unique values refer to the total number of values that occur only once in a column. D. Distinct values and unique values are two terms that are used interchangeably in Power BI, and there is no practical difference between them.
C. Distinct values indicate the number of different values present in a column, while unique values refer to the total number of values that occur only once in a column.
You have a Power BI Desktop dataset that includes a table named Employees containing a row for each employee with the following columns: Employee ID Employee Name Manager ID Manager Name You need to flatten the parent-child hierarchy in the Employees table by adding an extra column that will contain a listing of employee IDs for all direct and indirect managers of each employee. Which two Data Analysis Expression (DAX) functions should you use? Each correct answer presents part of the solution. A. PATHCROSSJOIN B. EXCEPT PATHITEM C. EXCEPTPATH D. PATHITEM CROSSJOIN E. RELATED
C. EXCEPTPATH D. PATHITEM CROSSJOIN
You have a bar chart and column chart visual on a report page. Selecting any column from the bar chart visual filters the column chart data to less than 1% of its unfiltered value. Which type of visual interaction should be used when the bar chart is filtering the column chart to ensure that you can easily see the data? A. expand B. drillthrough C. filter D. highlight
C. filter
Which of the following actions can help optimize model performance in Power BI? A. Adding more visuals and charts to the report for better data representation. B. Increasing the font size and applying custom formatting to improve visualization. C. Importing only the necessary columns from the data source to reduce data load. D. Using complex DAX calculations to derive insights and KPIs from the data.
C. Importing only the necessary columns from the data source to reduce data load.
You are a data analyst working on a Power BI report for a retail company. The report aims to provide insights into sales performance, customer behavior, and product trends. As you design the report, you need to choose the appropriate visualizations for presenting different types of data. You need to compare the sales performance of different products over time. What visualization should you use? A. Stacked Column Chart B. Waterfall Chart C. Line Chart D. Funnel Chart
C. Line Chart
In the Power BI Service, which groups cannot be used to assign security roles for managing access and permissions? A. Distribution Group B. Mail-enabled Group C. Microsoft 365 Group D. Security Group
C. Microsoft 365 Group
You have a table that contains a column named ProductID. The ProductID column contains values that have a prefix of PD followed by five numbers. For example: pd15332. You plan to convert the ProductID values to numbers (integer). You need to remove the leading two letters from the current ProductID values. Which command should you use? A. Remove Rows B. Replace Errors C. Replace Values D. Trim
C. Replace Values
You have multiple Excel files stored in a folder synced with OneDrive for Business. You need to import data from the files. The solution must NOT use a data gateway. Which type of connector should you use? A. Excel workbook B. Folder C. SharePoint folder D. SharePoint list
C. SharePoint folder
Subscriptions and alerts are both features that will notify you about your data. Select the answer choice below that correctly describes the difference between these features. A. Subscriptions enable data refresh for datasets, while alerts manage user access to reports and dashboards. B. Subscriptions are used to create custom visualizations, while alerts automate report generation. C. Subscriptions allow you to schedule automatic reports and dashboards to users' inboxes, while alerts provide data-driven notifications. D. Subscriptions and alerts are the same.
C. Subscriptions allow you to schedule automatic reports and dashboards to users' inboxes, while alerts provide data-driven notifications.
A large healthcare organization is using Power BI to analyze its patient data and medical records. They have sensitive information that should only be accessible to specific users based on their roles and permissions. Row-level security (RLS) is implemented to restrict data access for certain users. A. Users with Admin permissions. B. Users with Members permissions. C. Users with Viewer permissions. D. Users with Contributor permissions.
C. Users with Viewer permissions.
You have a collection of datasets and reports. You need to share the datasets and report together. This solution must NOT send any email notifications to internal users after sharing. What should you create in the Power BI Service? A. a deployment pipeline B. a workspace C. an app D. metrics
C. an app
You have several on-premises Microsoft SQL Server databases. You need to provide Power BI Service users access to the data sources without exposing the database servers directly to the internet. The solution must minimize the configurations that must be performed by each user. What should you deploy? A. a virtual network data gateway B. an ExpressRoute connection C. an on-premises data gateway D. an on-premises data gateway (personal mode)
C. an on-premises data gateway
You are editing a report in Power BI Desktop. You need to adjust the behavior of the report by editing interactions. Which two types of interaction behavior can you change between visuals? Each correct answer presents a complete solution. A. drillthrough B. expand C. filter D. highlight
C. filter D. highlight
You decide to start using variables when creating DAX formulas. What are two benefits of using variables in DAX measures over using original expressions? Each correct answer presents a complete solution. A. allows users to change the data source connection in the DAX measure B. has additional functions that can be used in the DAX measure C. improves the overall performance of the resulting DAX measure D. improves the overall readability of the resulting DAX measure
C. improves the overall performance of the resulting DAX measure D. improves the overall readability of the resulting DAX measure
You decide to remove unnecessary columns from your data model. What are two potential performance benefits of doing this? Each correct answer presents a complete solution. A. decreasing report page load times B. increasing DAX performance C. increasing the refresh speed D. reducing the size of the data model
C. increasing the refresh speed D. reducing the size of the data model
You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode. What are two benefits of using DirectQuery instead of Import? Each correct answer presents a complete solution. A. full support for the Q&A Power BI service B. full support for the Quick Insights Power BI service C. minimized local disk space usage D. minimized need for data refresh
C. minimized local disk space usage D. minimized need for data refresh
You plan to optimize the performance of Power BI Desktop queries against a remote data source. You need to disable the default behavior that automatically applies cross highlighting and filtering of visuals within the same report. Which option should you configure in Power BI Desktop? A. the Filters Query reduction settings B. the Persistent filters of Report settings C. the Reduce number of queries sent by Query reduction setting D. the Slicers Query reduction settings
C. the Reduce number of queries sent by Query reduction setting
You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip? A. a report page tooltip with cross-highlighted data B. both the un-filtered and filtered (cross-highlighted) data C. the filtered (cross-highlighted) data D. the un-filtered (non-cross-highlighted) total data
C. the filtered (cross-highlighted) data
You need to use DAX quick measures to generate results to use in a report. Which type of DAX quick measure calculations will NOT work against a DirectQuery table? A. aggregate per category B. mathematical operations C. time intelligence D. X-functions
C. time intelligence
You have a Power BI Premium per user workspace. What is the maximum number of refreshes that can be scheduled each day? A. 1 B. 8 C. 16 D. 48
D. 48
You have a workspace named "Sales Analytics" that contains sensitive sales data. You want to grant access to the "Sales Team" group and ensure that they can view, interact, and modify the reports and dashboards. They should not be able to add or delete others. However, you also want to restrict access for the "Finance Team" group to read-only permissions, allowing them to consume the reports but not make any changes. A. Assign both the "Sales Team" and "Finance Team" groups to the "Member" role in the workspace settings. B. Assign the "Sales Team" group to the "Member" role and the "Finance Team" group to the "Admin" role in the workspace settings. C. Assign the "Sales Team" group to the "Admin" role and the "Finance Team" group to the "Contributor" role in the workspace settings. D. Assign the "Sales Team" group to the "Contributor" role and the "Finance Team" group to the "Viewer" role in the workspace settings.
D. Assign the "Sales Team" group to the "Contributor" role and the "Finance Team" group to the "Viewer" role in the workspace settings.
In Power BI Desktop, you can group data points to help you more clearly view, analyze, and explore data and trends in your visuals. One method of grouping allows you to create subsets of your data. What is the name of this feature? A. Grouping B. Binning C. Forecasting D. Clustering
D. Clustering
You are in the final stages of developing a Power BI Report. The report contains a Sales Report, Product, and Customer page. You want to set up the report so that when a selection from one of the slicers is made on the Sales Report page, the Product and the Customer pages will also update with the selection made. What should you do to implement this? A. Set the "Page-Level Filters" option to "On" in the report settings. B. Create separate slicers for each page and do nothing else. C. Manually clear the slicer selections on the other pages, when a selection is made. D. Enable "Sync Slicers" across all pages.
D. Enable "Sync Slicers" across all pages.
From the Power Query Editor, you import data from a .csv file. The data includes a column named ZIP that contains postal codes from the United States. You notice that Power Query Editor automatically applies the Whole Number data type to the ZIP column. You need to ensure that the ZIP column uses the Text data type and that all values remain 5 characters long. What should you do? A. From the data view in Power BI Desktop, change the column data type from number to text. B. From Power Query Editor, add a new applied step at the end of the query to convert the ZIP column from number back to text. C. From Power Query Editor, delete the changed type step. D. From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.
D. From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.
You are developing a report for a bank that contains the following tables: Accounts and Customers. Row-level security (RLS) has been configured based on user roles to ensure compliance with privacy regulations. As you create a relationship between the tables, you want to ensure that bidirectional cross-filtering respects the RLS settings. A. Since RLS is already configured, no further action is needed for creating the relationship between the Accounts and Customers tables. B. Configure the relationship between tables using the "Edit Interactions" feature. C. In the "Relationship Editor", change the relationship from an active to an inactive relationship. D. In the "Relationship Editor", enable the "Apply security in both directions" feature.
D. In the "Relationship Editor", enable the "Apply security in both directions" feature.
You are using Power BI Desktop to edit a stacked column chart that displays gross sales data with a date hierarchy that contains year, quarter, month, and day. You need to prevent users from viewing the hierarchy based on the year. What should you do? A. In the Filters pane, add a filter based on the quarter, month, and day. B. In the Filters pane, add a filter based on the year. C. In the Format pane, modify the Maximum Range setting. D. In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis.
D. In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis.
In Power BI, what are implicit measures? A. Measures that are created by users using DAX formulas to perform specific calculations. B. Measures that are hidden and not visible in the report, but used for relationship keys. C. Measures that are applied to specific visuals only and not available for other visuals. D. Measures that are automatically created by Power BI based on the data fields in the dataset.
D. Measures that are automatically created by Power BI based on the data fields in the dataset.
In the Power Query Editor, merge and append queries are two options you can use to combine data. Which of the following statements below, correctly describes the difference between the two? A. Merging and appending are two identical operations in Power BI, both used to horizontally join columns from different tables. B. Merging is exclusively used to create key columns to build relationships between tables, whereas appending is used for data cleaning and transformation purposes. C. Append combines columns from one table with columns of another, while merge combines rows from one table to rows of another. D. Merge combines columns from one table with columns of another, while append combines rows from one table to rows of another.
D. Merge combines columns from one table with columns of another, while append combines rows from one table to rows of another.
You need to reduce the cardinality of a column in a Power BI dataset. What should you do? A. Add a prefix to each value in the column. B. Add a suffix to each value in the column. C. Replace null values with a value of 0. D. Reduce the number of distinct values
D. Reduce the number of distinct values
You need to add a new visual to a Power BI Dashboard. This visual does NOT exist on a report in the workspace. What should you do first? A. Open See Related Content. B. Open the File menu. C. Select Add a tile. D. Select Ask a question about your data.
D. Select Ask a question about your data.
You plan to get data from flat files for a Power BI dataset. You need to select a location to store the files. Which location requires an on-premises data gateway? A. OneDrive for Business B. Personal OneDrive account C. SharePoint Online Team Sites D. Shared folder on a local network
D. Shared folder on a local network
You are working on a Power BI report that analyzes sales data. You want to compare the sales performance of the current year with the same period of the previous year and also calculate the year-to-date (YTD) sales for the current year. Which DAX expression below will help you achieve this? A. TOTALYTD(SUM('Internet Sales'[Sales Amount]), LASTDATE('Date'[Date])) B. TOTALYTD(SUM('Internet Sales'[Sales Amount]), CLOSINGBALANCEYEAR('Date'[Date])) C. TOTALYTD(SUM('Internet Sales'[Sales Amount]), ENDOFYEAR('Date'[Date])) D. TOTALYTD(SUM('Internet Sales'[Sales Amount]), SAMEPERIODLASTYEAR('Date'[Date]))
D. TOTALYTD(SUM('Internet Sales'[Sales Amount]), SAMEPERIODLASTYEAR('Date'[Date]))
Adventure Works, a global retail company, is using Power BI to analyze their sales data. They have a date dimension table that contains information about various dates, such as order date, ship date, and delivery date. The date dimension table has been linked to the reseller sales facts table using three different relationships. A. The date dimension table can be used to filter facts based on the user's role in the organization. B. The date dimension table can be used with different measures in the reseller sales facts table for analysis. C. The date dimension table can be linked to multiple fact tables to provide additional context for analysis. D. The date dimension table can be used to filter facts differently based on different types of date information, such as order date, ship date, or delivery date.
D. The date dimension table can be used to filter facts differently based on different types of date information, such as order date, ship date, or delivery date.
What is the primary function of a data gateway? A. To store imported data for faster query performance. B. To establish a secure connection to cloud-based data sources. C. To allow users to refresh imported data manually. D. To bridge the connection between Power BI and on-premises data sources.
D. To bridge the connection between Power BI and on-premises data sources.
You have a row level security role (RLS) in a dataset called User Security Group. This role needs to filter a RLS table that contains a column with the emails of users in the following format: [email protected] Which function should be used in the code for the RLS role to match the users Microsoft Entra ID login credentials with the emails contained in the RLS table column? A. NAMEOF B. TREATAS C. USEROBJECTID D. USERPRINCIPALNAME
D. USERPRINCIPALNAME
You have an Excel spreadsheet that contains three columns labeled Year, 2021, and 2012. The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year. You import data from the Excel spreadsheet into Power BI Desktop. You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year. Which transformation should you use first? A. Pivot B. Remove Columns C. Transpose Table D. Unpivot
D. Unpivot
You plan to create a report in Power BI Desktop. You need to identify the type of visualization that displays data as a set of nested rectangles. Which visualization should you use? A. bar chart B. column chart C. slicer D. treemap
D. treemap
You plan to create a report in Power BI Desktop. You need to create a visualization to display a running total. The solution must meet the following requirements: The initial and the final value columns must start on the horizontal axis. The intermediate values must be floating columns. Which type of visualization should you use? A. combo B. funnel C. scatter D. waterfall
D. waterfall
True or False: Parameters in Power BI allow you to dynamically change filter values and data sources within a report.
True
