1. Which transformation in Power Query is used to remove duplicate rows from a dataset?

• a) Remove Rows
• b) Remove Duplicates
• c) Remove Columns
• d) Filter Rows

Answer: b) Remove Duplicates

2. In Power Query, which function is used to extract the year from a date column?

• a) Date.Year
• b) Date.ExtractYear
• c) Year
• d) Date.YearValue

Answer: a) Date.Year

3. What is the purpose of the "Merge Queries" operation in Power Query?

• a) To join two or more tables based on matching values in specified columns
• b) To create a new column with calculated values
• c) To filter rows based on specified criteria
• d) To aggregate data using grouping operations

Answer: a) To join two or more tables based on matching values in specified columns

4. Which Power Query function is used to unpivot columns in a dataset?

• a) Table.Unpivot
• b) Table.Transpose
• c) Table.ExpandTableColumn
• d) Table.AddColumn

Answer: a) Table.Unpivot

5. What is the purpose of the "Append Queries" operation in Power Query?

• a) To combine multiple tables with identical column structures into a single table
• b) To merge two tables based on matching values in specified columns
• c) To create a reference to another query
• d) To filter rows based on specified criteria

Answer: a) To combine multiple tables with identical column structures into a single table

6. Which transformation in Power Query is used to split a column into multiple columns based on a delimiter?

• a) Split Column by Delimiter
• b) Extract Text
• c) Transform Column
• d) Unpivot Columns

Answer: a) Split Column by Delimiter

7. What is the purpose of creating calculated columns in Power BI?

• a) To define relationships between tables
• b) To perform data aggregation operations
• c) To create new columns based on calculated expressions
• d) To visualize data using charts and graphs

Answer: c) To create new columns based on calculated expressions

8. In Power BI, what is the difference between calculated columns and measures?

• a) Calculated columns are used for aggregation, while measures are used for calculations.
• b) Calculated columns are computed during data refresh, while measures are computed at query time.
• c) Calculated columns are stored in the data model, while measures are dynamically calculated.
• d) Calculated columns can be used in charts, while measures cannot.

Answer: c) Calculated columns are stored in the data model, while measures are dynamically calculated.

9. Which DAX function is used to aggregate values over a specified table or column?

• a) SUM
• b) CALCULATE
• c) AVERAGE
• d) FILTER

Answer: a) SUM

10. What is the purpose of using row-level security in Power BI?

• a) To define relationships between tables
• b) To restrict access to data based on user roles or permissions
• c) To perform data aggregation operations
• d) To create calculated columns based on conditions

Answer: b) To restrict access to data based on user roles or permissions

11. What does the TREATAS function do in DAX?

• a) Converts a column of text values into numerical values
• b) Sets the filter context for a measure based on specified values
• c) Converts a table of values into a scalar value
• d) Combines two or more tables into a single table, preserving relationships

Answer: b) Sets the filter context for a measure based on specified values

12. Which DAX function is used to calculate the year-over-year growth percentage?

• a) TOTALYTD
• b) SAMEPERIODLASTYEAR
• c) CALCULATE
• d) YEARFRAC

Answer: b) SAMEPERIODLASTYEAR

13. Which Power BI visualization type is best suited for comparing values across different categories?

• a) Line chart
• b) Bar chart
• c) Scatter plot
• d) Pie chart

Answer: b) Bar chart

14. In Power BI, what does the term "drill-down" refer to?

• a) Expanding a hierarchy to show additional levels of detail
• b) Zooming in on a specific portion of a visualization
• c) Switching between different levels of granularity in a chart
• d) Filtering data based on specified criteria

Answer: a) Expanding a hierarchy to show additional levels of detail

15. What is the purpose of using bookmarks in Power BI?

• a) To navigate between different pages in a report
• b) To apply predefined filters and slicers to visualizations
• c) To save the state of a report for later reference
• d) To export data to external formats

Answer: c) To save the state of a report for later reference

16. Which Power BI feature allows users to interactively explore data by selecting data points within visualizations?

• a) Drill-down
• b) Drill-through
• c) Cross-filtering
• d) Slicers

Answer: c) Cross-filtering

17. What is the purpose of using a KPI (Key Performance Indicator) in Power BI?

