Microsoft PL-300 Dumps Questions Answers

Microsoft PL-300 Dumps

Dumps4download providing 100% reliable Exam dumps that are verified by experts panel. Our Dumps4download PL-300 study material are totally unique and exam questions are valid all over the world. By using our PL-300 dumps we assure you that you will pass your exam on first attempt. You can easily score more than 97%.

100% exam passing Guarantee on your purchased exams.

100% money back guarantee if you will not clear your exam.

Microsoft PL-300 Practice Test Helps You Turn Dreams To Reality!

IT Professionals from every sector are looking up certifications to boost their careers. Microsoft being the leader certification provider earns the most demand in the industry.

The Microsoft Certification is your short-cut to an ever-growing success. In the process, Dumps4download is your strongest coordinator, providing you with the best PL-300 Dumps PDF as well as Online Test Engine. Let’s steer your career to a more stable future with interactive and effective PL-300 Practice Exam Dumps.

Many of our customers are already excelling in their careers after achieving their goals with our help. You can too be a part of that specialized bunch with a little push in the right direction. Let us help you tread the heights of success.

Apply for the PL-300 Exam right away so you can get certified by using our Microsoft Dumps.

Bulk Exams Package

Dumps4download Leads You To A 100% Success in First Attempt!

Our PL-300 Dumps PDF is intended to meet the requirements of the most suitable method for exam preparation. We especially hired a team of experts to make sure you get the latest and compliant PL-300 Practice Test Questions Answers. These questions are been selected according to the most relevance as well as the highest possibility of appearing in the exam. So, you can be sure of your success in the first attempt.

Interactive & Effective PL-300 Dumps PDF + Online Test Engine

Aside from our Microsoft PL-300 Dumps PDF, we invest in your best practice through Online Test Engine. They are designed to reflect the actual exam format covering each topic of your exam. Also, with our interactive interface focusing on the exam preparation is easier than ever. With an easy-to-understand, interactive and effective study material assisting you there is nothing that could go wrong. We are 100% sure that our PL-300 Questions Answers Practice Exam is the best choice you can make to pass the exam with top score.

How Dumps4download Creates Better Opportunities for You!

Dumps4download knows how hard it is for you to beat this tough Microsoft Exam terms and concepts. That is why to ease your preparation we offer the best possible training tactics we know best. Online Test Engine provides you an exam-like environment and PDF helps you take your study guide wherever you are. Best of all, you can download PL-300 Dumps PDF easily or better print it. For the purpose of getting concepts across as easily as possible, we have used simple language. Adding explanations at the end of the PL-300 Questions and Answers Practice Test we ensure nothing slips your grasp.

The exam stimulation is 100 times better than any other test material you would encounter. Besides, if you are troubled with anything concerning Microsoft Power BI Data Analyst Exam or the PL-300 Dumps PDF, our 24/7 active team is quick to respond. So, leave us a message and your problem will be solved in a few minutes.

Get an Absolutely Free Demo Today!

Dumps4download offers an absolutely free demo version to test the product with sample features before actually buying it. This shows our concern for your best experience. Once you are thoroughly satisfied with the demo you can get the Microsoft Power BI Data Analyst Practice Test Questions instantly.

24/7 Online Support – Anytime, Anywhere

Have a question? You can contact us anytime, anywhere. Our 24/7 Online Support makes sure you have absolutely no problem accessing or using Microsoft Power BI Data Analyst Practice Exam Dumps. What’s more, Dumps4download is mobile compatible so you can access the site without having to log in to your Laptop or PC.

Features to use Dumps4download PL-300 Dumps:

• Thousands of satisfied customers.
• Good grades are 100% guaranteed.
• 100% verified by Experts panel.
• Up to date exam data.
• Dumps4download data is 100% trustworthy.
• Passing ratio more than 99%
• 100% money back guarantee.

Microsoft PL-300 Frequently Asked Questions

Microsoft PL-300 Sample Questions

Question # 1

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports Solution: In Microsoft Azure Active Directory (Azure AD), part of Microsoft Entra. you create a group that contains all the users. You share each selected report and the one dashboard to the group. Does this meet the goal?

A. Yes 
B. No 

Show Answer

---

Question # 2

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

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

Show Answer

---

Question # 3

You have a Power Bl app that contains a report named Report1. You add a new page to Report1. You need to ensure that users can view the new page. The solution must minimize administrative effort. What should you do? 

A. Update the audience in the app. 
B. Update the app. 
C. Update the contact information in the app
D. Unpublish and create a new app. 

Show Answer

---

Question # 4

A user creates a Power B1 report named ReportA that uses a custom theme You create a dashboard named DashboardA. You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. From DashboardA upload a JSON theme. 
B. Publish ReportA to the Microsoft Power B1 Community theme gallery. 
C. From DashboardA create a custom theme. 
D. From ReportA save the current theme. 
E. Publish ReportA to Power Bl. 

Show Answer

---

Question # 5

You have a Microsoft Excel file on a file server. You create a Power BI report and import a table from the Excel file. You publish the report. You need to ensure that the data refreshes every four hours. What should you do first?

A. Upload the Excel file to a Power BI workspace.
 B. Create a subscription to the report. 
C. Deploy an on-premises data gateway. 
D. Edit the data source credentials. 

Show Answer

---

Question # 6

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an on-premises data gateway. You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode. Solution: You create aggregations to summarize results. Does this meet the goal?

A. Yes 
B. No 

Show Answer

---

Question # 7

You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You change the semantic model mode. Does this meet the goal?

A. Yes 
B. No 

Show Answer

---

Question # 8

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 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 SQL database data source. The sales table has the following date foreign keys: • Due Date • Order Date • Delivery Date You need to support the analysis of sales over time based on all three dates at the same time. Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table. Does this meet the goal?

