This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Analysis Services – 2”.
1.In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.
a) Translation
b) Dimension translation
c) Dim translation
d) None of the mentioned
View Answer
Explanation: Translations provide server support for client applications that can support multiple languages.
2. Point out the correct statement.
a) The collation and language information for the client computer is stored in the form of a locale identifier (LCID)
b) SQL Server 2008 Analysis Services also supports translations of cube objects
c) SQL Server 2000 Analysis Services supports translations of cube objects
d) None of the mentioned
View Answer
Explanation: The instance uses the LCID to determine which set of translations to use when providing metadata for Analysis Services objects.
3. Members of a _________ dimension can only be moved within the same level.
a) readback
b) writeback
c) readwrite
d) all of the mentioned
View Answer
Explanation: For a write-enabled dimension, updates are recorded directly in the dimension’s table.
4. Updates to the ______ attribute in a parent-child hierarchy must not include updates to any other properties or attributes.
a) child
b) parent
c) both child and parent
d) none of the mentioned
View Answer
Explanation: If a member of a parent-child hierarchy is deleted, the member’s children are moved to the member’s parent.
5. Point out the wrong statement.
a) The data in a dimension is generally read-write both
b) Upon connection, the client passes the LCID to the instance of Analysis Services
c) For a write-enabled cube or partition, updates are stored in a writeback table separate from the cube’s source tables
d) All of the mentioned
View Answer
Explanation: The data in a dimension is generally read-only.
6. Which of the following is not supported by linked dimensions?
a) readback
b) writeback
c) readwrite
d) all of the mentioned
View Answer
Explanation: In Microsoft SQL Server 2005 Analysis Services (SSAS), a linked dimension is based on a dimension that is stored in another Analysis Services database.
7. 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.
a) Dim
b) KEY
c) PK
d) None of the mentioned
View Answer
Explanation: Typically, the key attribute represents the primary key column or columns in the dimension table.
8. Which of the following property is set to zero so that all levels are not created?
a) Aggregatable
b) IsAggregatable
c) IsAggregate
d) All of the mentioned
View Answer
Explanation: The All level contains the aggregated value of the attribute’s members across the measures in each measure group to which the dimension of which the attribute is related is a member.
9. By default, in a ________ schema, all attributes are directly related to the key attributes.
a) Relational
b) Snowflake
c) Star
d) None of the mentioned
View Answer
Explanation: Star schema enables users to browse the facts in the cube based on any attribute hierarchy in the dimension.
10. Parent-child hierarchies are automatically detected by the _________ Wizard.
a) Dimension
b) Cube
c) Dimension and Cube
d) None of the mentioned
View Answer
Explanation: A multilevel hierarchy is a parent-child hierarchy based on parent-child relationships defined in the underlying dimension table.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
- Practice Programming MCQs
- Apply for Programming Internship
- Check SQL Server Books
- Check Information Technology Books
