How to pass Microsoft PL-300 exam with the help of dumps?

Question # 1

You are creating a Power BI report to analyze consumer purchasing patterns from a tablenamed Transactions. The Transactions table contains a numeric field named Spend. Youneed to include a visual that identifies which fields have the greatest impact on Spend.Which type of visual should you use?

A. decomposition tree
B. Q&A
C. smart narrative
D. key influences

Show Answer

Question # 2

You are creating a dashboard by using the Power Bl service.You have an existing report page that contains three charts.You need to add the charts to the dashboard while maintaining the interactivity between thecharts.What should you do?

A. Pin each chart as a tile.
B. Edit interactions in the report and set all interactions to Filter
C. Edit the dashboard theme and pin each chart as a file.
D. Pin the report page as a live tile.

Show Answer

Question # 3

You have a Rawer Bl report That imports a dace table and a sales table from an AzureSQL database data source. The sales table has the following date foreign keys:• Due Date• Order Date• Delivery DateYou need to support the analysis of sales over time based on all three dates at the sametime.Solution: From the Fields pane, you rename the date table as Due Date. You use a DAXexpression to create Order Date and Delivery Date as calculated tables. You create activerelationships between the sales table and each date table.Does this meet the goal?

A. Yes
B. No

Show Answer

Question # 4

You have a dataset that is used infrequently and refreshes every hour.You receive a notification that the refresh was disabled due to inactivity.Which two actions will cause the scheduled refresh schedule to resume? Each correctanswer presents a complete solution.NOTE: Each correct selection is worth one point.

A. Enable query caching for the dataset.
B. Import the dataset to Microsoft Excel.
C. From the Power BI service, open a dashboard that uses the dataset.
D. From the Power BI service, open a report that uses the dataset.
E. From PowerShell, run the get-powerbireport cmdlet.

Show Answer

Question # 5

Note: This question is part of a series of questions that present the same scenario. Eachquestion in the series contains a unique solution that might meet the stated goals. Somequestion sets might have more than one correct solution, while others might not have acorrect solution.After you answer a question in this section, you will NOT be able to return to it. As a result,these questions will not appear in the review screen.From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in query.You need to analyze IoT events by the hour and day of the year. The solution mustimprove dataset performance.Solution: You remove the loT GUID column and retain the loT ID column.Does this meet the goal?

A. Yes
B. No

Show Answer

Question # 6

What should you create to meet the reporting requirements of the sales department?

A. Option A
B. Option B
C. option C
D. Option D

Show Answer

Question # 7

You have two Power Bl reports named ReportA and ReportB that each uses a distinct colorpalette.You are creating a Power Bl dashboard that will include two visuals from each reportYou need to use a consistent dark theme for the dashboard. The solution must preservethe original colors of the reports.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. Upload a snapshot.
B. Select the dark dashboard theme.
C. Turn on tile flow.
D. When pinning visuals to the dashboard, select Use destination theme.
E. For the browser, set the color preference to dark mode.

Show Answer

Question # 8

You need to create a Power BI theme that will be used in multiple reports. The theme willinclude corporate branding for font size, color, and bar chart formatting.What should you do?

A. From Power Bl Desktop, customize the current theme,
B. From power Bl Desktop, use a built in report theme.
C. Create a theme as a JSON file and import the theme into Power Bl Desktop.
D. Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

Show Answer

Question # 9

You are using the key influencers visual to identify which factors affect the quantity of itemssold in an order.You add the following fields to the Explain By field:* Customer Country* Product Category* Supplier Country* Sales Employee* Supplier Name* Product Name* Customer CityThe key influencers visual returns the results shown in the following exhibit.

A. Customers in Austria order 18.8 more units than the average order quantity.
B. Customers in Boise order 20.37 percent more than the average order quantity.
C. Product Category positively influences the quantity per order.
D. Customers in Cork order lower quantities than average.

Show Answer

Question # 10

Remove unused columns from tables in the data model. This will reduce the size of yourPBIX file and make your data model more efficient. You can use Power Query Editor toremove any columns that are not used in your report or calculations.

A. Pivot column
B. Merge columns
C. Unpivot columns.
D. Transpose

Show Answer

Question # 11