• a) To compare actual performance to target goals
• b) To visualize trends and patterns in data
• c) To filter data based on specified criteria
• d) To create hierarchies for drill-down analysis

Answer: a) To compare actual performance to target goals

18. Which Power BI visualization type is used to display data points as bubbles on a two-dimensional grid?

• a) Scatter plot
• b) Line chart
• c) Area chart
• d) Treemap

Answer: a) Scatter plot

19. What is the purpose of configuring data refresh schedules in the Power BI service?

• a) To automatically update data in published reports
• b) To customize visualizations and dashboards
• c) To manage access permissions for users
• d) To create relationships between data tables

Answer: a) To automatically update data in published reports

20. Which role in the Power BI service allows users to publish reports and share dashboards?

• a) Viewer
• b) Contributor
• c) Admin
• d) Member

Answer: b) Contributor

21. What is the role of a gateway in Power BI?

• a) To schedule data refreshes for on-premises data sources
• b) To secure access to published reports and dashboards
• c) To create relationships between data tables
• d) To manage user roles and permissions

Answer: a) To schedule data refreshes for on-premises data sources

22. What is the purpose of creating a content pack in Power BI?

• a) To define relationships between tables
• b) To restrict access to data based on user roles
• c) To share reports and dashboards with external users
• d) To organize and collaborate on content within an organization

Answer: c) To share reports and dashboards with external users

23. Which Power BI feature allows users to annotate and provide feedback on specific data points in a visualization?

• a) Q&A (Question and Answer)
• b) Comments
• c) Bookmarks
• d) Alerts

Answer: b) Comments

24. What is the purpose of configuring row-level security in Power BI?

• a) To define relationships between tables
• b) To restrict access to data based on user roles or permissions
• c) To create calculated columns based on conditions
• d) To manage data refresh schedules

Answer: b) To restrict access to data based on user roles or permissions

25. Which Power Query transformation is used to replace specific values in a column with another value?

• a) Replace Values
• b) Replace Errors
• c) Replace Duplicates
• d) Replace Empty Cells

Answer: a) Replace Values

26. What is the purpose of the "Group By" operation in Power Query?

• a) To aggregate data based on specified grouping criteria
• b) To filter rows based on specified conditions
• c) To merge multiple queries into a single query
• d) To sort data based on specified columns

Answer: a) To aggregate data based on specified grouping criteria

27. Which Power Query transformation is used to pivot columns into rows?

• a) Pivot Column
• b) Unpivot Columns
• c) Transform Column
• d) Split Column

Answer: b) Unpivot Columns

28. What is the purpose of the "Advanced Editor" in Power Query?

• a) To visualize data using charts and graphs
• b) To perform advanced data transformations using M language
• c) To create calculated columns and measures
• d) To manage access permissions for users

Answer: b) To perform advanced data transformations using M language

29. Which Power Query transformation is used to remove rows that meet specific criteria?

• a) Remove Rows
• b) Filter Rows
• c) Remove Duplicates
• d) Remove Columns

Answer: b) Filter Rows

30. What is the purpose of the "Add Custom Column" operation in Power Query?

• a) To create calculated columns based on expressions or formulas
• b) To merge multiple queries into a single query
• c) To rename columns based on specified criteria
• d) To split columns into multiple columns based on delimiters

Answer: a) To create calculated columns based on expressions or formulas

31. In Power BI, what is the purpose of creating calculated tables?

• a) To define relationships between tables
• b) To aggregate data using grouping operations
• c) To create new tables based on calculated expressions
• d) To visualize data using charts and graphs

Answer: c) To create new tables based on calculated expressions

32. Which DAX function is used to calculate the difference between two dates?

• a) DATEDIFF
• b) DATEADD
• c) DATEDIFFERENCE
• d) DATEDELTA

Answer: a) DATEDIFF

33. What is the purpose of creating calculated measures in Power BI?

• a) To define relationships between tables
• b) To perform data aggregation operations
• c) To create new columns based on calculated expressions
• d) To visualize data using charts and graphs

Answer: b) To perform data aggregation operations

34. Which DAX function is used to calculate the cumulative total of a measure over a specified period?

• a) TOTALYTD
• b) TOTALMTD
• c) TOTALQTD
• d) TOTALIN

Answer: a) TOTALYTD

