PL-300: Microsoft Power BI Data
Analyst part 1 Exam Questions &
Answers (Grade A+)
Which query language do you use to extract data from Microsoft
SQL Server?
DAX
T-SQL
MDX -
correct answer ✅T-SQL
T-SQL or Transact SQL is the query language specific to the
Microsoft SQL Server product. It can help perform operations like
retrieving the data from a single row, inserting new rows, and
retrieving multiple rows. It is a procedural language that is used by
the SQL Server.
You're creating a Power BI report with data from an Azure Analysis
Services Cube. When the data refreshes in the cube, you would like
to see it immediately in the Power BI report.
How should you connect?
,PL-300: Microsoft Power BI Data
Analyst part 1 Exam Questions &
Answers (Grade A+)
Connect Live
Import
Direct Query -
correct answer ✅Connect Live
"You're creating a Power BI report with data from an Azure Analysis
Services Cube."
Power BI Live Connection is a kind of connection in Power BI. It only
connects to three types of data sources (SQL Server Analysis
Services Multi-Dimensional, SQL Server Analysis Services Tabular,
Power BI Service Dataset).
These three types of data sources are based on SQL Server Analysis
Services (SSAS) technology.
What can you do to improve performance when you are getting
data in Power BI?
Only pull data into the Power BI service, not Power BI Desktop
,PL-300: Microsoft Power BI Data
Analyst part 1 Exam Questions &
Answers (Grade A+)
Use the Select SQL statement in your SQL queries when you are
pulling data from a relational database
Combine date and time columns into a single column
Do some calculations in the original data source -
correct answer ✅Do some calculations in the original data source
Calculations can improve performance by consolidating columns
and data types (i.e. strings vs. intgers).
Which storage mode leaves the data at the data source?
Import
Direct Query
Dual -
correct answer ✅Direct Query
, PL-300: Microsoft Power BI Data
Analyst part 1 Exam Questions &
Answers (Grade A+)
With DirectQuery, the data remains in its original source, and any
transformations you apply will impact the performance of your
report.
Import moves it.
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 -
correct answer ✅Query folding
Query Folding is the capability of a Power Query to create a single
statement that can transform and execute tasks (such as filtering a
thousand rows of data) on the data source side.
What type of import error might leave a column blank?
Analyst part 1 Exam Questions &
Answers (Grade A+)
Which query language do you use to extract data from Microsoft
SQL Server?
DAX
T-SQL
MDX -
correct answer ✅T-SQL
T-SQL or Transact SQL is the query language specific to the
Microsoft SQL Server product. It can help perform operations like
retrieving the data from a single row, inserting new rows, and
retrieving multiple rows. It is a procedural language that is used by
the SQL Server.
You're creating a Power BI report with data from an Azure Analysis
Services Cube. When the data refreshes in the cube, you would like
to see it immediately in the Power BI report.
How should you connect?
,PL-300: Microsoft Power BI Data
Analyst part 1 Exam Questions &
Answers (Grade A+)
Connect Live
Import
Direct Query -
correct answer ✅Connect Live
"You're creating a Power BI report with data from an Azure Analysis
Services Cube."
Power BI Live Connection is a kind of connection in Power BI. It only
connects to three types of data sources (SQL Server Analysis
Services Multi-Dimensional, SQL Server Analysis Services Tabular,
Power BI Service Dataset).
These three types of data sources are based on SQL Server Analysis
Services (SSAS) technology.
What can you do to improve performance when you are getting
data in Power BI?
Only pull data into the Power BI service, not Power BI Desktop
,PL-300: Microsoft Power BI Data
Analyst part 1 Exam Questions &
Answers (Grade A+)
Use the Select SQL statement in your SQL queries when you are
pulling data from a relational database
Combine date and time columns into a single column
Do some calculations in the original data source -
correct answer ✅Do some calculations in the original data source
Calculations can improve performance by consolidating columns
and data types (i.e. strings vs. intgers).
Which storage mode leaves the data at the data source?
Import
Direct Query
Dual -
correct answer ✅Direct Query
, PL-300: Microsoft Power BI Data
Analyst part 1 Exam Questions &
Answers (Grade A+)
With DirectQuery, the data remains in its original source, and any
transformations you apply will impact the performance of your
report.
Import moves it.
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 -
correct answer ✅Query folding
Query Folding is the capability of a Power Query to create a single
statement that can transform and execute tasks (such as filtering a
thousand rows of data) on the data source side.
What type of import error might leave a column blank?
