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
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
