PL-300 Dumps are Available for Instant Access [2024]
Practice with these PL-300 dumps Certification Sample Questions
NEW QUESTION # 32
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. The solution must minimize changes to the data model.
What should you do?
- A. Rename the carrier column as airline in the Carriers query.
- B. Add airline as a synonym of carrier.
- C. Rename the query from Carriers to airlines.
- D. Add a duplicate query named Airline.
Answer: B
NEW QUESTION # 33
You have a report page that contains the visuals shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions
NEW QUESTION # 34
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/m-p/547054
NEW QUESTION # 35
You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements:
* Customer must be refreshed daily.
* Date must be refreshed once every three years.
* Sales must be refreshed in near real time.
* SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following requirements:
Answer:
Explanation:
NEW QUESTION # 36
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. OData
- B. Microsoft SQL Server database
- C. OLE DB
- D. ODBC
Answer: D
NEW QUESTION # 37
You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 38
You have the Power BI data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 39
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. Active Directory groups
- B. Microsoft Information Protection sensitivity labels
- C. tiles
- D. comments
Answer: B
Explanation:
Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate.
Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview
NEW QUESTION # 40
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. Remove the TaxAmt and Freight columns.
- B. Remove the CustomerKey and ProductKey columns.
- C. Fillet the data to only the NorthWest region sales territory.
- D. Set the data type for SatesOrderNumber to Decimal Number
Answer: A,C
NEW QUESTION # 41
You need to create a Power BI report. The first page of the report must contain the following two views:
*Sales By Postal Code
*Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.
The Sales By Month view must display a column chart visual as shown in the following exhibit.
Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views.
What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 42
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source.
The dashboard is shown in the exhibit. (Click the Exhibit tab.)
What occurred at 12:03:06 PM?
- A. A user pressed F5
- B. The dashboard tile cache refreshed.
- C. A new transaction was added to the data source.
- D. A user added a comment to a tile.
Answer: B
NEW QUESTION # 43
You have a Power Bl report.
You have the following tables.
You have the following DAX measure.
Answer:
Explanation:
NEW QUESTION # 44
You are creating a line chart in a Power Bl report as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 45
You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct
Answer:
Explanation:
1 - Configure an on-premises data gateway.
2 - Configure a scheduled refresh.
3 - Add a data source.
4 - Add the dataset owner to the data source.
NEW QUESTION # 46
You have a report in Power BI Desktop as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Note: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Graphical user interface, text Description automatically generated with medium confidence
NEW QUESTION # 47
You are creating reports in Power BI Desktop. The model has the following tables.
There is a relationship between the tables.
You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.
You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.
How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 48
You have a Power Bi report for the procurement department. The report contains data from the following tables.
There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.
You need to minimize the size of the dataset without affecting the visuals. What should you do?
- A. Remove the Lineitems[Description] column.
- 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 rows from Lineitems where LineItems[invoice Date] is before the beginning of last month
Answer: A
NEW QUESTION # 49
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.
You need to prepare the data to support the following:
Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
1 - Transpose the table
2 - Unpivot all the columns other than Measure
3 - Rename the Measure column as Year
4 - Change the data type of the Year column to Date
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
NEW QUESTION # 50
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. 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 report page to a dashboard and set an alert on the page.
- D. Pin a card visual to a dashboard and set an alert on the tile.
Answer: C
NEW QUESTION # 51
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
- A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
- B. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.
- C. Add the Weekly_Returns data to the Sales table by using related DAX functions.
Answer: A
Explanation:
Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.
NEW QUESTION # 52
You have the Power BI data model shown in the following exhibit.
Select the appropriate yes or no.
Answer:
Explanation:
Explanation
Graphical user interface, text, application, email Description automatically generated
NEW QUESTION # 53
......
Get Instant Access REAL PL-300 DUMP Pass Your Exam Easily: https://pass4sure.guidetorrent.com/PL-300-dumps-questions.html