Database Management Systems

In MicroStrategy, Report Filters apply conditions directly at the data warehouse level by modifying the SQL WHERE clause sent to the database. View Filters are applied after data retrieval, filtering the result set already returned from the warehouse. This distinction is crucial for query performance optimization.

Prompts in MicroStrategy are interactive objects that appear during report execution, allowing users to select specific values or elements dynamically. This enables parameterized reports without modifying the report definition. Filters are predefined static conditions set by the report designer.

Consolidations in MicroStrategy are custom groupings created by combining specific attribute elements into logical sets. For example, you can create a consolidation called 'West Coast' by grouping specific state attribute elements like 'CA', 'OR', 'WA'. They are not created from filters, which are conditions rather than element groupings.

MicroStrategy provides multiple view types for reports: Graph View displays data as charts and visualizations, SQL View shows the generated database query for debugging, and Design View allows editing the report structure. Report View typically refers to the standard grid/data display, which is a display mode rather than a distinct named view type in this context.

A database view is a virtual table representing the result of a pre-defined SQL query. It does not store data physically but can be queried using standard SQL commands just like a normal table. Distractors are incorrect because views can be accessed via SQL, unlike tables which physically store data.

DBA stands for Database Administrator, the person responsible for managing database systems. Option A correctly uses 'Database' and 'Administrator'. Option B incorrectly uses 'Device' and 'Base'. Option C is nonsensical. Option D has a typo 'Datebase' instead of 'Database'.

DFD stands for Data Flow Diagram, used to visualize the flow of data through a system. Option D correctly uses 'Data Flow' twice - data flowing through processes. Options A, B, and C incorrectly use variations like 'Fnd' (typo) and 'Fast' which are not part of the term.

Teradata provides multiple mechanisms to enable joins to occur on the same AMP: identical primary indexes naturally distribute matching rows to the same AMP; dynamic redistribution can rehash tables during query processing; and duplicating small tables across all AMPs eliminates data movement. All three are valid join optimization strategies.

Ab Initio's valid datatypes include datetime, decimal, and various numeric types, but does not have a generic "number" datatype. The correct numeric types are specific types like int, decimal, float, etc. "void" is typically used in programming languages but not as a datatype in Ab Initio's DML.

Sort within Group is used when data is already sorted by a major key and you need to sort within each group of that major key. The major-key parameter specifies the key that the input is already pre-sorted on, allowing the component to perform secondary sorting within each group efficiently.

This question asks which statement about conditional DML is FALSE. The correct answer is D because conditional fields CANNOT share delimiters with the record - each conditional field must have its own delimiter specification. Options A, B, C, and E are all true statements about conditional DML fields in Ab Initio.

The Reformat component in Ab Initio is specifically designed to transform data structure - it can add fields, drop fields, or change field layouts. Sort only orders data, Join combines data, and Redefine Format changes DML interpretation. For adding/dropping fields, Reformat is the correct choice.

In Ab Initio DML, valid types include string, decimal, integer, date, datetime, and others. 'char' is NOT a valid DML type in Ab Initio - the correct type for character data is 'string' (or 'vector(string)' for arrays). Char might be confused with SQL character types, but Ab Initio DML uses 'string' instead.

Date and Datetime types in Ab Initio are stored in binary form for efficiency in calculations and comparisons. While integers are also stored in binary, the question specifically asks about types known for binary storage of temporal data. Decimal stores as packed decimal, and string stores as character data. Date/Datetime is the best answer for binary-encoded temporal data.