Exam (elaborations)
PL-300 PART 8 QUESTIONS AND ANSWERS
- Course
- Institution
PL-300 PART 8 QUESTIONS AND ANSWERS
[Show more]
Seller
Follow
Content preview
PL-300 PART 8 QUESTIONS AND ANSWERS2024 -2025
Users must be able to see the month in reports as shown in the following example: Feb 2020.
A. FORMAT('Date'[date], "MMM YYYY")
B. FORMAT('Date' [date], "M YY")
C. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#") D. FORMAT('Date' [date_id],
"MMM YYYY") ANS - A. FORMAT('Date'[date], "MMM YYYY")
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data
for negative sales amounts. You need to review the data for which there are concerns before creating
the data model. What should you do in Power Query Editor?
A. Transform the sales_amount column to replace negative values with 0.
B. Select Column distribution.
C. Select the sales_amount column and apply a number filter.
D. Select Column profile , and then select the sales_amount column. ANS - D. Select Column profile ,
and then select the sales_amount column.
The Column profile feature provides a more in-depth look at the data in a column. It contains a column
statistics chart that displays Count, Error, Empty, Distinct, Unique, Empty String, Min, & Max of the
selected column.
Data for the reports comes from three sources. Detailed revenue, cost, and expense data comes from an
Azure SQL database. Summary balance sheet data comes from Microsoft Dynamics 365 Business
Central. The balance sheet data is not related to the profit and loss results, other than they both relate
to dates. Monthly revenue and expense projections for the next quarter come from a Microsoft
SharePoint Online list. Quarterly projections relate to the profit and loss results by using the following
shared dimensions: date, business unit, department, and product category.
What is the minimum number of Power BI datasets needed to support the reports?
,A. two imported datasets
B. a single DirectQuery dataset
C. two DirectQuery datasets
D. a single imported dataset ANS - A. two imported datasets
A single dataset must support all three reports:
- 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 data model must minimize the size of the dataset as much as possible, while meeting the report
requirements and the technical requirements.
You need to design the data model to meet the report requirements. What should you do in Power BI
Desktop?
A. From Power Query, use a DAX expression to add columns to the Orders table to calculate the
calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar
quarter of the ShippedDate column, and the calendar month of the ShippedDate column.
B. From ANS - B. From Power Query, add columns to the Orders table to calculate the calendar quarter
and the calendar month of the OrderDate column.
Use Power Query to calculate calendar quarter and calendar month.
You open a query in Power Query Editor. You need to identify the percentage of empty values in each
column as quickly as possible. Which Data Preview option should you select?
A. Show whitespace
B. Column profile
C. Column distribution
D. Column quality ANS - D. Column quality
,Column quality: In this section, we can easily see valid, Error and Empty percentage of data values
associated with the Selected table.
You have a prospective customer list that contains 1,500 rows of data. The list contains the following
fields:
- First name
- Last name
- Email address
- State/Region
- Phone number
You import the list into Power Query Editor. You need to ensure that the list contains records for each
State/Region to which you want to target a marketing campaign. Which two actions should you
perform?
A. Open the Advanced Editor
B. Select Column quality
C. Enable Column profiling based on entire dataset
D. Select Column distribution
E. Select Column profile ANS - D. Select Column distribution
E. Select Column profile
You have an API that returns more than 100 columns. The following is a sample of column names.
- client_notified_timestamp
- client_notified_source
- client_notified_sourceid
- client_notified_value
-client_responded_timestamp
-client_responded_source
, -client_responded_sourceid
-client_responded_value Y
ou plan to include only a subset of the returned columns. You need to remove any columns that have a
suffix of sourceid. How should you complete the Power Query M code?
Box 1:
- Table.CombineColumn
- Table.FindText
- Table.FromList
- Table.RemoveColumns
Box 2:
- List.Contains
- List.Select
- Table.FindText
- Table.FromList
Box 3:
- Text.Contains
- Text.EndsWith
- Text.From
- Text.StartsWith ANS - Box 1: Table.RemoveColumns
(When you do "Remove Columns" Power Query uses the Table.RemoveColumns function)
Box 2: List.Select
(Get a list of columns)
Box 3: Text.Contains
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Professorkaylee. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now