Tag: architecture

Questions Related to architecture

Which OWB module is used to design the DW and the ETL processes. This component also includes bridges, integrators, and editors and acts as a point of access to other OWB components.
technology architecture

  1. OWB Repository

  2. OWB Runtime Audit Browser

  3. OWB Runtime Assistant

  4. OWB Client

  5. OWB Design Browser Client

Show answer
Correct Option: D

Which OWB client is used to view metadata, run web reports, perform lineage, and impact analysis on your metadata.

technology architecture

  1. OWB Design Browser Client

  2. OWB Repository

  3. OWB Client

  4. OWB Runtime Assistant

  5. OWB Runtime Audit Browser

Show answer
Correct Option: A

Which client helps you to run reports on the audit and error information captured when you run jobs to load and refresh your ETL processes.

technology architecture

  1. OWB Repository

  2. OWB Client

  3. OWB Runtime Assistant

  4. OWB Runtime Audit Browser

  5. OWB Design Browser Client

Show answer
Correct Option: D

Which OWB client helps you to set up a runtime repository and target schema and maintain the deployment and runtime audit/error information.

technology architecture

  1. OWB Repository

  2. OWB Client

  3. OWB Design Browser

  4. OWB Runtime Audit Browser

  5. OWB Runtime Assistant

Show answer
Correct Option: E

How many components are present in OWB architecture?
technology architecture

  1. 5

  2. 1

  3. 2

  4. 4

  5. 3

Show answer
Correct Option: C

Which editor defines the source/target modules and editing modules (containers or collection of the DW objects).
technology architecture

  1. Code Editor

  2. Module Editor

  3. Mapping Editor

  4. Text Editor

  5. Object Editor

Show answer
Correct Option: B

Which editor includes the table editor, dimension editor, fact editor etc. that enable you to edit object properties.
technology architecture

  1. Client Editor

  2. Dimension Editor

  3. Fact Editor

  4. Object Editor

  5. Text Editor

Show answer
Correct Option: D

Which editor enables you to design and configure how the data gets loaded into the target data warehouse, and is used to design a graphical representation of the relation between the data source objects that are used to populate the data warehouse target objects. The editor provides a set of operators that you can include with the mappings along with standard or custom transformations if required, such as key look, generating sequence etc. It also enables validation and generation of the code used to populate the data warehouse target.
technology architecture

  1. Mapping Editor

  2. Transformation Editor

  3. Repository Editor

  4. Object Editor

  5. Code Editor

Show answer
Correct Option: A

Which enables editing or customizing OWB generated code.
technology architecture

  1. Object Editor

  2. Code Editor

  3. Audit Editor

  4. Module Editor

  5. Code Manager

Show answer
Correct Option: B

The OWB runtime component includes 2 components, which enables you to view the runtime information of the ETL jobs that were executed using Oracle tools such as Oracle Enterprise manager (OEM).What are they?
technology architecture

  1. Runtime repository and Object viewer

  2. Client Viewer and Deployment manager

  3. Runtime repository and Audit viewer

  4. Repository and Repository service

Show answer
Correct Option: C