Exam (elaborations)
PL- 300 MICROSOFT POWER BI DATA ANALYST PRACTICE QUESTIONS AND ANSWERS
- Course
- Institution
PL- 300 MICROSOFT POWER BI DATA ANALYST PRACTICE QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:99 Multiple choice questions
Term 1 of 99
You need to add an analytics line to a visual. The value for the line must equal the result of a
DAX measure that always returns a consistent single value. The DAX measure must only be
used to populate the analytics line.
Which type of analytics line should you use?
Select only one answer.
Average line
Constant line
Max line
Min line
,Term 2 of 99
You need to prevent hidden date tables from being auto generated by Power BI Desktop for
every date or datetime data type column in a dataset.
What two tasks should you perform? Each correct answer presents a complete solution
Select all answers that apply.
a. Enable Mark as date table for the Calendar table.
b. From the Current File options in Power BI Desktop, disable Auto Date/Time
c. From the Global options in Power BI Desktop, disable Auto Date/Time for new files.
d. Set the Data Category to None for all Date and DateTime fields.
a. Enable Mark as date table for the Calendar table.
b. From the Current File options in Power BI Desktop, disable Auto Date/Time
a. Create a column that contains the time values for the start of the hour of the Reading
Time value.
d. Use the Group By functionality to aggregate the rows by hour, DateKey, and
LocationKey and then create an average Temp C value per row.
c. Disable the Display option.
d. Enable the Current Page option.
e. Enable the Data option.
c. Enable the script visuals option in the Visualization pane of Power BI Desktop.
Term 3 of 99
You are creating a report in a Power BI Desktop by using a dataset that contains sales data.
You need to create a measure that always provides the value of total sales for the year 2022,
regardless of which year is selected in any visual in the same report.
Which DAX function should you use in combination with the SUM function to override the
context and provide the result?
Select only one answer.
CALCULATE
FILTER
IGNORE
SUMX
,Term 4 of 99
You have a Power BI dataset that gets data from a table in a SQL Server database.
From which view in Power BI Desktop can you modify the storage mode of the table?
Select only one answer.
Data view
Model view
Page view
Report view
, Term 5 of 99
You have a Power BI Desktop dataset that includes a table named Employees containing a row
for each employee with the following columns:
Employee ID
Employee Name
Manager ID
Manager Name
You need to flatten the parent-child hierarchy in the Employees table by adding an extra
column that will contain a listing of employee IDs for all direct and indirect managers of each
employee.
Which two Data Analysis Expression (DAX) functions should you use? Each correct answer
presents part of the solution.
Select all answers that apply.
a. PATHCROSSJOIN
b. EXCEPT PATHITEM
c. EXCEPTPATH
d. PATHITEM CROSSJOIN
e. RELATED
c. EXCEPTPATH
d. PATHITEM CROSSJOIN
a. Calculated column
b. Column
c. Measure
a. Add a blank page to the PBIX file.
d. Each slicer must use the same column.
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)
83662 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now