Exam (elaborations)
PL-300 MICROSOFT PRACTICE QUESTIONS AND ANSWERS
- Course
- Institution
PL-300 MICROSOFT PRACTICE QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:49 Multiple choice questions
Term 1 of 49
You plan to get data for a Power BI dataset from flat files.
You need a location type to store the files. The data must NOT automatically synchronize
between the original file and the dataset.
Which location type should you recommend?
Select only one answer.
local file
SharePoint - Team Sites
personal OneDrive account
OneDrive for Business
Term 2 of 49
You create a Power BI data source which uses a SQL SELECT statement. The SQL statement
queries multiple tables in a SQL Server database and includes subqueries.
After you import data from the data source into Power BI, you notice that one of the columns
in the resulting dataset appears blank. You verify that the source table does include data.
What should you do to resolve the issue?
Select only one answer.
Use the CAST function in the SQL statement.
Use the DATALENGTH function in the SQL statement.
Set the privacy levels on the data source.
Clear permissions on the data source in Power BI.
,Term 3 of 49
You plan to create a report in Power BI Desktop that will display sales opportunity by five sales
stages, including lead, prospect, qualified, committed, and transacted.
You need to identify the type of visualization that will display a linear process with sequentially
connected stages, with one stage transitioning to the next.
Which visualization should you use?
Select only one answer.
funnel
slicer
treemap
waterfall
,Term 4 of 49
You have Power BI Desktop.
You need to create data for your model items.
Data for which two model items can be created using the DAX language? Each correct answer
presents a complete solution.
Select all answers that apply.
calculated table
numeric range parameter
enter data tables
display folder
Use the Performance analyzer.
The Performance analyzer will show the query timings for each object on a report page.
Session diagnostics measures Power Query query performance as it relates to refresh
times. It is unrelated to measuring DAX performance or report page query timings. The
Best Practices analyzer reviews the model for best practices around things like model
design, relationships, field naming conventions, and measures. But is unrelated to any
query timings for report page visuals.
Review performance of measures, relationships, and visuals - Training | Microsoft Learn
CALCULATE
The CALCULATE function provides the result of the calculation with the ability to
override the context. The IGNORE function modifies the behavior of the
SUMMARIZECOLUMNS function by omitting specific expressions from the BLANK/NULL
evaluation. The FILTER function returns a table that represents a subset of another table
or expression. The SUMX function returns the sum of an expression evaluated for each
row in a table.
Use the Calculate function - Training | Microsoft Learn
calculated table
numeric range parameter
Calculated tables are generated with DAX queries. Numeric range parameters create a
table and measure, both generated with DAX queries. The enter data button creates a
manual table using the M language and Power Query. Display folders are a way to
visually organize measures, columns, or hierarchies. DAX is not used to create them.
Introduction to DAX - Training | Microsoft Learn
CALENDARAUTO
, The CALENDARAUTO function generates a range of dates based on the earliest and
latest date within the dataset. The CALENDAR function generates a range of dates, but it
requires providing the start and end date. The DATE function returns the specified date
in the datetime format. The DATEDIFF function returns an interval between two dates.
Create a date table - Training | Microsoft Learn
Term 5 of 49
In Power BI Desktop, you plan to use M-language to define a common date table spanning a
period of 10 years.
You need identify the M language function that would allow you to specify that rows in the
table should represent consecutive days within the date range you designated. Your solution
must minimize administrative effort.
Which syntax should you use?
Select only one answer.
#date
#duration
List.Combine
List.Durations
Term 6 of 49
You need to use DAX quick measures to generate results to use in a report.
Which type of DAX quick measure calculations will not work against a DirectQuery table?
Select only one answer.
mathematical operations
time intelligence
aggregate per category
X-functions
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 selftest. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now