35. What is the purpose of using bidirectional filtering in Power BI relationships?

• a) To allow filtering in both directions between related tables
• b) To restrict filtering in one direction between related tables
• c) To create circular references between related tables
• d) To optimize performance in Power BI reports

Answer: a) To allow filtering in both directions between related tables

36. Which DAX function is used to calculate the moving average of a measure over a specified period?

• a) AVERAGEX
• b) MOVINGAVERAGE
• c) RUNNINGAVERAGE
• d) AVERAGE

Answer: a) AVERAGEX

37. Which Power BI visualization type is used to display hierarchical data in a tree-like structure?

• a) Tree map
• b) Trellis
• c) Hierarchy
• d) Tree map hierarchy

Answer: a) Tree map

38. What is the purpose of using slicers in Power BI visualizations?

• a) To filter data based on predefined criteria
• b) To sort data in ascending or descending order
• c) To aggregate data into hierarchical structures
• d) To create relationships between data tables

Answer: a) To filter data based on predefined criteria

39. Which Power BI feature allows users to drill down into hierarchical data structures?

• a) Drill-down
• b) Drill-through
• c) Cross-filtering
• d) Hierarchical slicer

Answer: a) Drill-down

40. What is the purpose of using the "Analytic Grid" visualization in Power BI?

• a) To visualize hierarchical data using a grid layout
• b) To perform advanced data analysis using statistical functions
• c) To analyze data using multidimensional data models
• d) To create calculated measures based on specified criteria

Answer: b) To perform advanced data analysis using statistical functions

41. Which Power BI feature allows users to create custom tooltips for visualizations?

• a) Tooltips
• b) Annotations
• c) Q&A (Question and Answer)
• d) Bookmarks

Answer: a) Tooltips

42. What is the purpose of using drill-through in Power BI reports?

• a) To navigate between different pages in a report
• b) To filter data based on specified criteria
• c) To drill down into hierarchical data structures
• d) To view details related to a specific data point

Answer: d) To view details related to a specific data point

43. What is the purpose of configuring data refresh options in Power BI service?

• a) To automatically update data in published reports
• b) To customize visualizations and dashboards
• c) To manage access permissions for users
• d) To create relationships between data tables

Answer: a) To automatically update data in published reports

44. Which Power BI role allows users to publish reports and share dashboards?

• a) Viewer
• b) Contributor
• c) Admin
• d) Member

Answer: b) Contributor

45. What is the purpose of creating workspaces in the Power BI service?

• a) To visualize data using charts and graphs
• b) To deploy data to Power BI service
• c) To organize and collaborate on content
• d) To establish connections between related data tables

Answer: c) To organize and collaborate on content

46. What is the purpose of configuring row-level security in Power BI service?

• a) To define relationships between tables
• b) To restrict access to data based on user roles or permissions
• c) To create calculated columns based on conditions
• d) To manage data refresh schedules

Answer: b) To restrict access to data based on user roles or permissions

47. Which Power BI feature allows users to export reports to PowerPoint?

• a) Publish to Web
• b) Export to PDF
• c) Export to PowerPoint
• d) Export to Excel

Answer: c) Export to PowerPoint

48. What is the purpose of configuring usage metrics in Power BI service?

• a) To monitor report performance and user engagement
• b) To schedule data refreshes for on-premises data sources
• c) To define relationships between tables
• d) To create calculated measures based on conditions

Answer: a) To monitor report performance and user engagement

49. In Power Query, what is the purpose of the "Fill Down" operation?

• a) To fill empty cells with the value from the cell above
• b) To delete duplicate rows from a dataset
• c) To replace null values with a specified value
• d) To remove columns that contain only null values

Answer: a) To fill empty cells with the value from the cell above

50. Which Power Query transformation is used to change the data type of a column?

• a) Change Type
• b) Format
• c) Remove Duplicates
• d) Unpivot Columns

Answer: a) Change Type

51. What is the purpose of the "Extract" transformation in Power Query?

• a) To extract specific substrings from text columns
• b) To split columns into multiple columns based on delimiters
• c) To convert text values to numerical values
• d) To merge multiple queries into a single query

Answer: a) To extract specific substrings from text columns

52. Which Power Query function is used to create a custom function for reuse across queries?