A. Yes 
B. No 

Show Answer

---

Question # 9

You have a semantic model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns: • Date • Product • SalesAmount You need to create a DAX measure for a rolling 31 -day sales total that will return the total sales amount for a selected date and the previous 30 days. Which DAX expression should you use?

A. CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date],Max('Date'[Date])-36, Max('Date'[Date])))
B. CALCUlATE(SUM<Sales[SalesAmountJ), 0ATEA00(Date[Date], -36, DAY))
C. CALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)
D. CALCULATE(SUM(Sales[SalesAmount]), DATESHTD(Date[Date]))

Show Answer

---

Question # 10

Vou plan to create a Power B1 report that will be connected to multiple data sources. One of the data sources contains law records. You need to ensure that other queries cannot access the tax record Information. To what should you set Privacy Level for the data source?

A. None 
B. Private 
C. Organizational 
D. Public 

Show Answer

---

Question # 11

You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You Normalize casing in the source query or Power Query Editor. Does this meet the goal?

A. Yes 
B. No

Show Answer

---

Question # 12

You have a Power BI data model that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys. •Due Date •Order Date •Delivery Date You need to support the analysis of sales over time based on all three dates at the same time. Solution: From the Data pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Deliver Date as calculated tables. You create active relationships between the sales table and each date table. Does this meet the goal?

A. Yes
 B. No 

Show Answer

---

Question # 13

From Power BI Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

A. From Power Bl Desktop, change the Row-Level Security settings. 
B. From Power Bl Desktop, import a table that contains the HR team members 
C. From powerbi.com.add users to the HR role for the dataset. 
D. From powerbi.com, share the dataset to the HR team members. 

Show Answer

---

Question # 14

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 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 data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue. Solution: You implicitly convert the values into the required type. Does this meet the goal?

A. Yes 
B. No 

Show Answer

---

Question # 15

You need to create the semantic model. Which storage mode should you use for the tables in the semantic model?

A. live connection 
B. Dual 
C. Import 
D. DirectQuery

Show Answer

---

Question # 16

You need to minimize the size of the semantic model. The solution must meet the report requirements. What should you do?

A. Filter out discontinued products while importing the Products table. 
B. Group the Categories table by the CategorylD column.
 C. Change the OrderlD column in the Orders table to the Text data type. 
D. Remove the QuantityPerUnit column from the Products table. 

Show Answer

---

Question # 17

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table. You need to combine the tables into a single query that contains the unique columns of each table. What should you select in Power Query Editor?

A. Merge queries 
B. Append queries 
C. Combine files

Show Answer

---

Question # 18

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality?

A. One to one 
B. Many to one 
C. One to many 
D. Many to many 

Show Answer

---

Question # 19

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort. What should you do? 

A. From each report in powerbi.com. select Refresh visuals 
B. From Power Bl Desktop, download the PBIX file and refresh the data. 
C. Configure a scheduled refresh without using an on-premises data gateway. 
D. Configure a scheduled refresh by using an on-premises data gateway

Show Answer

---

Question # 20

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives? 

A. Apply row-level security (RLS) to the Region table based on the sales manager username. 
B. Configure a bi-directional relationship between Region and Sales.Region. 
C. Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column. 
D. In the Region table, create a hierarchy that has the manager name, and then the sales manager name. 

Show Answer

---

Question # 21

From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they view reports based on the dataset. What should you do?

A. From Power Bl Desktop, change the Row-Level Security settings. 
B. From Power Bl Desktop, import a table that contains the HR team members 
C. From powerbi.com.add users to the HR role for the dataset. 
D. From powerbi.com, share the dataset to the HR team members. 

Show Answer

---

Question # 22

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select?

A. Microsoft Teams Personal Analytics 
B. SQL Server database 
C. Dataverse 
D. Dataflows 

Show Answer

---

Question # 23

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data In DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user. What should you do?

A. Share RPT1 with the user. 
B. Add the user as a Viewer of Workspace1. 
C. Add the user as a member of Workspace1. 
D. Grant the Build permission for DS1 to the user. 

Show Answer

---

Question # 24

You have a Power Bl model that contains two tables named Population and Date. The Population table contains two columns named Population Amount and Date Key. DateKey contains date values that represent the first day of a year and are used to create a many-to The Power Bl model contains two measures that have the following definitions. Total Population = Sum ('Population'[Population Amount]) 2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023) You create a table visual that displays Date[Year] and [2023 Population]. What will the table visual show?

A. one row per year that contains blank values for every year except 2023 
B. one row per date that contains the population value for the corresponding year repeated in each row 
C. a single row for the year 2023 that contains the related population value 
D. one row per year that contains the same value repeated for each year 

Show Answer

---

Question # 25

You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns: • Date • Fiscal year • Fiscal Quartet • Month Name • Calendar Year • Week Number • Month Number • Calendar Quarter You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

A. DATATABLE 
B. ADDCOLUMS 
C. SUMMARIZE 
D. CALCULATE 

Show Answer

---

Question # 26

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

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

Show Answer

---

Question # 27

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 # 28

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 # 29

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 # 30

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 # 31

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 # 32

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 # 33

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 # 34

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 # 35

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 # 36

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 # 37

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 # 38

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 # 39

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 # 40

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 # 41

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

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 # 43

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 # 44

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 # 45

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 # 46

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 # 47

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 # 48

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 # 49

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 # 50

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 # 51

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 # 52

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 # 53

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 # 54

You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals: Switch the measures used in the visuals. Change the visualization type. Add a legend. The solution must minimize development effort. What should you do?

A. Enable personalization for each Visual.
B. Create a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart 
C. Edit the interactions between the three visuals. 
D. Enable personalization for the report 

Show Answer

---

Question # 55

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 # 56

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

---

Testimonials