Database Management Systems

BINDADD is the privilege required to create new packages in a DB2 database. CONTROL is a high-level privilege, BIND allows binding packages, and EXECUTE allows running them. BINDADD specifically grants the ability to create packages, which is different from BIND (re-binding existing packages).

SYSCAT.TABAUTH contains grantee information for table and view privileges including REFERENCE. SYSCAT.VIEWS has view metadata, SYSCAT.TABLES has table metadata, and SYSCAT.REFERENCES doesn't exist as a separate catalog view. TABAUTH is the authorization catalog tracking who has what privileges.

Indexes can enforce uniqueness via unique constraints, ensuring no duplicate values. Tables are unordered sets (ordered only via ORDER BY), indexes can be ascending or descending, and views are virtual tables storing no data themselves (queries run on demand).

When a DB2 database is created, the system automatically creates default tablespaces: SYSCATSPACE (for the system catalog), TEMPSPACE1 (for system temporary tables), and USERSPACE1 (the default space for user tables). SYSLOGSPACE is not a default tablespace.

EXTENTSIZE defines the number of pages written to a container before moving to the next. STRIPSIZE is for striping across containers, PREFETCHSIZE is for read-ahead, and SKIPSIZE is not a standard database storage parameter. The extent is the fundamental allocation unit.

A logical dimension hierarchy is built on a single logical dimension table, representing hierarchical levels of attributes within that dimension. It cannot span across two distinct logical dimension tables, making the statement false.

In the physical layer of an RPD, a Connection Pool is the specific component that defines the connection parameters, such as data source name, user credentials, and connection limits, used to connect to a physical database.

A data mart is a specialized subset of enterprise data warehouse data, focused on a specific business unit, department, or functional area. Unlike the broader enterprise data warehouse which serves the entire organization, data marts provide tailored views for specific user communities.

The EXPLAIN facility in Teradata displays the execution plan for a query without actually running it. This shows how the optimizer will process the query, including join strategies, index usage, and data movement steps across AMPs. It's essential for performance tuning.

Application Source Qualifier in Informatica PowerCenter is specifically designed to work with Salesforce.com sources, allowing data extraction from Salesforce. COBOL sources use COBOL source definitions, XML sources use XML Source Qualifiers, and relational sources use standard Source Qualifiers.

To answer this question, the user needs to have an understanding of the Microsoft SQL BI tool components and their respective functionalities.

SSAS (SQL Server Analysis Services) is a component of the Microsoft SQL BI tool that enables data analysis and mining by creating OLAP cubes. It is not used for creating or rendering reports.

SSIS (SQL Server Integration Services) is a component of the Microsoft SQL BI tool that is used to perform data integration tasks such as data extraction, transformation, and loading. It is not used for creating or rendering reports.

SSRS (SQL Server Reporting Services), on the other hand, is a component of the Microsoft SQL BI tool that supports the creation and rendering of reports. It provides a platform for designing, publishing, and delivering reports to end-users. Therefore, option C is the correct answer.

SQL RDBMS (Relational Database Management System) is a general term that refers to software systems used to manage relational databases. It is not a specific component of the Microsoft SQL BI tool and does not support the creation or rendering of reports.

Therefore, the answer is: C. SSRS.

To understand the concept of Business Intelligence, it is the process of transforming data into actionable insights to help businesses make informed decisions.

To answer this question, the user must know the definition of Business Intelligence. Now, let's go through each option and explain why it is right or wrong:

A. A method of storing and presenting key enterprise data: This option is partially correct, but it does not encompass the entire concept of Business Intelligence. While storage and presentation of enterprise data is a part of BI, it is not the full picture.

B. Allows End users to analyze data to understand business results: This option is also partially correct. BI tools allow end-users to analyze data to understand business results. But again, it is not the complete definition of BI.

C. To accurately forecast future results: This option is incorrect. While BI can help businesses forecast future results, it is not the sole purpose of BI.

D. All of the above: This option is the correct answer. Business Intelligence involves storing and presenting data, analyzing data to understand business results, and accurately forecasting future results. Therefore, option D is the correct answer.

The Answer is: D

To answer this question, the user needs to be familiar with the Microsoft SQL BI toolset and its components.

A. SSAS (SQL Server Analysis Services) is a service that performs online analytical processing (OLAP) and data mining functionalities. It is used for creating and managing data models and providing access to multidimensional data. It does not provide ETL kind of activities.

B. SSIS (SQL Server Integration Services) is a server for data integration and workflow applications. It is used for building and maintaining data integration workflows. It provides ETL (Extract, Transform, Load) functionalities. Therefore, this option is correct.

C. SSRS (SQL Server Reporting Services) is a server-based reporting platform that is used for creating and publishing reports. It does not provide ETL kind of activities.

D. SQL RDBMS is a relational database management system that provides the ability to store, manage, and retrieve data. It does not provide ETL kind of activities.

Therefore, the answer is:

The Answer is: B. SSIS

SQL Server Analysis Services (SSAS) is the Microsoft BI service specifically designed for creating and managing OLAP cubes and multidimensional databases. SSIS handles ETL, SSRS handles reporting, and SQL RDBMS is the relational database engine - none of these create OLAP databases.

A dimensional hierarchy must be built within a single dimension table using parent-child relationships or level-based columns. You cannot build a hierarchy across two separate logical dimension tables because hierarchies require all levels to exist in one table with defined relationships.