Power BI Introduction and Connecting with Data Sources

Which language is commonly used to write custom expressions in Power BI for data transformations?

• PowerShell

• SQL (Structured Query Language)

• Power FX

• DAX (Data Analysis Expressions)

What does the term "ETL" stand for in the context of data preparation in Power BI?

• Extract, Transform, Load

• Explore, Test, Learn

• Edit, Tag, Link

• Execute, Terminate, Log

In Power BI, what is a data source connection that uses an imported dataset called?

• DirectQuery

• Live Connection

• Import

• Power Query

What is the maximum number of data sources that can be combined in a single Power BI report?

• 5

• 10

• 15

• Unlimited

Which of the following is a cloud-based platform for sharing and collaborating on Power BI reports?

• Power BI Desktop

• Power BI Service

• Power BI Mobile

• Power BI Gateway

Who enables advanced analytics capabilities through reports and visualizations?

• A.Data Visualizer

• B.Data Scientist

• C.Data Engineer

• D.Data Analyst

Select the building blocks of Power BI.

• A.Tiles and Dashboards

• B.Visual Studio, C#, and JSON files

• C.Datasets, Visualizations, Reports, Dashboards, and Tiles

• D.Databases and Mobile Devices

The common flow of activity in Power BI is described by?

• A.Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards

• B.Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.

• C.Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.

• D.Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.

Which of the following is the primary data preparation tool in Power BI?

• A.Report Editor

• B.Power Query Editor

• C.Data Editor

• D.Data Visualizer