Note: This question is part of a series of questions that present the same scenario. Eachquestion in the series contains a unique solution that might meet the stated goals. Somequestion sets might have more than one correct solution, while others might not have acorrect solution.After you answer a question in this section, you will NOT be able to return to it. As a result,these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in query.You need to analyze IoT events by the hour and day of the year. The solution mustimprove dataset performance.Solution: You split the loT DateTime column into a column named Date and a columnnamed Time.Does this meet the goal?

A. Yes
B. No

Show Answer

Question # 12

You need to create a Power Bl theme that will be used in multiple reports. The theme willinclude corporate branding for font size, color, and bar chartformatting.What should you do?

A. Create a theme as a PBIVIZ file and import the theme into Power Bl Desktop.
B. Create a theme as a JSON file and import the theme into Power Bl Desktop.
C. From Power Bl Desktop, use a built-in report theme.
D. From Power Bl Desktop, customize the current theme.

Show Answer

Question # 13

You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit. You need to ensure that users can ask questions by using the term airline or carrier. Thesolution must minimize changes to the data model.What should you do?

A. Add a duplicate query named Airline.
B. Add airline as a synonym of carrier.
C. Rename the carrier column as airline in the Carriers query.
D. Rename the query from Carriers to airlines.

Show Answer

Question # 14

You have a CSV file that contains user complaints. The file contains a column namedLogged. Logged contains the date and time each compliant occurred. The data in Loggedis in the fol-lowing format: 2018-12-31 at 08:59. You need to be able to analyze thecomplaints by the logged date and use a built-in date hierarchy. What should you do?

A. Create a column by example that starts with 2018-12-31.
B. Apply a transformation to extract the last 11 characters of the Logged column and setthe data type of the new column to Date.
C. Apply a transformation to extract the first 11 characters of the Logged column.
D. split the Logged column by using at as the delimiter.

Show Answer

Question # 15

You are building a Power Bl report.Users will view the report by using their mobile device.You need to configure the report to display data based on each user s location.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. For the relevant columns, set synonyms to match common geographical terms.
B. From Power Query Editor, detect the data types of the relevant columns.
C. Use the columns of the geography data type in all visuals.
D. Create a hierarchy for columns of the geography data type.
E. In Data Category, set the geographic data category for the relevant columns.

Show Answer

Question # 16

You are creating a query to be used as a Country dimension in a star schema.A snapshot of the source data is shown in the following table. You need to create the dimension. The dimension must contain a list of unique countries.Which two actions should you perform? Each correct answer presents part of the solution.

A. Remove duplicates from the Country column.
B. Remove duplicates from the City column.
C. |Remove duplicates from the table.
D. Delete the City column.
E. Delete the Country column.

Show Answer

Question # 17

You have a Power Bl report that contains a page. The page contains the following:• A shape named Shape 1• A card named Sales Summary• A clustered bar chart named Sales by RegionYou need to ensure that Sales Summary renders on top of Shape 1. What should youmodify?

A. Tab order in the Selection pane
B. Layer order in the Selection pane
C. Maintain layer order in the General visual settings
D. Vertical alignment in the Canvas settings

Show Answer

Question # 18

You have a Power BI workspace named BI Data that contains a dataset named BI Finance.You have the Build permission for the 81 Finance dataset but you do NOT havepermissions for the workspace,You need to connect to BI Finance and create a report.Which actions should you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

A. From the Power BI service, create a dataflow to the dataset by using DirectQuery.
B. From Power BI Desktop, connect to a Dataverse data source.
C. From the Power BI service, create a new report and select a published dataset
D. From Power Bl Desktop, connect to a shared dataset

Show Answer

Question # 19

Note: This question is part of a series of questions that present the same scenario. Eachquestion in the series contains a unique solution that might meet the stated goals. Somequestion sets might have more than one correct solution, while others might not have acorrect solution.After you answer a question in this section, you will NOT be able to return to it. As a result,these questions will not appear in the review screen.You have a Power BI report that imports a date table and a sales table from an Azure SQLdatabase data source. The sales table has the following date foreign keys:Due DateOrder DateDelivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: For each date foreign key, you add inactive relationships between the sales tableand the date table.Does this meet the goal?

A. Yes
B. No

Show Answer

Question # 20

