Use Real Microsoft Achieve the PL-300 Dumps - 100% Exam Passing Guarantee
Verified PL-300 Q&As - Pass Guarantee PL-300 Exam Dumps
The PL-300 certification exam consists of 40-60 multiple-choice questions, and candidates have two hours to complete the exam. To pass the exam, candidates must score at least 700 out of 1000 points. The exam is available in multiple languages, including English, French, German, Japanese, Korean, Portuguese, and Spanish.
NEW QUESTION # 133
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 a duplicate query named Airline.
- C. Add airline as a synonym of carrier.
- D. Rename the query from Carriers to airlines.
Answer: C
Explanation:
Add synonyms to tables and columns: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.
This step can be important. Even with straightforward table and column names, users of Q&A ask questions using the vocabulary that first comes to them. They're not choosing from a predefined list of columns. The more sensible synonyms you add, the better your users' experience is with your report.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices
NEW QUESTION # 134
DRAG DROP
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
Which three 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:
NEW QUESTION # 135
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. Create a theme as a JSON file and import the theme into Power Bl Desktop.
- B. Create a theme as a PBIVlZ 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,
Answer: C
NEW QUESTION # 136
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:
Explanation
NEW QUESTION # 137
HOTSPOT
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 138
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 D
- B. Option A
- C. Option B
- D. option C
Answer: C
NEW QUESTION # 139
You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?
- A. Round the hour of the Date column to startOfHour.
- B. Change the data type of the Date column to
- C. Split the Date column into two columns, one that contains only the time and another that contains only the date.
- D. Trim the Date column.
Answer: C
Explanation:
Explanation
We have to separate date & time tables. Also, we don't need to put the time into the date table, because the time is repeated every day.
Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.
Reference:
https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi
NEW QUESTION # 140
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/
NEW QUESTION # 141
You have a Power 31 data model that contains a table named Stores. The table has the following columns:
* Store Name
* Open Date
* Status
* State
* City
You need to create a calculated column named Active Store Name that meets the following requirements:
Answer:
Explanation:
NEW QUESTION # 142
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
- A. Select Column profile, and then select the sales_amount column.
- B. Select Column distribution.
- C. Select the sales_amount column and apply a number filter.
- D. Transform the sales_amount column to replace negative values with 0.
Answer: A
Explanation:
Topic 1, Litware, Inc.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
* Executives require a visual that shows sales by region.
* Regional managers require a visual to analyze weekly sales and returns.
* Sales managers must be able to see the sales data of their respective region only.
* The sales managers require a visual to analyze sales performance versus sales targets.
* The sale department requires reports that contain the number of sales transactions.
* Users must be able to see the month in reports as shown in the following example: Feb 2020.
* The customer service department requires a visual that can be filtered by both sales month and ship month independently.
NEW QUESTION # 143
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
Answer: A
NEW QUESTION # 144
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 145
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/allselected-function-dax
NEW QUESTION # 146
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
NEW QUESTION # 147
You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.
You are creating a Power Bl dashboard that will include two visuals from each report You need to use a consistent dark theme for the dashboard. The solution must preserve the 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. When pinning visuals to the dashboard, select Use destination theme.
- B. Turn on tile flow.
- C. For the browser, set the color preference to dark mode.
- D. Select the dark dashboard theme.
- E. Upload a snapshot.
Answer: A,C
NEW QUESTION # 148
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 149
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE; Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 150
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 # 151
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
NEW QUESTION # 152
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You add another table named Territory to the model. A sample of the data is shown in the following table.
You need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?
- A. Table.InDistinct
- B. Table.Distinct
- C. Table.RemoveMatchingRows
- D. Table.ReplaceMatchingRows
Answer: B
NEW QUESTION # 153
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
NEW QUESTION # 154
......
Check the Free demo of our PL-300 Exam Dumps with 297 Questions: https://www.itpassleader.com/Microsoft/PL-300-dumps-pass-exam.html
Clear your concepts with PL-300 Questions Before Attempting Real exam: https://drive.google.com/open?id=1CatMc5WVEGMYYOI3p0n82thpmrBf2lBY