[Aug-2022] Microsoft Certified: Power BI Data Analyst Associate PL-300 Exam Practice Test Questions Dumps Bundle!
2022 Updated PL-300 PDF for the PL-300 Tests Free Updated Today!
NEW QUESTION 32
Which DAX expression should you use to get the ending balances in the balance sheet reports?
- A. CALCULATE (
MAX( BalanceSheet[BalanceAmount] ),
LASTDATE( 'Date' [Date] )
) - B. CALCULATE (
SUM( BalanceSheet [BalanceAmount] ),
LASTDATE( 'Date'[Date] )
) - C. CALCULATE (
SUM( BalanceSheet [BalanceAmount] ),
DATESQTD( 'Date'[Date] )
) - D. FIRSTNONBLANK ( 'Date' [Date]
SUM( BalanceSheet[BalanceAmount] )
)
Answer: C
Explanation:
Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.
Reference:
https://docs.microsoft.com/en-us/dax/datesqtd-function-dax
NEW QUESTION 33
Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
- B. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
- C. a ribbon chart that shows balances by quarter and accounts in the legend.
- D. a pie chart that shows balances by account category without filters.
- E. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.
Answer: B,C
Explanation:
Explanation
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a
NEW QUESTION 34
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 35
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
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:
1 - Create a blank query a sa data soure.
2 - Specify the following query, then close and apply.,,,,,
3 - Create a visual for the query table.
NEW QUESTION 36
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
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:
NEW QUESTION 37
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? 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 38
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:
Reference:
https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/
NEW QUESTION 39
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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:
Answer as selected.
NEW QUESTION 40
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? 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-query/append-queries
NEW QUESTION 41
You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?
- A. scatterplot
- B. bar chart
- C. pie chart
Answer: B
Explanation:
Scenario: 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 Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.
The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.
Reference:
https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi
NEW QUESTION 42
You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
What should you do?
- A. Add a description of "Subscriber" to the Customer table.
- B. Set Summarize By to None for the CustomerlD column.
- C. Add a description of "subscriber count" to the Customer Count measure.
- D. Add a synonym of "subscriber" to the Customer table.
Answer: B
Explanation:
Explanation
You can add synonyms to tables and columns.
Note: 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 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.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices
NEW QUESTION 43
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 44
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 45
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)
The related dimension tables are imported into the model.
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:
Explanation
Reference:
https://finance-bi.com/power-bi-basket-analysis/
NEW QUESTION 46
You have a Power Bl report.
You have the following tables.
You have the following DAX measure.
Answer:
Explanation:
Explanation
NEW QUESTION 47
In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?
- A. From Power BI Desktop, configure the Report settings for the current file.
- B. From Power BI Desktop, modify the data source permissions.
- C. From Power BI Desktop, configure the Data Load settings for the current file.
- D. From the Power BI service, configure the dataset permissions.
Answer: D
NEW QUESTION 48
You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.) You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit. (Click the Mobile tab.) What should you do? To answer, select the appropriate options m the answer area NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Answer as selected
NEW QUESTION 49
You have the dashboard shown in the following exhibit.
You need to modify the dashboard to display as shown in the following exhibit.
What should you do?
- A. Create and apply a custom dashboard theme.
- B. Change the colors of the visuals in the report.
- C. Upload a snapshot image of the dashboard.
- D. Apply the Dark dashboard theme.
Answer: A
NEW QUESTION 50
DRAG DROP
You have a query named Customer that imports CSV files from a data lake.
The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)
Each file contains deltas of any new or modified rows from each load to the data lake.
Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
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 51
......
Microsoft Power BI Data Analyst Exam Certification Details:
| Number of Questions | 40-60 |
| Books / Training | Course PL-300T00: Microsoft Power BI Data Analyst |
| Exam Price | $165 (USD) |
| Duration | 180 mins |
| Exam Name | Microsoft Certified - Power BI Data Analyst Associate |
| Exam Code | PL-300 |
| Passing Score | 700 / 1000 |
What are the steps to follow for the registration of the Microsoft Power BI Data Analyst Certification Exam
The steps to follow for the registration of the Microsoft Power BI Data Analyst Certification Exam are as follows:
After successful registration process, you will receive an email confirmation from Microsoft with all the details about your course including access code etc., which will be sent to your registered email ID provided during registration process.
You will see a list of courses that are available on this website. Select “Microsoft Power BI Data Analyst Certification Exam” and click on “Enroll Now” button.
Go to the official website of Microsoft, and click on “Microsoft Learning”.
The next step is to fill out your personal information such as name, email address, country and state city etc., which is mandatory to complete your registration process successfully.
Then you need to select your preferred payment method which includes credit card or PayPal account etc., and you will receive an email confirmation after successful payment using your credit card or PayPal account etc.
Fully Updated Dumps PDF - Latest PL-300 Exam Questions and Answers: https://www.prep4surereview.com/PL-300-latest-braindumps.html
100% Free PL-300 Exam Dumps to Pass Exam Easily: https://drive.google.com/open?id=1xnfZVC9DtmWP6LTnzQHRYWipV2Sfw4Lr
