Power BI

In order join tables in Power BI we use ---------- in power Query editor ?

• Merge

• Append

• DAX

• Can not join

In which type of data source we can use option " Use first row as header " in power query editor home menu ?

• Flat file with Header

• Flat file Without Header

• Database Tables

• Views

• File Type data Source

In Column tools menu under summarization what are the options available ?

• Sum

• Average

• Minimum

• Maximum

• Count (Distinct)

Which of the following are data sources that can be used in Power BI?

• Excel spreadsheets

• JSON files

• Oracle databases

• Adobe Photoshop files

What is the purpose of the Q&A feature in Power BI?

• To allow users to ask natural language questions and get answers from data

• To create and share reports and dashboards

• To analyze and visualize data

• To create and manage data models

In Power BI Desktop, where do you find the Power Query Editor to transform your data?

• Data Source Settings

• Transform Data

• The Power Query tab

• Selection

When using the "Group By" transformation in Power Query, what is the purpose of the "Advanced" option?

• It allows you to create custom DAX calculations.

• It provides more advanced sorting options for grouped data.

• It lets you specify multiple grouping levels.

• It is used for converting text data to numbers.

In Power BI, what is the purpose of the "Manage Aggregations" feature in data modeling?

• To aggregate data for visualization purposes.

• To define hierarchies within tables.

• To improve query performance by defining aggregations at various levels of granularity.

• To create calculated columns.

What is the purpose of the "Fields" pane in Power BI when building a report?

• To apply visual styles and formatting to the report.

• To create calculated columns and measures.

• To select and arrange data fields in the report canvas.

• To define row-level security settings.

When creating a custom measure in Power BI, which language is used to write the measure's formula?

• DAX

• Java

• R

• SQL