Note: This question is part of a series of questions that present the same scenario. Eachquestion in the series contains a unique solution that might meet the stated goals. Somequestion sets might have more than one correct solution, while others might not have acorrect solution.After you answer a question in this section, you will NOT be able to return to it. As a result,these questions will not appear in the review screen.From Power Query Editor, you profile the data shown in the following exhibit. The IOT ID columns are unique to each row in query.You need to analyze 10T events by the hour and day of the year. The solution mustimprove dataset performance.Solution: You create a custom column that concatenates the 10T GUID column and the IoTID column and then delete the IoT GUID and IoT ID columns.Does this meet the goal?

A. Yes
B. No

Show Answer

Question # 21

What should you do to address the existing environment data concerns?

A. a calculated column that uses the following formula: ABS(Sales[sales_amount])
B. a measure that uses the following formula: SUMX(FILTER('Sales','Sales'[sales_amount] > 0)),[sales_amount])
C. a measure that uses the following formula: SUM(Sales[sales_amount])
D. a calculated column that uses the following formula:IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Show Answer

Question # 22

You have a Power Bi report for the procurement department. The report contains data fromthe following tables.

A. Remove the rows from Lineitems where LineItems[invoice Date] is before the beginningof last month
B. Merge Suppliers and Uneltems.
C. Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum ofLineitems(price).
D. Remove the Lineitems[Description] column.

Show Answer

Question # 23

In Power BI Desktop, you are creating a report that will contain three pages.You need to create a custom tooltip page and prepare the page for use.Which three actions should you perform? Each correct answer presents part of thesolution.

A. Configure filters on the target visual.
B. For the target page, set Allow use as tooltip to On.
C. Add and configure visuals on the tooltip page.
D. For the tooltip page, set Allow use as tooltip to On.
E. For the tooltip page, configure filters.

Show Answer

Question # 24

What is the minimum number of Power BI datasets needed to support the reports?

A. a single imported dataset
B. two imported datasets
C. two DirectQuery datasets
D. a single DirectQuery dataset

Show Answer

Question # 25

You have a Power Bl report that contains five pages.Pages 1 to 4 are visible and page 5 is hidden.You need to create a solution that will enable users to quickly navigate from the first pageto all the other visible pages. The solution must minimize development and maintenanceeffort as pages are added to the report.What should you do first?

A. Add a blank button to page 1.
B. Add a bookmark navigation button to page 1.
C. Create a bookmark for each page.
D. Add a page navigation button to page 1.

Show Answer

Question # 26

There are four departments in the Departments table. You need to ensure that users can see the data of their respective department only. What should you do?

A. Create a row-level security (RLS) role for each department, and then define the membership of the role. 
B. Create a DepartmentID parameter to filter the Departments table. 
C. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function. 
D. Create a slicer that filters Departments based on DepartmentID. 

Show Answer

Question # 27

You import a Power Bl dataset that contains the following tables: • Date • Product • Product Inventory The Product inventory table contains 25 million rows. A sample of the data is shown in the following table. The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

A. Change Summarization for DateKey to Don't Summarize. 
B. Change the data type of UnitCost to Integer.
 C. Remove the relationship between Date and Product Inventory.
 D. Remove MovementDate. 

Show Answer

Question # 28

You plan to embed multiple visualization in a public website. Your Power BI infrastructure contains the visualizations configured as shown in the following table. Which two visualizations can you embed into the website? Each correct answer presents a complete the solution. NOTE: Each correct selection is worth one point.

A. Visual1 
B. Visual2 
C. Visual3 
D. Visual4 
E. Visual5 

Show Answer

Question # 29

A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements: • Minimize online processing operations. • Minimize calculation times and render times for visuals. • include data from the current year, up to and including the previous day. What should you do? 

A. Create a dataflows connection that has Import mode selected and schedule a dairy refresh. 
B. Create a dataflows connection that has DirectQuery mode selected.
 C. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset 
D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly. 

Show Answer

Question # 30

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do? 

A. Add a column chart, a bookmark, and a button for users to choose a visual. 
B. Create a mobile report that contains a column chart. 
C. Create a separate report page for users to view the column chart. 
D. Enable report readers to personalize visuals. 

Show Answer

Question # 31

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings. You need to modify the report so that when you select a column m the column chart, the donut chart redraws by using the data from the selected column. What should you do? 

