🧪 SSAS MCQ Quiz Hub

SQL Server Questions and Answers – Analysis Services Set 1

Choose a topic to test your knowledge and improve your SSAS skills

1. The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services.




2. Point out the correct statement.




3. Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created?




4. ________ let you create external, user-defined functions using any common language runtime (CLR) language.




5. Point out the wrong statement.




6. Which of the following permission setting provides internal computation permission?




7. If the __________ setting is used, the execution context corresponds to the Windows login user account IUSER_servername on the server.




8. Which of the following namespace discover set of assemblies?




9. Security for stored procedures is set with the _________ property on a stored procedure.




10. If functions in one assembly call functions in a separate assembly, you must register both assemblies in ____________




11. In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.




12. Point out the correct statement.




13. Members of a _________ dimension can only be moved within the same level.




14. Updates to the ______ attribute in a parent-child hierarchy must not include updates to any other properties or attributes.




15. Point out the wrong statement.




16. Which of the following is not supported by linked dimensions? a) b) c)




17. The _______ attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact table.




18. Which of the following property is set to zero so that all levels are not created?




19. By default, in a ________ schema, all attributes are directly related to the key attributes.




20. Parent-child hierarchies are automatically detected by the _________ Wizard.




21. ____ is currency used to store transactions on which measures to be converted are based in SSAS.




22. Point out the correct statement.




23. For _________ currency conversions, the pivot currency and reporting currency are the same.




24. You can use the __________ Wizard to specify which measures from the rate measure group are used to convert values.




25. Point out the wrong statement.




26. If you select the __________ conversion type, a reporting currency dimension is also created.




27. Which of the following Sort order sorts and compares data in Analysis Services based on the bit patterns defined for each character?




28. _________ distinguishes between a single-byte character and the same character when represented as a double-byte character.




29. Which of the following property enables Analysis Services to use a faster algorithm for string hashing and comparison?




30. __ lets you manage cube context from within an MDX script.




31. Point out the correct statement.




32. ___ causes the server to raise an error when Microsoft SQL Server Analysis Services finds any error in the MDX script.




33. The Backus-Naur Form (BNF) of {*(<comment> | <whitespace> | <newline>)} will be parsed as ______ for backwards compatibility.




34. Point out the wrong statement.




35. _____ creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube.




36. The following code is a syntax of which statement? CREATE [ SESSION ] [HIDDEN] [ CALCULATED ] MEMBER CURRENTCUBE | Cube_Name.Member_Name AS MDX_Expression [,Property_Name = Property_Value, ...n] ......[,SCOPE_ISOLATION = CUBE]




37. Which of the following is valid syntax for CREATE GLOBAL CUBE?




38. Which of the following is the MDX Data Definition Statement? a)




39. _________ is the set of hierarchies from which data is retrieved for a single member.




40. Point out the correct statement.




41. When you include a many-to-many dimension, which of the following rules apply?




42. ______ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.




43. Point out the wrong statement.




44. Which of the following scenario demonstrates USE_EQUAL_INCREMENT allocation method?




45. If a weight expression is not specified, the UPDATE CUBE statement implicitly uses which of the following expression?




46. When used on a measure that contains integers, the _________ method can return imprecise results caused by incremental rounding changes.




47. Which of the following is valid syntax for DRILLTHROUGH statement?




48. Which of the following keyword forces a specified set to be evaluated within the current context?




49. Which of the following tool requires Reporting Services in SharePoint mode?




50. Point out the correct statement.




51. ________ does not help you manage report server content, enable additional features, or grant access to the server.




52. ____ is a tool to configure and manage a report server connection to the report server database.




53. Point out the wrong statement.




54. Which of the following is a tool for Report Content Management?




55. Which of the following mode lets you interact with the report server, reports, and report related items by using a browser with Report Manager or URL access commands?




56. Reports use __________ to retrieve data for a report when a query runs or when the report is processed.




57. A _________ is an item stored internally in an alerting database.




58. A __________ is a report server item that contains a pointer to the report definition.




59. A _________ report solution includes a main report that displays summary information with hyperlinks to one or more reports that display detailed information.




60. Point out the correct statement.