• a) CustomFunction
• b) MFunction
• c) Table.AddColumn
• d) let

Answer: d) let

53. What is the purpose of the "Conditional Column" transformation in Power Query?

• a) To add a column based on a condition applied to other columns
• b) To remove rows that meet specific criteria
• c) To rename columns based on specified criteria
• d) To filter rows based on specified conditions

Answer: a) To add a column based on a condition applied to other columns

54. Which Power Query transformation is used to unpivot selected columns in a dataset?

• a) Unpivot Other Columns
• b) Unpivot Selected Columns
• c) Unpivot All Columns
• d) Unpivot Non-Numeric Columns

Answer: b) Unpivot Selected Columns

55. In Power BI, what is the purpose of defining hierarchies in a data model?

• a) To group related columns together
• b) To establish relationships between tables
• c) To create parent-child relationships between columns
• d) To enable drill-down analysis in visualizations

Answer: d) To enable drill-down analysis in visualizations

56. Which DAX function is used to calculate the cumulative total of a measure up to the current row?

• a) TOTALYTD
• b) TOTALMTD
• c) TOTALQTD
• d) TOTALMTD

Answer: a) TOTALYTD

57. What is the purpose of using calculated tables in Power BI?

• a) To define relationships between tables
• b) To create new tables based on calculated expressions
• c) To perform data aggregation operations
• d) To visualize data using charts and graphs

Answer: b) To create new tables based on calculated expressions

58. Which DAX function is used to calculate the difference between two numbers as a percentage?

• a) PERCENTDIFF
• b) PERCENTCHANGE
• c) PERCENTOF
• d) PERCENTAGE

Answer: b) PERCENTCHANGE

59. What is the purpose of using bidirectional cross-filtering in Power BI relationships?

• a) To optimize performance in Power BI reports
• b) To allow filtering in both directions between related tables
• c) To restrict filtering in one direction between related tables
• d) To create circular references between related tables

Answer: b) To allow filtering in both directions between related tables

60. Which DAX function is used to calculate the compound annual growth rate (CAGR) of a measure over a specified period?

• a) CAGR
• b) XIRR
• c) IRR
• d) GROWTH

Answer: a) CAGR

61. Which Power BI visualization type is best suited for displaying trends over time?

• a) Line chart
• b) Bar chart
• c) Pie chart
• d) Scatter plot

Answer: a) Line chart

62. What is the purpose of using cross-highlighting in Power BI visualizations?

• a) To highlight data points based on predefined criteria
• b) To filter data based on selections in other visualizations
• c) To create custom tooltips for visualizations
• d) To drill down into hierarchical data structures

Answer: b) To filter data based on selections in other visualizations

63. Which Power BI feature allows users to create custom visuals using JavaScript?

• a) Power BI Embedded
• b) Power BI Custom Visuals SDK
• c) Power BI Premium
• d) Power BI Report Server

Answer: b) Power BI Custom Visuals SDK

64. What is the purpose of the "Merge Queries" operation in Power Query?

• a) To add new rows to an existing query
• b) To remove duplicate rows from a dataset
• c) To combine two or more queries into a single query
• d) To split a column into multiple columns based on delimiters

Answer: c) To combine two or more queries into a single query

65. Which Power Query transformation is used to rename columns in a dataset?

• a) Rename Columns
• b) Rename Table
• c) Transform Column
• d) Remove Columns

Answer: a) Rename Columns

66. What is the purpose of the "Replace Values" transformation in Power Query?

• a) To fill empty cells with a specified value
• b) To replace specific values in a column with another value
• c) To remove duplicate rows from a dataset
• d) To split a column into multiple columns based on delimiters

Answer: b) To replace specific values in a column with another value

67. Which Power Query function is used to generate a list of dates within a specified range?

• a) List.Generate
• b) List.Dates
• c) List.Transform
• d) List.Buffer

Answer: b) List.Dates

68. What is the purpose of the "Fill Up" operation in Power Query?

• a) To fill empty cells with the value from the cell above
• b) To delete duplicate rows from a dataset
• c) To replace null values with a specified value
• d) To remove columns that contain only null values

Answer: a) To fill empty cells with the value from the cell above

69. Which Power Query transformation is used to pivot selected columns into rows?

• a) Pivot Column
• b) Unpivot Columns
• c) Split Column
• d) Expand Column

