Bangladesh Fabric & Power BI User Group Quiz

Which DAX function is used to calculate a running total in Power BI? 

• CALCULATE

• TOTALYTD

• FILTER

Which Power BI feature allows users to create role-based security by defining filters?

• Data Gateway

• Drillthrough

• Row-Level Security

In Power Query, what does the 'Append Queries' operation do?

• Combines rows from two or more tables into one

• Splits a table into multiple tables

• Joins two tables side by side

Which of the following best describes 'Query Folding' in Power Query?

• The process of saving a query

• The method of grouping data

• The ability to translate Power Query steps into native queries for the data source

Which workload in Microsoft Fabric is responsible for data integration? 

• Data Factory

• Data Activator

• Real Time Data Integration

How many storage modes are there in Power BI & Fabric? 

• 4

• 3

• 6

What is the purpose of the "dropna()" method in Pandas? 

• To remove the dataframe

• To remove rows or columns with missing values.

• To add a new blank row

What feature allows users to access and manage databases without switching clients in Microsoft Fabric? 

• Data Ingestion

• Shortcut

• Mirroring 

Which option needs to be enabled to share spark sessions across multiple concurrent users or processes? 

• Standard mode

• Normal mode

• High concurrency mode 

Which API can be used in Spark to process streaming data? 

• Spark Structured Streaming API

• Streaming HTTPS

• RTI API