PowerBI Test 1

1. What is the correct icon to connect to a data source in PowerBI ?

• 
• 
• 
• 

2. What type of files can be imported into Power BI Desktop for data analysis?

• xlsx (Excel) files
  

• csv files
  

• SQL Server databases
  

• All of the above

3 . What are the three views of powerBI Desktop?

• Visualization , Data , PowerQuery, Report

• Report, Table, Model , DAX Query

• Model , Query , Report , Code

• Dashboard , Model , Table, DAX Query

4. What is the purpose of Power Query in Power BI?

• Creating visuals

• Extracting, transforming, and loading data

• Writing DAX formulas

• Managing security settings

5 . In Power Query, what transformation option would you use to break a single column into multiple columns based on a delimiter?

• Merge Columns

• Unpivot Columns

• Group By

• Split Column

6 . What programming language used in PowerBI Query editor ?

• DAX

• R

• M

• F#