MS SQL Server - 89 - OLAP Query Functions MCQ

89 – OLAP Query Functions MCQ

1 / 25

1. What is the primary purpose of the SUM function in OLAP queries in SQL Server?

D. Sorting data

B. Calculating the average of values

A. Counting the number of rows

C. Aggregating numeric values

2 / 25

2. Which OLAP query function is commonly used to calculate the average of a numeric column?

A. MAX

D. COUNT

B. MIN

C. AVG

3 / 25

3. In SQL Server, what does the RANK() function do?

C. Counts the number of rows

D. Filters rows based on a condition

B. Assigns a unique rank to each row within a result set

A. Calculates the sum of values

4 / 25

4. What is the primary purpose of the NTILE() function in SQL Server?

D. Dividing the result set into roughly equal parts or percentiles

B. Assigning a rank to each row based on specified criteria

C. Aggregating values within groups

A. Calculating the median of a numeric column

5 / 25

5. Which OLAP query function is used to assign a rank to each row within a result set, leaving gaps for tied values?

D. PERCENT_RANK()

A. DENSE_RANK()

C. ROW_NUMBER()

B. RANK()

6 / 25

6. In SQL Server, what does the PERCENTILE_CONT() function calculate?

A. The median of a numeric column

C. The average of values

D. A specific percentile value within a numeric column

B. The sum of values

7 / 25

7. Which function in SQL Server is used to calculate the sum of values within a group?

D. MIN()

A. COUNT()

B. SUM()

C. AVG()

8 / 25

8. What is the purpose of the DENSE_RANK() function in SQL Server?

B. Calculating the median of a numeric column

D. Aggregating values within groups

C. Filtering rows based on a condition

A. Assigning a rank to each row within a result set, leaving no gaps for tied values

9 / 25

9. In SQL Server, what does the PERCENT_RANK() function calculate?

C. The average of values

D. The relative rank of each row within a result set

B. The sum of values

A. The median of a numeric column

10 / 25

10. Which statistical aggregate function in SQL Server returns the variance of a numeric column’s values?

B. STDEV()

C. SUM()

D. COUNT()

A. VAR()

11 / 25

11. What does the COUNT() function do in OLAP queries in SQL Server?

D. Assigns ranks to rows

A. Calculates the average of values

B. Counts the number of rows in the result set

C. Aggregates numeric values

12 / 25

12. In SQL Server, which function returns the standard deviation of a numeric column’s values?

A. VAR()

B. STDEV()

C. SUM()

D. COUNT()

13 / 25

13. What is the purpose of the MEDIAN() function in OLAP queries in SQL Server?

A. Calculating the sum of values

D. Filtering rows based on a condition

C. Finding the middle value of a numeric column's values

B. Assigning ranks to rows

14 / 25

14. In SQL Server, what does the LEAD() function do in OLAP queries?

C. Retrieves the next value in a result set

D. Aggregates values within groups

A. Calculates the sum of values

B. Assigns a rank to each row based on specified criteria

15 / 25

15. Which statistical aggregate function in SQL Server returns the covariance between two numeric columns?

C. STDEV()

A. COVAR()

D. SUM()

B. VAR()

16 / 25

16. What is the primary purpose of the ROW_NUMBER() function in SQL Server?

C. Finding the median of a numeric column's values

D. Aggregating values within groups

A. Calculating the sum of values

B. Assigning a unique number to each row within a result set

17 / 25

17. Which OLAP query function is used to calculate the mode of a numeric column’s values?

A. MODE()

B. MEDIAN()

D. SUM()

C. COUNT()

18 / 25

18. In SQL Server, what does the LAG() function do in OLAP queries?

B. Assigns a rank to each row based on specified criteria

C. Retrieves the previous value in a result set

A. Calculates the sum of values

D. Aggregates values within groups

19 / 25

19. What is the purpose of the MODE() function in OLAP queries in SQL Server?

C. Retrieving the most frequently occurring value in a column

A. Calculating the sum of values

D. Assigning ranks to rows

B. Finding the middle value of a numeric column's values

20 / 25

20. Which statistical aggregate function in SQL Server returns the correlation coefficient between two numeric columns?

C. VAR()

B. COVAR()

D. SUM()

A. CORR()

21 / 25

21. What does the COUNT DISTINCT() function do in SQL Server?

C. Aggregates numeric values

D. Assigns ranks to rows

A. Counts the number of rows in the result set

B. Counts the number of distinct values in a column

22 / 25

22. In SQL Server, what does the FIRST_VALUE() function do in OLAP queries?

B. Retrieves the first value in a result set

A. Calculates the sum of values

D. Aggregates values within groups

C. Assigns ranks to rows

23 / 25

23. Which statistical aggregate function in SQL Server returns the sum of the squares of a numeric column’s values?

A. SUMSQ()

D. SUM()

B. VAR()

C. STDEV()

24 / 25

24. What is the purpose of the PERCENTILE_DISC() function in OLAP queries in SQL Server?

B. Finding the median of a numeric column's values

C. Retrieving the specified percentile value within a numeric column

A. Calculating the sum of values

D. Assigning ranks to rows

25 / 25

25. In SQL Server, what does the NTH_VALUE() function do in OLAP queries?

C. Assigns ranks to rows

A. Calculates the sum of values

B. Retrieves the nth value in a result set

D. Aggregates values within groups

Your score is

MS SQL Server – 89 – OLAP Query Functions MCQ