Answer: b) Unpivot Columns

70. What is the purpose of creating calculated columns in Power BI?

• a) To perform data aggregation operations
• b) To define relationships between tables
• c) To create new columns based on calculated expressions
• d) To visualize data using charts and graphs

Answer: c) To create new columns based on calculated expressions

71. Which DAX function is used to calculate the difference between two numbers?

• a) DIFF
• b) DIFFERENCE
• c) DELTA
• d) SUBTRACT

Answer: d) SUBTRACT

72. What is the purpose of creating hierarchies in Power BI data models?

• a) To visualize data using charts and graphs
• b) To perform data aggregation operations
• c) To enable drill-down analysis in visualizations
• d) To create relationships between tables

Answer: c) To enable drill-down analysis in visualizations

73. Which DAX function is used to calculate the median of a column?

• a) MEDIAN
• b) QUARTILE
• c) PERCENTILE
• d) RANKX

Answer: a) MEDIAN

74. What is the purpose of using calculated tables in Power BI?

• a) To define relationships between tables
• b) To create new tables based on calculated expressions
• c) To perform data aggregation operations
• d) To visualize data using charts and graphs

Answer: b) To create new tables based on calculated expressions

75. Which DAX function is used to calculate the percentage change between two numbers?

• a) PERCENTCHANGE
• b) PERCENTDIFF
• c) PERCENTOF
• d) PERCENTAGE

Answer: b) PERCENTDIFF

76. Which Power BI visualization type is best suited for comparing values across different categories?

• a) Bar chart
• b) Line chart
• c) Pie chart
• d) Scatter plot

Answer: a) Bar chart

77. What is the purpose of using slicers in Power BI visualizations?

• a) To filter data based on predefined criteria
• b) To sort data in ascending or descending order
• c) To aggregate data into hierarchical structures
• d) To create relationships between data tables

Answer: a) To filter data based on predefined criteria

78. Which Power BI feature allows users to drill down into hierarchical data structures?

• a) Drill-down
• b) Drill-through
• c) Cross-filtering
• d) Hierarchical slicer

Answer: a) Drill-down

79. What is the purpose of using bookmarks in Power BI reports?

• a) To navigate between different pages in a report
• b) To apply predefined filters and slicers to visualizations
• c) To save the state of a report for later reference
• d) To export data to external formats

Answer: c) To save the state of a report for later reference

80. Which Power BI feature allows users to create custom visuals using JavaScript?

• a) Custom Visuals SDK
• b) Power BI Desktop
• c) Power BI Service
• d) Power BI Mobile

Answer: a) Custom Visuals SDK

81. What is the purpose of using cross-highlighting in Power BI visualizations?

• a) To highlight data points based on predefined criteria
• b) To filter data based on selections in other visualizations
• c) To create custom tooltips for visualizations
• d) To drill down into hierarchical data structures

Answer: b) To filter data based on selections in other visualizations

82. What is the purpose of configuring data refresh options in Power BI service?

• a) To automatically update data in published reports
• b) To customize visualizations and dashboards
• c) To manage access permissions for users
• d) To create relationships between data tables

Answer: a) To automatically update data in published reports

83. Which Power BI role allows users to publish reports and share dashboards?

• a) Viewer
• b) Contributor
• c) Admin
• d) Member

Answer: b) Contributor

84. What is the purpose of creating workspaces in the Power BI service?

• a) To visualize data using charts and graphs
• b) To deploy data to Power BI service
• c) To organize and collaborate on content
• d) To establish connections between related data tables

Answer: c) To organize and collaborate on content

85. What is the purpose of configuring row-level security in Power BI service?

• a) To define relationships between tables
• b) To restrict access to data based on user roles or permissions
• c) To create calculated columns based on conditions
• d) To manage data refresh schedules

Answer: b) To restrict access to data based on user roles or permissions

86. Which Power BI feature allows users to export reports to PowerPoint?

• a) Publish to Web
• b) Export to PDF
• c) Export to PowerPoint
• d) Export to Excel

Answer: c) Export to PowerPoint

87. What is the purpose of configuring usage metrics in Power BI service?

• a) To monitor report performance and user engagement
• b) To schedule data refreshes for on-premises data sources
• c) To define relationships between tables
• d) To create calculated measures based on conditions

