Exam (elaborations)
PL-300 MICROSOFT POWER BI DATA ANALYST PART 1 QUESTIONS AND ANSWERS
- Course
- Institution
PL-300 MICROSOFT POWER BI DATA ANALYST PART 1 QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:90 Multiple choice questions
Definition 1 of 90
You have a CSV file that contains user complaints.
The file contains a column named Logged.
Logged contains the date and time each complaint occurred.
The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date
hierarchy.
What should you do?
Change the data type of the Logged column to Date.
Apply the Parse function from the Date transformations options to the Logged column.
Create a column by example that starts with 2018-12-31 and set the data type of the new
column to Date.
Apply a transform to extract the first 11 characters of the Logged column.
Definition 2 of 90
Which technology improves performance by generating a single query statement to retrieve
and transform source data?
Query folding
Adding index columns
Adding custom columns with complex logic
Definition 3 of 90
Which of the following sources can Power BI connect to?
SQL Database
Google Analytics
R scripts
All of the above
,Definition 4 of 90
You have sales data in a star schema that contains four tables named Sales, Customer, Date,
and Product. The Sales table contains purchase and ship dates. Most often, you will use the
purchase date to analyze the data, but you will analyze the data by both dates independently
and together.
You need to design an imported dataset to support the analysis. The solution must minimize
the model size and the number of queries against the data source.
Which data modeling design should you use?
Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date
table.
Duplicate the Date query in Power Query and use active relationships between both
Date tables.
On the Date table, use a reference query in Power Query and create active relationships
between Sales and both Date tables in the modeling view.
Create an active relationship between Sales and Date for the purchase date and an
inactive relationship for the ship date.
Definition 5 of 90
When should you use DirectQuery?
The source data never changes
Company policy states no data source restrictions
Dataset is too large to be stored in-memory
All of the above
,Definition 6 of 90
You have the following three versions of an Azure SQL database:
Test
Production
Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the
development, test, and production database servers from powerbi.com.
Which should you do?
Create a JSON file that contains the database server names. Import the JSON file to the
dataset.
Create a parameter and update the queries to use the parameter.
Create a query for each database server and hide the development tables.
Set the data source privacy level to Organizational and use the ReplaceValue Power
Query M function.
Definition 7 of 90
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 can damage the structure of the data model.
Deleting unnecessary rows and columns will reduce the dataset size and it is a good
practice to load only necessary data into your data model.
Definition 8 of 90
Based on the conditional column above, what Price Range value would be given to a
Unit_Price of 500?
Low
Mid
High
Unclassified
, Definition 9 of 90
Data profiling is defined as what?
Aggregating columns containing numeric data
Studying the nuances of the data
Data modeling
Definition 10 of 90
During your data QA process, you notice that there are null values in the Return type column
(Returned, No return, and null).
After talking with your manager, you decide to impute (replace) the null values with a value of
"No return".
Which of the following actions should you take?
Select the Return type column > Transform > Replace values
Select the Return type column > Transform > Fill down
Select the Return type column > Add column > Column from example
Select the Return type column > Home > Remove rows
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)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now