Exam (elaborations)
PL 300 POWER BI MS DATA ANALYST QUESTIONS AND ANSWERS
- Course
- Institution
PL 300 POWER BI MS DATA ANALYST QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:20 Multiple choice questions
Term 1 of 20
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
Term 2 of 20
What type of import error might leave a column blank?
Keep errors
Unpivot columns
Data type error
,Term 3 of 20
You plan to create several datasets by using the Power BI service. You have the files
configured as shown in the following table.
Data 1 - TSV
Data 2- XLSX
Data 3 - XML
Data 4 - CSV
Data 5 - JPG
You need to identify which files can be used as datasets. Which two files should you identify?
Data 1
Data 2
Data 3
Data 4
Data 5
Set Data Connectivity mode to DirectQuery.
(DirectQuery: No data is imported or copied into Power BI Desktop. For relational
sources, the selected tables and columns appear in the Fields list. For multi-dimensional
sources like SAP Business Warehouse, the dimensions and measures of the selected
cube appear in the Fields list. As you create or interact with a visualization, Power BI
Desktop queries the underlying data source, so you're always viewing current data.)
2 and 4
a) TSV is not supported via Power BI Service, and in question it clearly says "by using
Power BI Service".
b) XLSX 3 gb will not work for Pro licence, but it will work for Premium licence. In
question there is no mention about licence type so this option will work for some
customers, for some not. Partially correct.
c) XML is not supported via Power BI Service, and in question it clearly says "by using
Power BI Service".
d) CSV, same as xlsx 3gb, it will work for Premium licence. Partially correct.
e) JPG is not suported via Power BI Service.
For XML Table (.xml) or text (.txt) files, you must load that data into an Excel or Power BI
Desktop file first. You can then import the Excel or Power BI Desktop file into Power BI
Service.
There's a 1-GB limit for datasets stored in Shared capacities in the Power BI service. If you
need larger datasets, you can use Power BI Premium
To change data source values dynamically
(Parameters are a useful way to change data source values dynamically in Power Query.
These parameters are different from the "What-If" parameters created in the Power BI
Desktip front-end.)
, Data Gateway
(Data Gateways are required for on-premises data sources, like SSAS Tabular live
connections.)
Term 4 of 20
What is the Query Editor used for?
As a cloud-based storage option for your organization's data
To shape & transform data, then load it into Power BI
To create relationships between data and lookup tables
To create measures & calculated columns using DAX
Term 5 of 20
Which of the following sources lets users connect to a set of pre-wired connections?
PBIDS Files
JSON Files
Dataflows
SSAS Tabular
Term 6 of 20
Which query language do you use to extract data from Microsoft SQL Server?
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)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now