Introduction to Power-BI

_{Which two Data profiling tool you can use to identify Primary Key in the table?}

• _{Column Distribution}

• _{Column Quality}
  

• _{Column Check}

• _{Column Profile}
  

_{You’re importing data from an SQL Server in Power Query Editor.
Which Connection type will you use?}

• Connect live

• Import

• Direct Querry

• Export

_{Which Power Query tool can you use when you know the outcome of a column you want but don’t know which transformation(s) to use?}

• Column From Examples
• Column From Values
• Column From Results
• Column From Outcomes

You open a query in Power Query Editor.

You need to identify the percentage of empty values in each column as quickly as possible.

Which Data Preview option should you select?

• Column Quality
• Column Distribution
• Column Profile
• Column Statistics

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

• MySQL
• MongoDB
• Transact-SQL
• PostgreSQL

What can you do to improve performance when you are getting data in Power BI?

• Use Direct Query or Live Connection and Do some calculations in the original data source

• Increase the size of your computer's hard drive
• Use a faster internet connection
• Combine date and time columns into a single column

Which of the following sources can Power BI connect to?

• R scripts

• Microsoft Word
• SQL Database

• All of the above

What is the Query Editor used for?

• To create relationships between data and lookup tables

• To shape & transform data, then load it into Power BI

• To create measures & calculated columns using DAX

• To design websites

When should you use DirectQuery?

• When you need to work with large volumes of data
• When you want to perform complex calculations
• When you want to create a static report
• When you need real-time data and the Dataset is too large to be stored in-memory

Answer explanation

Use DirectQuery when the dataset is too large to be stored in-memory, when the source

data changes frequently & reports must show the most recent data, and when the company

policy states data can only be accessed from the original source.

Which of the following sources lets you connect your data to other business

applications?

• Google Sheets
• APIs & Microsoft Dataverse

• Microsoft Dataflows

• Social Media

Answer explanation

The Dataverse is a cloud-based storage options for your organization's data that you can

connect to business applications like Power Apps, Power Automate, and Power Virtual

Agents