Power BI DATA ANALYTICS
1. Which DAX function would you use to fetch metadata about relationships in a
model?
A. INFO.VIEW.RELATIONSHIPS()
B. INFO.VIEW.TABLES()
C. INFO.COLUMNS()
D. INFO.VIEW.MEASURES()
Explanation: INFO.VIEW.RELATIONSHIPS() provides detailed metadata about
model relationships, including columns, direction, and cardinality.
2. What is the Tabular Model Definition Language (TMDL) feature introduced in this
update?
A) For exposing semantic models for collaboration
B) For creating advanced dashboards
C) For automating report generation
D) For enhanced real-time analysis
3. What is the primary use of the DAX query view in Power BI?
A. Writing MDX queries
B. Formatting and debugging DAX formulas
C. Creating paginated reports
D. Exploring and exporting model metadata
4. What does database monitoring in Microsoft Fabric enable?
A. Real-time dashboard creation
B. Zero-ETL and near real-time insights
C. Integration with AI tools
D. Cloud migration of on-premise databases
5. How does the Auto Date/Time feature work in Power BI?
A) Automatically creates a date hierarchy for each date field in a model
B) Automatically sorts dates in descending order
C) Disables time intelligence functions
D) Removes date columns from the model
Explanation: The Auto Date/Time feature creates a date hierarchy for every date
field, enabling automatic time intelligence functions without requiring an explicit date
table.
6. In a Power BI data model, what does the snowflake schema involve?
A) Storing all data in one table
B) Extending a star schema by normalizing dimension tables into multiple related
tables
C) Using multiple fact tables with no dimension tables
D) Merging dimension and fact tables
Explanation: Snowflake schema normalizes the dimension tables, breaking them into
sub-tables, which results in a more complex schema compared to a simple star
schema.
7. Which DAX function is used to retrieve related values from a different table in Power
BI’s data model?
A) CALCULATE()
B) RELATED()
C) LOOKUPVALUE()
D) VALUES()
Explanation: RELATED() fetches values from a related table based on existing
relationships, commonly used to bring fields from dimension tables into fact tables.
8. What is the purpose of using a surrogate key in a data model?
A) To create a calculated column
B) To replace a composite key with a unique identifier
C) To remove duplicate rows from a table
D) To ensure data is in a single table
Explanation: Surrogate keys are single, unique identifiers used to simplify
relationships and eliminate the need for composite keys in data models.
9. What is a potential downside of using calculated columns instead of measures in
Power BI?
A) They are only calculated on data refresh, not during interactions
B) They cannot be used in filters
C) They do not support DAX functions
D) They cannot be used in visualizations
10. When should you use a Many-to-Many relationship in Power BI?
A) When there are no relationships in the data model
B) When both tables have unique values in the linking column
C) When both tables contain duplicate values in the linking column
D) When both tables are identical in structure
Explanation: Many-to-many relationships are used when both tables have duplicates
in the linking column, allowing analysis across both tables without a unique key
constraint.
11. What is a key benefit of using a relationship with bidirectional cross-filtering in
Power BI?
A) Improves performance by reducing data size
B) Allows filter propagation in both directions between related tables
C) Automatically creates measures
D) Reduces data redundancy
12. What type of relationship is created in Power BI if a dimension table’s primary key is
linked to a fact table’s foreign key?
A) Many-to-Many
B) One-to-Many
C) One-to-One
D) Many-to-One
13. In Power BI, what is the purpose of a star schema in data modeling?
A) To store data in a single table
B) To eliminate duplicate values in a table
C) To simplify data structure by organizing related tables in a central fact table
D) To enhance the speed of loading visuals
14. Which of the following best describes a calculated column in Power BI?
A) A column used to join tables
B) A column created with DAX that is calculated row-by-row in a table
C) A measure used to aggregate data
D) A default column created during data import
15. What is the purpose of the BLANK() function in DAX?
A) Replaces null values in a table
B) Creates a blank cell in a calculated column or measure
C) Fills in missing data in a table
D) Removes rows with empty values
16. Which DAX function returns the total number of rows in a table?
A) COUNTA()
B) COUNTROWS()
C) ROWCOUNT()
D) TOTALROWS()
17. Which DAX function is commonly used to create a running total in a measure?
A) CUMULATE()
B) RUNNINGTOTAL()
C) SUMX()
D) CALCULATE() with FILTER()
18. Which function is used to return a single value based on conditions within DAX
expressions?
A) SELECT()
B) IF()
C) FIND()
D) CHOOSE()
19. In Power BI, which function would you use to calculate a rolling average for the last
12 months?
A) DATESINPERIOD() combined with AVERAGE()
B) LAST12MONTHS() combined with SUM()
C) YEARROLLING() combined with CALCULATE()
D) DATESMTD() combined with MAX()
20. Which DAX function would you use to calculate the cumulative sales for a fiscal year
that doesn’t start in January?
A) TOTALYTD() with an optional year-end date
B) CUMULATEFISCAL()
C) FISCALTOTALYTD()
D) DATESYTD() with a specified year-end date
21. What does the DATESBETWEEN() function do in a DAX formula?
A) Calculates the difference between two dates
B) Returns dates between a specified start and end date
C) Filters the data to include only weekend dates
D) Only includes dates within the current quarter
22. Which DAX function would you use to calculate the same period last quarter’s total
in Power BI?
A) SAMEPERIODLASTQUARTER()
B) PREVIOUSQUARTER()
C) TOTALQTD()
D) SAMEPERIODLASTYEAR()
23. What does the DATESINPERIOD() function do in Power BI?
A) Returns a set of dates from the start to the end of the calendar year
B) Returns a set of dates between a specified start date and the number of intervals
C) Returns only the current period's dates
D) Returns dates from the start to the end of the fiscal year
24. Which of the following DAX functions calculates the previous month’s value for a
measure?
A) PREVIOUSMONTH()
B) LASTMONTH()
C) PREV_MONTH()
D) MONTHBACK()
25. Which DAX function would you use to calculate the month-to-date (MTD) total for a
measure?
A) TOTALMTD()
B) SUMMTD()
C) MONTHTO()
D) CUMULATEMTD()
26. What is the purpose of the SAMEPERIODLASTYEAR() function in Power BI?
A) Returns the same period for the previous year
B) Returns data from the previous month
C) Returns the cumulative total for the current year
D) Returns the same period for the next year
27. Which DAX function is used to remove filters from a column or table?
A) FILTER()
B) REMOVE()
C) CLEARFILTER()
D) ALL()
28. What is the primary purpose of the CALCULATE() function in DAX?
A) To create a calculated column
B) To modify the filter context of an expression
C) To sort data in a specific order
D) To generate a random number
29. Which DAX function would you use to calculate the year-to-date (YTD) value for a
measure in Power BI?
A) CALCULATE + DATESYTD
B) CALCULATE + TOTALYTD
C) CALCULATE + ACCUMULATEYTD()
D) YTDSUM()
30. Which custom visual type in Power BI is typically used to display hierarchical data
with drill-down capability?
A) Line and Stacked Column Chart
B) Matrix Visual
C) Funnel Chart
D) Decomposition Tree
1. Which DAX function is used to remove filters, slicers, and visual selections?
o ALL
o REMOVEFILTERS
o ALLEXCEPT
o ALLSELECTED
2. Which DAX function is typically used for row-level security (RLS) in Power BI?
o RELATED
o USERELATIONSHIP
o USERNAME
o CONTAINS
3. Which of the following is a method to optimize DAX queries for performance?
o Use more calculated columns instead of measures
o Avoid using measures entirely
o Use filter functions like CALCULATE and FILTER efficiently
4. Which DAX function would you use to create a running total in Power BI?
o SUM
o TOTALYTD
o SUMMARIZE
o CONCATENATE
5. Which feature in Power Query allows you to combine multiple tables into a
single table?
o Append Queries
o Merge Queries
o Split Columns
o Replace Values
6. What does the "Query Dependencies" view in Power BI show?
o All the transformations applied to a table
o Relationships between different queries
o DAX expressions used in the model
o Data refresh history
7. What is the "M" language used for in Power BI?
o Building reports
o Writing DAX measures
o Data transformation in Power Query
o Designing visuals
8. Which of the following functions in DAX is used to modify filter context in a
calculation?
o CALCULATE
o SUM
o FILTER
o ALL
9. What does the DAX function RELATED() do?
o Returns the sum of related rows
o Retrieves a related value from another table
o Joins two tables based on a common column
o Removes duplicate values from a table
10. Which DAX function is used to return the first value in a column?
o FIRSTNONBLANK
o FIRSTVALUE
o FIRSTDATE
o FIRSTROW
11. What is the difference between SUM and SUMX in DAX?
o SUM sums up rows, while SUMX performs a calculation for each row and
then sums
o Both SUM and SUMX are used to sum rows, but SUMX is faster
o SUM only works with numeric columns, while SUMX works with all types of
data
o There is no difference between SUM and SUMX
12. Which Power Query function is used to combine two or more tables by rows?
o Table.Join
o Table.Append
o Table.AddColumn
o Table.SelectRows
13. Which function in Power Query is used to merge columns into a single column?
o Table.CombineColumns
o Table.MergeColumns
o Text.Combine
o Table.Join
14. Which function in Power Query is commonly used to filter rows based on a
condition?
o Table.FilterRows
o Table.SelectRows
o Table.TransformColumns
o Table.ExpandListColumn
15. What Power Query function is used to convert text to lowercase?
o Text.Transform
o Text.Lower
o Text.ToLower
o Text.Format
16. Which function in Power Query helps remove duplicates from a table?
o Table.RemoveColumns
o Table.RemoveDuplicates
o Table.TransformRows
17. What kind of workloads does the Lakehouse architecture support?
o Only real-time workloads
o Only batch processing workloads
o Both batch and real-time analytics workloads
o Only machine learning workloads
18. How does Lakehouse architecture improve data consistency for analytics?
o By enforcing strict schema on all datasets
o By keeping separate lakes and warehouses
o By unifying batch and streaming data into a single storage layer
o By only supporting SQL-based queries
19. Which of the following is a key benefit of using Lakehouse over traditional data
warehousing?
o Supports only structured data
o Highest storage costs
o Supports both structured and unstructured data
o Longer query times
20. Which Microsoft tool is used for building and managing Lakehouses in
Microsoft Fabric?
o Power BI
o Azure Synapse Analytics
o SQL Server
o Fabric Data Engineering
21. How does a Lakehouse architecture handle unstructured data?
o It stores it in a separate data warehouse
o It cannot store unstructured data
o It processes it using machine learning models
o It stores unstructured data in the data lake layer
22. Which of the following data formats is commonly used for storing data in a
Lakehouse?
o XML
o JSON
o Parquet
o CSV
23. What is the primary compute engine used for querying data in a Lakehouse?
o Apache Hadoop
o Azure SQL Database
o Microsoft Access
o Apache Spark
24. What is the main advantage of a Lakehouse architecture?
o Merges the benefits of data lakes and data warehouses
o Focuses only on structured data storage
o Requires less cloud storage
o Eliminates the need for real-time analytics
25. Which of the following is a key component of the Fabric Eventhouse architecture
for handling real-time data?
o A) Dataflows
o B) KQL (Kusto Query Language)
o C) Spark clusters
o D) Azure Synapse Pipelines
26. Which of the following is a benefit of using Fabric Eventhouse for real-time
analytics?
o A) Reduced hardware costs
o B) Improved batch data processing speeds
o C) Immediate insights from live data streams
o D) Enhanced database storage capacity
27. Which feature of Fabric Eventstream allows it to handle high-throughput data
ingestion?
o Data Lakes
o Stream Analytics Jobs
o Dataflows
o Data Factory Pipelines
28. What type of data does Fabric Eventstream typically process?
o Static historical data
o Batch-processed data
o Continuous real-time data
o Archived logs
29. How does Fabric Eventstream support real-time data visualization?
o By exposing data to Excel
o By integrating with Power BI for live dashboards
o By generating CSV files
o By creating SQL Server reports
30. What is a typical application of Fabric Eventstream in a business context?
o Managing payroll systems
o Real-time fraud detection
o Conducting annual financial audits
o Generating periodic sales reports
31. What is a common source of data for Fabric Eventstream?
o SQL Databases
o File Shares
o EventHubs and IoT Devices
o Static Excel Files
32. Which Azure service can be used alongside Fabric Eventstream for event-based
data ingestion?
o Azure Blob Storage
o Azure Synapse Analytics
o Azure EventHubs
o Azure Virtual Machines
33. What is the primary use of Fabric Eventstream in Microsoft Fabric?
o Storing large datasets for historical analysis
o Processing and analyzing streaming data in real-time
o Performing batch data transformations
o Creating machine learning models
34. Which type of processing is used in Fabric Eventstream?
o Batch processing
o In-memory processing
o Stream processing
o Predictive processing
35. What is the primary purpose of Fabric Eventstream in Microsoft Fabric?
o A) Batch processing of historical data
o B) Performing machine learning model training
o C) Real-time ingestion and analysis of streaming data
o D) ETL (Extract, Transform, Load) pipeline automation
36. How would you ensure that a new column is included in the incremental refresh
and appears in your Power BI reports after modifying the underlying database
schema?
37. How would you fix an incorrect value in a 6-month-old order in Power BI after
discovering it in the database?
o Update in the database, then refresh and publish the report
o Update the database, then refresh only the affected partition
38. If you need to update a measure in Power BI and have already set up an
incremental refresh policy, which tool would you prefer to use?
o DAX Studio
o SQL Server Management Studio
o ALM Toolkit
o Bravo
39. Which DAX function should you use to categorize sales into "High," "Medium,"
and "Low" based on the total sales amount?
o SWITCH
o AND
o FOR EACH
o IFERROR
40. Which Azure service should you use to ingest data from multiple sources and
transform it before loading it into Azure SQL Database?
o Azure Data Factory
o Azure Functions
o Azure Monitor
o Azure EventHubs
41. Which Azure Data Factory activity is used to copy data from a source to a
destination?
o Lookup activity
o Copy activity
o Stored Procedure activity
o Execute Pipeline activity
42. Which service should you use to orchestrate and automate the data ingestion
process into Azure Data Lake Storage?
o Azure Data Factory
o Azure Stream Analytics
o Azure Synapse Analytics
o Azure SQL Database
43. Which tool should you use to integrate data from multiple sources and create a
unified view of your data?
o Excel
o Power BI
44. Which Power BI feature allows you to create a query that combines data from
multiple tables in a data model?
o Merge Queries
o Append Queries
o Relationship View
o DAX Calculated Columns
45. What is the key benefit of creating and publishing a Power BI template?
o It allows you to share reports with multiple users
o It automatically refreshes data without manual intervention
o It simplifies reusing a report layout and structure across different datasets
o It helps in automating data extraction from multiple sources
Let me know if you'd like further adjustments or additions.
4o mini
You said:
join all question 30 and htose that makes 45
ChatGPT said:
ChatGPT
Here are all the questions combined into one list, from 1 to 45:
1. Which DAX function is used to remove filters, slicers, and visual selections?
o ALL
o REMOVEFILTERS
o ALLEXCEPT
o ALLSELECTED
2. Which DAX function is typically used for row-level security (RLS) in Power BI?
o RELATED
o USERELATIONSHIP
o USERNAME
o CONTAINS
3. Which of the following is a method to optimize DAX queries for performance?
o Use more calculated columns instead of measures
o Avoid using measures entirely
o Use filter functions like CALCULATE and FILTER efficiently
4. Which DAX function would you use to create a running total in Power BI?
o SUM
o TOTALYTD
o SUMMARIZE
o CONCATENATE
5. Which feature in Power Query allows you to combine multiple tables into a
single table?
o Append Queries
o Merge Queries
o Split Columns
o Replace Values
6. What does the "Query Dependencies" view in Power BI show?
o All the transformations applied to a table
o Relationships between different queries
o DAX expressions used in the model
o Data refresh history
7. What is the "M" language used for in Power BI?
o Building reports
o Writing DAX measures
o Data transformation in Power Query
o Designing visuals
8. Which of the following functions in DAX is used to modify filter context in a
calculation?
o CALCULATE
o SUM
o FILTER
o ALL
9. What does the DAX function RELATED() do?
o Returns the sum of related rows
o Retrieves a related value from another table
o Joins two tables based on a common column
o Removes duplicate values from a table
10. Which DAX function is used to return the first value in a column?
o FIRSTNONBLANK
o FIRSTVALUE
o FIRSTDATE
o FIRSTROW
11. What is the difference between SUM and SUMX in DAX?
o SUM sums up rows, while SUMX performs a calculation for each row and
then sums
o Both SUM and SUMX are used to sum rows, but SUMX is faster
o SUM only works with numeric columns, while SUMX works with all types of
data
o There is no difference between SUM and SUMX
12. Which Power Query function is used to combine two or more tables by rows?
o Table.Join
o Table.Append
o Table.AddColumn
o Table.SelectRows
13. Which function in Power Query is used to merge columns into a single column?
o Table.CombineColumns
o Table.MergeColumns
o Text.Combine
o Table.Join
14. Which function in Power Query is commonly used to filter rows based on a
condition?
o Table.FilterRows
o Table.SelectRows
o Table.TransformColumns
o Table.ExpandListColumn
15. What Power Query function is used to convert text to lowercase?
o Text.Transform
o Text.Lower
o Text.ToLower
o Text.Format
16. Which function in Power Query helps remove duplicates from a table?
o Table.RemoveColumns
o Table.RemoveDuplicates
o Table.TransformRows
17. What kind of workloads does the Lakehouse architecture support?
o Only real-time workloads
o Only batch processing workloads
o Both batch and real-time analytics workloads
o Only machine learning workloads
18. How does Lakehouse architecture improve data consistency for analytics?
o By enforcing strict schema on all datasets
o By keeping separate lakes and warehouses
o By unifying batch and streaming data into a single storage layer
o By only supporting SQL-based queries
19. Which of the following is a key benefit of using Lakehouse over traditional data
warehousing?
o Supports only structured data
o Highest storage costs
o Supports both structured and unstructured data
o Longer query times
20. Which Microsoft tool is used for building and managing Lakehouses in
Microsoft Fabric?
o Power BI
o Azure Synapse Analytics
o SQL Server
o Fabric Data Engineering
21. How does a Lakehouse architecture handle unstructured data?
o It stores it in a separate data warehouse
o It cannot store unstructured data
o It processes it using machine learning models
o It stores unstructured data in the data lake layer
22. Which of the following data formats is commonly used for storing data in a
Lakehouse?
o XML
o JSON
o Parquet
o CSV
23. What is the primary compute engine used for querying data in a Lakehouse?
o Apache Hadoop
o Azure SQL Database
o Microsoft Access
o Apache Spark
24. What is the main advantage of a Lakehouse architecture?
o Merges the benefits of data lakes and data warehouses
o Focuses only on structured data storage
o Requires less cloud storage
o Eliminates the need for real-time analytics
25. Which of the following is a key component of the Fabric Eventhouse architecture
for handling real-time data?
o A) Dataflows
o B) KQL (Kusto Query Language)
o C) Spark clusters
o D) Azure Synapse Pipelines
26. Which of the following is a benefit of using Fabric Eventhouse for real-time
analytics?
o A) Reduced hardware costs
o B) Improved batch data processing speeds
o C) Immediate insights from live data streams
o D) Enhanced database storage capacity
27. Which feature of Fabric Eventstream allows it to handle high-throughput data
ingestion?
o Data Lakes
o Stream Analytics Jobs
o Dataflows
o Data Factory Pipelines
28. What type of data does Fabric Eventstream typically process?
o Static historical data
o Batch-processed data
o Continuous real-time data
o Archived logs
29. How does Fabric Eventstream support real-time data visualization?
o By exposing data to Excel
o By integrating with Power BI for live dashboards
o By generating CSV files
o By creating SQL Server reports
30. What is a typical application of Fabric Eventstream in a business context?
o Managing payroll systems
o Real-time fraud detection
o Conducting annual financial audits
o Generating periodic sales reports
31. What is a common source of data for Fabric Eventstream?
o SQL Databases
o File Shares
o EventHubs and IoT Devices
o Static Excel Files
32. Which Azure service can be used alongside Fabric Eventstream for event-based
data ingestion?
o Azure Blob Storage
o Azure Synapse Analytics
o Azure EventHubs
o Azure Virtual Machines
33. What is the primary use of Fabric Eventstream in Microsoft Fabric?
o Storing large datasets for historical analysis
o Processing and analyzing streaming data in real-time
o Performing batch data transformations
o Creating machine learning models
34. Which type of processing is used in Fabric Eventstream?
o Batch processing
o In-memory processing
o Stream processing
o Predictive processing
35. What is the primary purpose of Fabric Eventstream in Microsoft Fabric?
o A) Batch processing of historical data
o B) Performing machine learning model training
o C) Real-time ingestion and analysis of streaming data
o D) ETL (Extract, Transform, Load) pipeline automation
36. How would you ensure that a new column is included in the incremental refresh
and appears in your Power BI reports after modifying the underlying database
schema?
37. How would you fix an incorrect value in a 6-month-old order in Power BI after
discovering it in the database?
o Update in the database, then refresh and publish the report
o Update the database, then refresh only the affected partition
38. If you need to update a measure in Power BI and have already set up an
incremental refresh policy, which tool would you prefer to use?
o DAX Studio
o SQL Server Management Studio
o ALM Toolkit
o Bravo
39. Which DAX function should you use to categorize sales into "High," "Medium,"
and "Low" based on the total sales amount?
o SWITCH
o AND
o FOR EACH
o IFERROR
40. Which Azure service should you use to ingest data from multiple sources and
transform it before loading it into Azure SQL Database?
o Azure Data Factory
o Azure Functions
o Azure Monitor
o Azure EventHubs
41. Which Azure Data Factory activity is used to copy data from a source to a
destination?
o Lookup activity
o Copy activity
o Stored Procedure activity
o Execute Pipeline activity
42. Which service should you use to orchestrate and automate the data ingestion
process into Azure Data Lake Storage?
o Azure Data Factory
o Azure Stream Analytics
o Azure Synapse Analytics
o Azure SQL Database
43. Which tool should you use to integrate data from multiple sources and create a
unified view of your data?
o Excel
o Power BI
o Azure Data Factory
o SQL Server Management Studio
44. What Power BI feature allows you to create a query that combines data from
multiple tables in a data model?
o Merge Queries
o Append Queries
o Relationship View
o DAX Calculated Columns
45. What is the key benefit of creating and publishing a Power BI template?
o It allows you to share reports with multiple users
o It automatically refreshes data without manual intervention
o It simplifies reusing a report layout and structure across different datasets
o It helps in automating data extraction from multiple sources