A. Select the column chart and set the donut chart interaction to None. 
B. Select the column chart and set the donut chart interaction to Filter. 
C. Select the donut chart and set the column chart interaction to Filter. 
D. Select the donut chart and set the column chart interaction to None. 

Show Answer

Question # 32

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

A. From Power Query Editor, modify the source of each query. 
B. Create a PBiT file, open the file, and change the data sources when prompted 
C. From Power Query Editor, create new queries. 
D. Modify the Data source settings.

Show Answer

Question # 33

You are creating a Power BI model that contains a table named Store. Store contains the following fields. You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property? 

A. Set the data category of City. State/Province, and Country. 
B. Set Summarization for City. State/Province, and Country to Don't summarize 
C. Change the data type of City. State/Province, and Country. 
D. Create a calculated column that concatenates the values it City, State/Province, and Country. 

Show Answer

Question # 34

You have a Power Bl workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?

A. Grant the Read permission for the datasets to the user. 
B. Add the user as a Viewer of the workspace. 
C. Share the reports with the user.
D. Create a row-level security (RLS) role and add the user to the role. 
E. Add the user as a member of the workspace. 

Show Answer

Question # 35

You have a BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset. You grant the users the Build permission for dataset What Should do next?

A. Change default visual interaction for the report 
B. For the report change the Export data setting to Summarized data, data with current layout and underlying data 
C. For the report, change the Export data setting to None 
D. Certify the dataset used by the report. 

Show Answer

Question # 36

You have a Power BI report that contains four pages. All the pages contain a slicer for a field named Country, You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages, What should you do? 

A. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters. 
B. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters. 
C. Sync the Country slicer on page 1, page 2, and page 3, 
D. Move the Country slicer from page 2 and page 3 to page 1. 

Show Answer

Question # 37

The dataset takes a long time to refresh. You need to modify Posts and Traffic queries to reduce toad times. Which two actions will reduce the toad times? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. 

A. Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/" 
B. Remove the rows in Posts m which Post [Publish Date] is in the last seven days. 
C. Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL). 
D. Remove Posts [Full Text] and Posts [Summary]. 
E. Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog'' 

Show Answer

Question # 38

You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access: • External users can access the dashboard. • Managers can access the dashboard and a manager-specific report. • Employees can access the dashboard and a row-level security (RLS) constrained report. You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised. What should you use? 

A. subscriptions 
B. comments 
C. alerts 
D. chat in Microsoft Teams 

Show Answer

Question # 39

You have the following table named Location.

A. Replace the values in the GeoCode column with postal codes or zip codes. 
B. Change the name of the GeoCode column to Country. 
C. Change the name of the Location table to Country. 
D. Change the Default Summarization of the GeoCode column.
 E. Add a Geoportal column to the Location table. 
F. Change the Data Type of the GeoCode column.

Show Answer

Question # 40

You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do? 

A. Sync the slicers on Page1 and Page3 
B. On each page, modify the interactions of the slicer.
 C. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2. 

Show Answer

Question # 41

You have a Power Bl report You have a table named Dalai that contains 10 million rows. Data is used in the following visuals: • A card that shows the number of records • A bar chart that snows total transaction amount by territory • A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals-What should you do? 

A. Apply a row filter to the Dalai query in Power Query Editor.
B. Add a trend line to the scatter plot 
C. Enable high-density sampling on the scatter plot 
D. Add a count field of the transaction amount to the size bucket of the scatter plot 

Show Answer

Question # 42

You have a report in Power Bl named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected. What should you do?

A. Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset. 
B. Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report. 
C. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report. 
D. Apply row-level security (RLS) to the shared dataset. 

Show Answer

Question # 43

The Sales table contains records of sales by day from the last five years up until today's date. You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected. Which DAX expression should you use? 

A. Option A 
B. Option B 
C. option C 
D. Option D

Show Answer

Question # 44

A. Option A 
B. Option B 
C. option C 
D. Option D 

Show Answer

Question # 45

A. Create and apply a custom dashboard theme.
 B. Change the colors of the visuals in the report. 
C. Apply the Dark dashboard theme. 
D. Upload a snapshot image of the dashboard. 

Show Answer

Question # 46

A. Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month 
B. Merge Suppliers and Uneltems. 
C. Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).
D. Remove the Lineitems[Description] column.

Show Answer

Question # 47

Your organization has a team of power users who recently created 20 Power BI dashboards. The power users share the dashboards with other users in the organization. When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.) You need to ensure that all the users can access the dashboards. What should you do first?

A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user. 
B. From the Power BI Admin portal, modify the Privacy Settings. 
C. From the properties of each dashboard, modify the Share dashboard settings. 
D. Instruct each user to install Microsoft Office 2016. 

Show Answer

Question # 48

You attempt to connect Purer 81 Desktop to a Cassandra database. From the Get Data connector list you discover that there is no specific connector for the Cassandra database, You need to select an alternate data connector that will connect to the database. Which of connector should you choose? 

A. Microsoft SQL Server database 
B. ODBC 
C. OData 
D. OLE DB 

Show Answer

Question # 49

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset You need to ensure that the dataset can be refreshed in powefbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

 A. Text/CSV 
B. Folder 
C. Excel Workbook 
D. SharePoint folder 
E. Web 

Show Answer

Question # 50

You have a Power Bl query named Sates that imports the columns shown in the following table. Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTL Each correct selection is worth one pant.

A. Remove the rows in which sales [status] has a value of Canceled. 
B. Change the data type of sale [Delivery_Time] to Integer 
C. Removes (Canceled Date). 
D. Split Sales [Sale_Date] into separate date and time columns. 
E. Remove sales [Sales_Date]. 

Show Answer

Question # 51

For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing data. The solution must minimize development effort. Which type ol data source should you use? 

A. a SharePoint folder 
B. Power Bl dataflows 
C. an Excel workbook 
D. Power Bl dataset 

Show Answer

Question # 52

You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard. You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. 

A. Use quick insights on the dashboard. 
B. Hide the report page. 
C. Ask a question by using Q&A. 
D. Add the visual to the report. 
E. Pin the visual to the dashboard. 

Show Answer

Question # 53

The Date table is marked as a date table. DatelD is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use?

A. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID]) 
B. (SUM(‘Sales’[sales_amount]) - CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID]))) / CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID])) 
C. CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DateID])) 
D. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[DateID])) 

Show Answer

Question # 54

You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.) You need to modify the dashboard mobile layout to meet the following requirements: • Only show single-value visuals. • Minimize scrolling. What should you do?

A. Remove the card visual, increase the size of the map and bar chart visuals 
B. Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout. 
C. Move the bar chart visuals to the top of the layout Remove the map visuals. Decrease the size of the card visuals.
 D. Decrease the size of the card visuals. Remove the map and bar chart visuals. 

Show Answer

Question # 55

You need to create a Power 31 theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do? 

A. From Power Bl Desktop, customize the current theme, 
B. From power Bl Desktop, use a built in report theme. 
C. Create a theme as a JSON file and import the theme into Power Bl Desktop. 
D. Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop. 

Show Answer

Question # 56

You have a Power Bl report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards. What should you do?

 A. Add the Azure network security team as members of the RLS role. 
B. Instruct the Azure network security team to create security groups. Configure RLS to use the groups.
 C. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team. 
D. Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team. 

Show Answer

Question # 57

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:  The report will facilitate the following analysis: • The count of orders and the sum of total sales by Order Date • The count of customers who placed an order • The average quantity per order You need to reduce data refresh times and report query times. Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

A. Fillet the data to only the NorthWest region sales territory. 
B. Remove the CustomerKey and ProductKey columns. 
C. Remove the TaxAmt and Freight columns. 
D. Set the data type for SatesOrderNumber to Decimal Number 

Show Answer

Question # 58

You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns: • Customer ID • Customer Name • Phone • Email Address • Address ID Address contains the following columns: • Address ID • Address Line 1 • Address Line 2 • City • State/Region • Country • Postal Code Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?

A. Append the Customer and Address tables. 
B. Transpose the Customer and Address tables. 
C. Group the Customer and Address tables by the Address ID column. 
D. Merge the Customer and Address tables. 

Show Answer

Question # 59

You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that bar chart displays on Dashboard1. What should you do?

A. Edit the details for the dashboard tile of Dashboard1. 
B. Select Refresh visuals for Dashboard1. 
C. the Sales by month bar chart to Dashboard1 
D. Refresh the dataset used by Report1 and Dashboard1. 

