Pass PL-300 Exam in First Attempt Guaranteed 100% Cover Real Exam Questions [Apr-2023]
Valid PL-300 test answers & Microsoft PL-300 exam pdf
NEW QUESTION # 48
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. Split the Date column into two columns, one that contains only the time and another that contains only the date.
- C. Change the data type of the Date column to Text.
- D. Trim the Date column.
Answer: B
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 # 49
You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? 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:
Explanation
Scenario: Revenue projections are set at the monthly level and summed to show projections for the quarter.
Box 1: IF
Box 2: ISFILTERED
ISFILTERED returns TRUE when columnName is being filtered directly. If there is no filter on the column or if the filtering happens because a different column in the same table or in a related table is being filtered then the function returns FALSE.
Box 3: SUM
Reference:
https://docs.microsoft.com/en-us/dax/isfiltered-function-dax
NEW QUESTION # 50
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? 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 - From Power BI Desktop, publish the dataset to powerbi.com
2 - From Power BI Desktop, create four roles.
3 - From Power BI Desktop, add a Table Filter DAX Expression to the roles.
4 - From powerbi.com, add role members to the roles.
NEW QUESTION # 51
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 the date foreign keys.
Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
Explanation:
Creating two additional tables in Power Query can be a possible solution:
Remove any inactive relationships.
Consider renaming the role-playing dimension-type table to better describe its role. In the example, the Airport table is related to the ArrivalAirport column of the Flight table, so it's renamed as Arrival Airport.
Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query.
In the example, the Departure Airport table was created by using the following calculated table definition.
NEW QUESTION # 52
You need to create a Power Bl report. The first page or 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.
Answer:
Explanation:
NEW QUESTION # 53
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? 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/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax
NEW QUESTION # 54
You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
- A. Apply the parse function from the Date transformations options to the Logged column.
- B. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
- C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
- D. Create a column by example that starts with 2018-12-31.
Answer: B
NEW QUESTION # 55
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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power Bl service.
Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 56
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: The Viewer role to the workspace
The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can't browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to "Members can only view Power BI content".
Box 2: Build
The analysts must be able to build new reports from the dataset that contains the profit and loss data.
Scenario: The reports must be made available to the board from powerbi.com.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Reference:
https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html
NEW QUESTION # 57
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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
Explanation:
Explanation
Instead modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
NEW QUESTION # 58
You have a Power Bl table named Customer that contains a field named Email Address.
You discover that multiple records contain the same email address.
You need to create a calculated column to identify which records have duplicate email addresses.
How should you complete the OAX expression for the calculated column? 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:
NEW QUESTION # 59
You have a folder that contains 100 CSV files.
You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.
Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.
NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Answer:
Explanation:
1 - From Power BI Desktop, select Get Data, and then select Folder.
2 - From Power Query Editor, expand the Attributes column.
3 - From Power Query Editor, combine the Content column.
NEW QUESTION # 60
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. Microsoft Information Protection sensitivity labels
- B. Active Directory groups
- 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 # 61
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
- A. Add a SQL statement.
- B. Set the Command timeout in minutes setting.
- C. Set Data Connectivity mode to DirectQuery.
- D. Set Data Connectivity mode to Import.
Answer: C
Explanation:
Explanation
With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
NEW QUESTION # 62
You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.
Which type of visualization should you use?
- A. key influencers
- B. Q&A
- C. decomposition tree
- D. funnel chart
Answer: A
Explanation:
The key influencers visual is a great choice if you want to:
See which factors affect the metric being analyzed.
Contrast the relative importance of these factors. For example, do short-term contracts affect churn more than long-term contracts?
Note: The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. For example, suppose you want to figure out what influences employee turnover, which is also known as churn. One factor might be employment contract length, and another factor might be commute time.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
NEW QUESTION # 63
You are creating a Power Bi model and report.
You have a single table in a data mode) named Product Product contains the following fields:
* ID
* Name
* Color
* Category
* Total Sales
You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.
How should you complete the DAX expression? To answer, drag the appropriate values to the coned 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.
Answer:
Explanation:
NEW QUESTION # 64
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 # 65
You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.
You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? 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/powerquery-m/text-replace
https://docs.microsoft.com/en-us/powerquery-m/text-end
NEW QUESTION # 66
You have a query that returns the data shown in the following exhibit.
You need to configure the query to display the data as shown in the following exhibit.
Which step should you use in the query?
- A. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes". Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")
- B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
- C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None), {"classes.1"})
- D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
Answer: B
Explanation:
Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.
Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot
NEW QUESTION # 67
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?
- A. line chart
- B. waterfall chart
- C. donut chart
- D. stacked area chart
Answer: A
Explanation:
A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time - a time series - thus the line is often drawn chronologically.
Example:
Incorrect Answers:
A: Stacked area charts are not appropriate to study the evolution of each individual group: it is very hard to substract the height of other groups at each time point.
Note: A stacked area chart is the extension of a basic area chart. It displays the evolution of the value of several groups on the same graphic. The values of each group are displayed on top of each other, what allows to check on the same figure the evolution of both the total of a numeric variable, and the importance of each group.
Reference:
https://www.data-to-viz.com/graph/line.html
NEW QUESTION # 68
You have two CSV files named Products and Categories.
The Products file contains the following columns:
ProductID
ProductName
SupplierID
CategoryID
The Categories file contains the following columns:
CategoryID
CategoryName
CategoryDescription
From Power BI Desktop, you import the files into Power Query Editor.
You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:
ProductID
ProductName
SupplierID
CategoryID
CategoryName
CategoryDescription
How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 69
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. Removes (Canceled Date).
- C. Remove sales [Sales_Date].
- D. Split Sales [Sale_Date] into separate date and time columns.
- E. Change the data type of sale [Delivery_Time] to Integer
Answer: A,D
NEW QUESTION # 70
You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure.
Measure1 = DISTINCTCOUNT(Sales[ProductID])
You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.
How should you configure the relationships? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 71
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Topic 3, Northwind Traders
Overview. General Overview
Northwind Traders is a specialty food import company.
The company recently implemented Power BI to better understand its top customers, products, and suppliers.
Overview. Business Issues
The sales department relies on the IT department to generate reports in Microsoft SQL Server Reporting Services (SSRS). The IT department takes too long to generate the reports and often misunderstands the report requirements.
Existing Environment
Data Sources
Northwind Traders uses the data sources shown in the following table.
Source2 is exported daily from a third-party system and stored in Microsoft SharePoint Online.
Existing Environment. Customer Worksheet
Source2 contains a single worksheet named Customer Details. The first 11 rows of the worksheet are shown in the following table.
All the fields in Source2 are mandatory.
The Address column in Customer Details is the billing address, which can differ from the shipping address.
Existing Environment. Azure SQL Database
Source1 contains the following table:
Orders
Products
Suppliers
Categories
Order Details
Sales Employees
The Orders table contains the following columns.
The Order Details table contains the following columns.
The address in the Orders table is the shipping address, which can differ from the billing address.
The Products table contains the following columns.
The Categories table contains the following columns.
The Suppliers table contains the following columns.
The Sales Employees table contains the following columns.
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
Requirements. Report Requirements
Northwind Traders requires the following reports:
Top Products
Top Customers
On-Time Shipping
The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.
The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category. The report must also show which suppliers provide the top products.
The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter Northwind Traders defines late orders as those shipped after the required shipping date.
The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%.
The reports must show historical data for the current calendar year and the last three calendar years.
Requirements. Technical Requirements
Northwind Traders identifies the following technical requirements:
A single dataset must support all three reports.
The reports must be stored in a single Power BI workspace.
Report data must be current as of 7 AM Pacific Time each day.
The reports must provide fast response times when users interact with a visualization.
The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.
Requirements. Security Requirements
Access to the reports must be granted to Azure Active Directory (Azure AD) security groups only. An Azure AD security group exists for each department.
The sales department must be able to perform the following tasks in Power BI:
Create, edit, and delete content in the reports.
Manage permissions for workspaces, datasets, and report.
Publish, unpublish, update, and change the permissions for an app.
Assign Azure AD groups role-based access to the reports workspace.
Users in the sales department must be able to access only the data of the sales region to which they are assigned in the Sales Employees table.
Power BI has the following row-level security (RLS) Table filter DAX expression for the Sales Employees table.
[EmailAddress] = USERNAME()
RLS will be applied only to the sales department users. Users in all other departments must be able to view all the data.
NEW QUESTION # 72
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 # 73
......
PL-300 Exam Questions – Valid PL-300 Dumps Pdf: https://www.pdftorrent.com/PL-300-exam-prep-dumps.html
Verified PL-300 dumps Q&As - Pass Guarantee: https://drive.google.com/open?id=1GR5LI8gQeYQdpk2BHerY3f31Z-8juf9X