PBI Quiz 1

Which query language do you use to extract data from Microsoft SQL Server?

• DAX

• T-SQL

• MDX

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

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

• Combine date and time columns into a single column

• Do some calculations in the original data source

Which storage mode leaves the data at the data source?

• Import

• Direct Query

• Dual

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

What type of import error might leave a column blank?

• Keep errors

• Unpivot columns

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

You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

• Add a SQL statement.

• Set Data Connectivity mode to DirectQuery.

• Set the Command timeout in minutes setting.

• Set Data Connectivity mode to Import.

Which of the following sources lets users connect to a set of pre-wired connections?

• PBIDS Files

• JSON Files

• Dataflows

• SSAS Tabular

You plan to publish your SSAS Tabular (live connection) data model to Power BI Service.

What must be used in order for this to be possible?

• Data Gateway

• Dual Storage Mode

• Parameters

• Admin Privileges