BCA FY 2024 Worksop1 PBI

What is Power BI primarily used for?

• Data Entry

• Data Visualization and Business Intelligence

• Website Development

• Cloud Storage

Which of the following is NOT a component of Power BI?

• Power BI Desktop

• Power BI Service

• Power BI Gateway

• PowerPoint BI

What is the default data refresh interval in Power BI Service for datasets using DirectQuery?

• 15 minutes

• 1 hour

• 30 minutes

• 5 minutes

What does DAX stand for in Power BI?

• Data Access Expression

• Data Analysis Expressions

• Direct Analysis eXchange

• Data Analytical Exchange

Which file type is used to save Power BI Desktop projects?

• .pbd

• .pbx

• .pbix

• .pbi

Which visual is used to display trends over time in Power BI?

• Line Chart

• Bar Chart

• Pie Chart

• Matrix

In Power BI, what is a slicer used for?

• To create new columns

• To filter data

• To import data from databases

• To automate refreshes

What is the main use of Power Query in Power BI?

• Data modeling

• Data visualization

• Data transformation and preparation

• Generating DAX expressions

Which function is used in DAX to calculate cumulative totals?

• SUM()

• TOTALYTD()

• CUMULATIVESUM()

• ROLLUP()

What is the purpose of Power BI Report Server?

• Hosting dashboards on mobile apps

• Storing reports on the cloud

• Hosting reports on-premises

• Automating report creation