Exam (elaborations)
MICROSOFT PL-300 EXAM STUDY GUIDE QUESTIONS AND ANSWERS
- Course
- Institution
MICROSOFT PL-300 EXAM STUDY GUIDE QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:24 Multiple choice questions
Term 1 of 24
Which of the following selections are not best practices for naming conventions in Power BI?
Rename columns to have spaces in them.
Abbreviate column names.
Replace values that have integers with human readable results.
Term 2 of 24
Do you need to import custom visuals each time you want to use them when you're
developing a new report, not an existing report?
No, custom visuals are always available for selection under the Visualization pane.
Yes, custom visuals must be imported from AppSource each time you start developing a
new report.
No, custom visuals only need to be imported once and will always remain in Power BI for
future use in a new report.
Term 3 of 24
What can you do to improve performance when you're getting data in Power BI?
Remove unnecessary columns and rows
Export database files to CSV to load
Combine date and time columns into a single column
Term 4 of 24
What is a risk of having null values in a numeric column?
That function SUM of data will be incorrect.
That function MAX of data will be incorrect.
That function AVERAGE of data will be incorrect.
,Term 5 of 24
What is cardinality?
Cardinality is the measure of unique values in a table.
Cardinality is the granularity of the data.
Cardinality is how long it takes for the data to load.
Cardinality is a type of visual element.
Term 6 of 24
Which one of the following options is the most important key benefit of data analysis?
Decisive analytics
Informed business decisions
Complex reports
Term 7 of 24
What is the difference between a fact table and a dimension table?
Fact tables contain observational data while dimension tables contain information about
specific entities within the data.
Fact tables contain information about specific entities while dimension tables contain
information about observational data.
There is no difference.
Dimension tables tell you about specific roles in Power BI while fact tables tell you
information about facts that are associated with those roles in Power BI.
Term 8 of 24
Which two functions will help you compare dates to the previous month?
CALCULATE and PREVIOUSMONTH
TOTALYTD and PREVIOUS MONTH
CALCULATE and TOTALTYD
, Term 9 of 24
Which data role enables advanced analytics capabilities specifically through reports and
visualizations?
Data scientist
Data engineer
Data analyst
Term 10 of 24
You're creating a Power BI report with data from an Azure Analysis Services MDX Cube. When
the data refreshes in the cube, you would like to see it immediately in the Power BI report. How
should you connect?
Import
T-SQL
Live connection
Term 11 of 24
What can be achieved by removing unnecessary rows and columns?
It is not necessary to delete unnecessary rows and columns and it is a good practice to
keep all metadata intact.
Deleting unnecessary rows and columns will reduce a dataset size and its good practice
to load only necessary data into your data model.
Deleting unnecessary rows and columns can damage the structure of the data model.
Term 12 of 24
When connecting to a SQL Server database to get data, what language should you use to
extract data?
DAX
T-SQL
MDX
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)
82191 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now