Answer: a) To monitor report performance and user engagement

88. What does DAX stand for in Power BI?

• A) Data Analytics Expression
• B) Data Analysis Expressions
• C) Dynamic Analytics Extension
• D) Data Access Exchange

89. Which function is used to count the number of rows in a table in DAX?

• A) COUNT
• B) COUNTROWS
• C) ROWCOUNT
• D) SUMROWS

90. What does the CALCULATE function do in DAX?

• A) Filters data in a table or a column
• B) Adds calculated columns to a table
• C) Evaluates a Boolean expression over a table
• D) Modifies or adds filters in a CALCULATE expression

91. What does the RELATED function do in DAX?

• A) Returns a related value from another table
• B) Filters the current table based on a related column
• C) Calculates the sum of related values
• D) Removes duplicates from a related column

Answer: A) Returns a related value from another table

92. Which operator is used to reference columns in DAX?

• A) .
• B) ->
• C) ::
• D) :

Answer: D) :

93. What does the DISTINCT function do in DAX?

• A) Returns a distinct count of values in a column
• B) Removes duplicates from a column
• C) Filters a table to show only distinct rows
• D) Returns the first distinct value in a column

Answer: B) Removes duplicates from a column

94. Which function is used to add calculated columns to a table in DAX?

• A) ADDCOLUMN
• B) CALCULATE
• C) SUMMARIZE
• D) RELATEDTABLE

Answer: A) ADDCOLUMN

95. Which function is used to calculate a percentage of a total in DAX?

• A) PERCENTILE
• B) PERCENTRANK
• C) PERCENTOFTOTAL
• D) PERCENTILEX

Answer: C) PERCENTOFTOTAL

96. What does the ALL function do in DAX?

• A) Returns all the values in a column
• B) Removes all filters from a column or table
• C) Adds all the values in a column
• D) Returns all distinct values in a column

Answer: B) Removes all filters from a column or table

97. What is the purpose of the EARLIER function in DAX?

• A) Returns the previous row context
• B) Returns the parent row context
• C) Returns the first row context
• D) Returns the current row context

Answer: A) Returns the previous row context

98. What does the SUMX function do in DAX?

• A) Sums up values in a column after applying a filter
• B) Returns the sum of an expression evaluated for each row in a table
• C) Sums up values in a column ignoring any filters
• D) Returns the sum of an expression evaluated for the current row only

Answer: B) Returns the sum of an expression evaluated for each row in a table

99. What is the purpose of the RELATEDTABLE function in DAX?

• A) Returns a related table filtered by the current row
• B) Returns a table related to the current table
• C) Returns a table related to the current row
• D) Returns a table related to the specified table

Answer: B) Returns a table related to the current table

100. Which function is used to calculate moving averages in DAX?

• A) RANKX
• B) AVERAGEX
• C) MOVINGAVERAGE
• D) XIRR

Answer: C) MOVINGAVERAGE

101. What does the RANKX function do in DAX?

• A) Returns the rank of a value in a column
• B) Calculates the percentage change between two values
• C) Calculates the running total of a column
• D) Evaluates an expression for each row and returns the rank of the current row

Answer: D) Evaluates an expression for each row and returns the rank of the current row

102. What is the purpose of the TREATAS function in DAX?

• A) Treats two columns as if they were two tables
• B) Converts a table into a scalar value
• C) Treats text values as numeric values
• D) Applies a filter to a table as if it were a real table

Answer: A) Treats two columns as if they were two tables

103. What does the LOOKUPVALUE function do in DAX?

• A) Looks up a value in a table based on a condition
• B) Returns the value of a column in the current row context
• C) Returns the value from a different row based on a specified condition
• D) Looks up a value in a related table

Answer: A) Looks up a value in a table based on a condition

104. Which function is used to calculate the difference between two dates in DAX?

• A) DATEDIFF
• B) DATEDIFFERENCE
• C) DATEDELTA
• D) DATEDIFFX

Answer: A) DATEDIFF

105. What does the FORMAT function do in DAX?

• A) Formats a value as text using a specified format pattern
• B) Converts a text value to a numeric value
• C) Formats a numeric value as text using a specified format pattern
• D) Converts a numeric value to a text value