Show Answer

Question # 60

You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled. No anomalies ate detected You need to increase the likelihood that anomaly detection will identify anomalies in the report. What should you do? 

A. Add a data field to the Secondary values field weft 
B. Increase the Sensitivity setting. 
C. Increase the Expected range transparency setting, 
D. Add a data field to the Legend field well

Show Answer

Question # 61

You build a Power Bi report that displays loT temperature data streaming from a refrigerator. You publish the report to the Power BI service. You need to be notified when the temperature rises above four degrees Celsius. What should you do?

 A. Set an alert on a KPI visual in the report.
 B. Pin a card visual to a dashboard and create a subscription. 
C. Pin a card visual to a dashboard and set an alert on the tile. 
D. Pin a report page to a dashboard and set an alert on the page. 

Show Answer

Question # 62

You have more than 100 published datasets. Ten of the datasets were verified to meet your corporate quality standards. You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do? 

A. Publish the datasets in an app. 
B. Promote the datasets. 
C. Feature the dataset on the home page. 
D. Certify the datasets. 

Show Answer

Question # 63

You use Power 81 Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error.  You need to resolve the error. What are two ways to achieve the goal? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point. 

A. Split long running queries into subsets Of columns and use power Query to the queries 
B. Disable query folding on long running queries 
C. Reduce number of rows and columns returned by each query. 
D. Use Power Query to combine long running queries into one query. 

Show Answer

Question # 64

You are creating a Power Bl report by using Power Bi Desktop. You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals. Which type of visual should you use? 

A. key influencers 
B. decomposition tree 
C. Q&A 
D. smart narrative 

Show Answer

Question # 65

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection' 

A. import that uses a Microsoft account
 B. DirectQuery that uses the end-user s credentials 
C. DirectQuery that uses a database credential 
D. Import that uses a database credential

Show Answer

Question # 66

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to return to it. Asa result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You enable included in app for all assets. Does this meet the goal?

A. Yes 
B. No 

Show Answer

Question # 67

You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design. What should you use?

A. comments 
B. tiles 
C. Microsoft Information Protection sensitivity labels 
D. Active Directory groups 

Show Answer

Question # 68

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

A. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace. 
B. Publish the reports to a different workspace other than the one hosting the datasets. 
C. Publish the reports in an app and grant the HR managers access permission. 
D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets. 

Show Answer

Question # 69

You have an on-premises Power BI Report Server. You plan to create a report in Power BI Desktop and publish the report to the report server. Which data source should the report use?

A. Microsoft Azure SQL Database 
B. a Microsoft SQL Server database 
C. a Microsoft SQL Server Analysis Services (SSAS) database 
D. Microsoft Excel 

Show Answer

Question # 70

You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the dashboard. You need to provide users with sample questions that they can ask when using Q&A. Which settings should you modify from the Power BI Settings?

A. Subscriptions 
B. Dashboards 
C. Datasets 
D. Workbooks 

Show Answer

Question # 71

You are developing a sales report that will have multiple pages. Each page will answer a different business question. You plan to have a menu page that will show all the business questions.You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work whendeployed to any workspace. What should you include on the menu page?

A. Create a text box for each business question and insert a link. 
B. Create a button for each business question and set the action type to Bookmark. 
C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions. 

Show Answer

Question # 72

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

A. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column. 
B. From Power Bi Desktop, use the Auto date/time option when creating the reports. 
C. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table. 
D. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column 

Show Answer

Question # 73

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do?

A. Create a new aggregation that summarizes by employee. 
B. Create a new group on the state column and set the Group type to List. 
C. Create a new group on the state column and set the Group type to Bin. 
D. Create a new aggregation that summarizes by state. 

Show Answer

Question # 74

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. Allthe manufacturing reports have the same data structure. You need to load only the manufacturing reports to a table for analysis. What should you do in Microsoft Power Bl Desktop?

A. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load. 
B. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library. 
C. Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library. 
D. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load. 

Show Answer

Question # 75

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace. You need to grant all organizational users read access to a dashboard and several reports. Solution: You assign all the users the Viewer role to the workspace. Does this meet the goal?

A. Yes 
B. No 

Show Answer