Q. Which of the following is the process of basing an organization’s actions and decisions on actual measured results of performance?

View solution

Q. Which of the following does not form part of BI Stack in SQL Server?

View solution

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

View solution

Q. Point out the correct statement.

View solution

Q. 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?

View solution

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

View solution

Q. Point out the wrong statement.

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Point out the correct statement.

View solution

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

View solution

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

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following is not supported by linked dimensions?

View solution

Q. 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.

View solution

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

View solution