Answer: C) Formats a numeric value as text using a specified format pattern

106. Which function is used to calculate cumulative totals in DAX?

• A) TOTALMTD
• B) TOTALYTD
• C) TOTALQTD
• D) TOTALPERIOD

Answer: B) TOTALYTD

107. What is the difference between EARLIER and EARLIEST functions in DAX?

• A) EARLIER returns the previous row context, while EARLIEST returns the first row context.
• B) EARLIER returns the first row context, while EARLIEST returns the previous row context.
• C) EARLIER returns the earliest date, while EARLIEST returns the latest date.
• D) EARLIER returns the latest date, while EARLIEST returns the earliest date.

Answer: A) EARLIER returns the previous row context, while EARLIEST returns the first row context.

108. What does the GENERATE function do in DAX?

• A) Generates a new table by applying a function to each row of an existing table
• B) Generates a new column by applying a function to each value in an existing column
• C) Generates a new row by applying a function to each value in an existing row
• D) Generates a new table by joining two existing tables

Answer: A) Generates a new table by applying a function to each row of an existing table

109. What is the purpose of the CROSSFILTER function in DAX?

• A) Sets the direction of filtering between two tables
• B) Creates a cross join between two tables
• C) Applies a filter to multiple columns simultaneously
• D) Filters a table using a cross-tabulated relationship

Answer: A) Sets the direction of filtering between two tables

110. Which function is used to calculate compound interest in DAX?

• A) COMPOUNDINTEREST
• B) XIRR
• C) CUMIPMT
• D) FV

Answer: A) COMPOUNDINTEREST

111. What is the difference between ADDCOLUMNS and SUMMARIZE in DAX?

• A) ADDCOLUMNS adds calculated columns to a table, while SUMMARIZE creates a summary table by grouping and aggregating data.
• B) ADDCOLUMNS adds new rows to a table, while SUMMARIZE adds new columns to a table.
• C) ADDCOLUMNS creates a summary table by grouping and aggregating data, while SUMMARIZE adds calculated columns to a table.
• D) ADDCOLUMNS calculates a single value for each row, while SUMMARIZE creates a summary table by applying a function to each row.

112. What does the GENERATESERIES function do in DAX?

• A) Generates a series of numbers in a specified range
• B) Generates a series of dates in a specified range
• C) Generates a series of values based on a specified pattern
• D) Generates a series of rows based on a specified condition

113. What is the purpose of the USERELATIONSHIP function in DAX?

• A) Defines a relationship between two tables using non-related columns
• B) Changes the active relationship between two tables temporarily
• C) Filters one table based on the relationships defined in another table
• D) Applies a relationship filter to a column that is not directly related to another table

114. Which function is used to calculate the difference between two values as a percentage change in DAX?

• A) DIFFERENCE
• B) PERCENTDIFF
• C) PERCENTCHANGE
• D) DIVIDE

115. What does the SELECTCOLUMNS function do in DAX?

• A) Selects columns from a table based on a specified condition
• B) Creates a new table by selecting columns from an existing table
• C) Selects rows from a table based on a specified condition
• D) Creates a new table by removing columns from an existing table

116. What is the purpose of the ADDMISSINGITEMS function in DAX?

• A) Adds missing values to a column in a table
• B) Adds missing relationships between tables
• C) Adds missing rows to a table based on relationships with other tables
• D) Adds missing calculations to a column based on defined measures

117. What is the maximum number of rows that can be exported to Excel from a single table visualization in Power BI Desktop?

• a) 30,000
• b) 150,000
• c) 1,048,576
• d) 2,147,483,647

Answer: a) 30,000

118. Which of the following DAX functions does not support row context?

• a) RELATED
• b) SUMX
• c) CALCULATE
• d) FILTER

Answer: a) RELATED

119. In Power BI, what is the primary function of the "Manage Relationships" dialog box?

• a) To create calculated columns based on relationships between tables
• b) To define and manage relationships between tables
• c) To customize the appearance of visualizations in a report
• d) To import data from external sources

Answer: b) To define and manage relationships between tables

120. When using Power Query in Power BI, which option is NOT available for data cleansing?

• a) Remove duplicates
• b) Merge queries
• c) Replace values
• d) Randomize rows

Answer: d) Randomize rows