Which query language do you use to extract data from Microsoft SQL Server?
DAX
T-SQL
MDX - ANSWER T-SQL
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?
Connect Live
Import
Direct Query - ANSWER Connect Live
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
Use the Select SQL statement in your SQL queries when you are pulling data from a rela-
tional database
Combine date and time columns into a single column
Do some calculations in the original data source - ANSWER Do some calculations in the
original data source
Which storage mode leaves the data at the data source?
Import
Direct Query
Dual - ANSWER Direct Query
1
, 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 - ANSWER Query folding
What type of import error might leave a column blank?
Keep errors
Unpivot columns
Data type error - ANSWER Data type error
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 con-
figure 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 da-
taset.
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. - ANSWER Create a parameter and update the queries to use the parameter.
(As you can't edit datasets data sources in Power BI service, we recommend using parame-
ters to store connection details such as instance names and database names, instead of us-
ing a static connection string. This allows you to manage the connections through the Power
BI service web portal, or using APIs, at a later stage.)
2
DAX
T-SQL
MDX - ANSWER T-SQL
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?
Connect Live
Import
Direct Query - ANSWER Connect Live
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
Use the Select SQL statement in your SQL queries when you are pulling data from a rela-
tional database
Combine date and time columns into a single column
Do some calculations in the original data source - ANSWER Do some calculations in the
original data source
Which storage mode leaves the data at the data source?
Import
Direct Query
Dual - ANSWER Direct Query
1
, 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 - ANSWER Query folding
What type of import error might leave a column blank?
Keep errors
Unpivot columns
Data type error - ANSWER Data type error
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 con-
figure 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 da-
taset.
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. - ANSWER Create a parameter and update the queries to use the parameter.
(As you can't edit datasets data sources in Power BI service, we recommend using parame-
ters to store connection details such as instance names and database names, instead of us-
ing a static connection string. This allows you to manage the connections through the Power
BI service web portal, or using APIs, at a later stage.)
2
