Enterprise Technology Fundamentals: ETL, Databases, BI & Networking

EIGRP (Enhanced Interior Gateway Routing Protocol) is a hybrid routing protocol that combines features of both distance-vector (like IGRP and RIP) and link-state (like OSPF) protocols. It uses DUAL algorithm for loop prevention and fast convergence.

RIP version 1 is a classful routing protocol that does not support VLSM (Variable Length Subnet Masking) or CIDR. IGRP, OSPF, and EIGRP all support VLSM. RIP v2 added VLSM support.

LDAP (Lightweight Directory Access Protocol) uses port 389 for standard communication and port 636 for LDAPS (LDAP over SSL). Port 110 is for POP3, 443 is for HTTPS, and 689 is not a standard LDAP port.

BusinessObjects has predefined access levels that control user permissions. 'View' allows read-only access to content. 'Schedule' permits users to schedule reports for automated execution. 'View on Demand' is a valid access level for interactive viewing. 'Schedule on Demand' is not a standard predefined access level in BusinessObjects.

Central Management Console (CMC) is the primary administration interface for BusinessObjects Enterprise. It manages server configuration (A), user/group administration (B), and security settings for all content (C). However, CMC cannot directly add reports to the repository: that function requires the Import Wizard or publishing tools, making D the correct answer.

The BusinessObjects Processing Tier contains servers that execute background and on-demand processing tasks. Job Server handles scheduled jobs, Web Intelligence Report Server processes WI report requests, and Report Application Server processes Crystal Reports. File Repository Server is part of the Intelligence Tier, storing object files, not the Processing Tier.

BusinessObjects Enterprise architecture uses a tiered model. Application tier handles web/desktop client interactions (launchpad, CMC). Intelligence tier contains the semantic layer (universes) and report generation engines. Processing tier executes background jobs and report processing. 'Datastore tier' is not a standard tier name in BO architecture.

The Input File Repository Server (FRS) is a core BusinessObjects component that stores and manages all published report objects, program files, and other assets in the repository. It handles the actual file storage and retrieval for the system, making the statement True.

WebIntelligence reports can be exported to multiple formats including PDF, CSV, and XLS for distribution and analysis. However, DOC (Microsoft Word) format is not a standard export option in WebIntelligence: reports cannot be directly saved as Word documents.

In Universe Designer, List of Values (LOV) for objects can be created, edited, and managed. LOVs provide dropdown values for users when building queries. This is a standard feature of Universe Designer, so the statement is True.

Desktop Intelligence supports multiple drill modes for data exploration. 'Drill by' allows drilling down through hierarchy levels. 'Drill Through' enables drilling from summarized data to detailed source data. 'Drill On' is not a standard drill mode name in Desktop Intelligence: this appears to be a distractor.

The Optimizer is the specific component of the Teradata Parsing Engine (PE) that generates the least expensive execution plan for a query. While the Parser handles syntax analysis, the Optimizer handles plan generation.

Teradata supports a maximum of 2048 columns in a single table. This is a hard limit in the Teradata database architecture. Options like 256, 512, or 1024 columns are too low and don't represent Teradata's actual column capacity.

Archive/Recovery utility is designed to copy tables (archive) and restore them to another database (recovery). BTEQ is for query processing, Table rebuild is for rebuilding damaged tables, and FastLoad is for high-speed initial data loading into empty tables.

In Informatica PowerCenter, mapplets have restrictions on which transformations can be included. Normalizer transformations cannot be used in mapplets because they require special session properties. XML Source Qualifier transformations are also prohibited as they need specific XML session configuration. Additionally, mapplets cannot contain other mapplets to avoid circular dependencies. Aggregators, sequences, lookups, and unions are allowed in mapplets.

The RR format code interprets two-digit years relative to the current century (assuming cutoff year 50), so 04/12/98 with RR becomes 04/12/1998. The YY format interprets years literally within the current century's window, so 11/09/01 with YY becomes 11/09/1901. The RR format is Y2K-compliant as it intelligently handles century rollover, while YY has a fixed interpretation that can place dates in the wrong century.

Informatica provides transaction control variables for managing session commits. TC_CONTINUE_TRANSACTION keeps the transaction open, TC_COMMIT_BEFORE commits before processing, and TC_ROLLBACK_BEFORE rolls back before processing. TC_STOP_TRANSACTION is not a valid transaction control variable - the correct options for stopping are handled through transaction settings or workflow conditions, not this variable name.