Jose Miguel Montalbán
Test por , creado hace más de 1 año

Oracle

5107
4
0
Jose Miguel Montalbán
Creado por Jose Miguel Montalbán hace casi 9 años
Cerrar

Oracle Data Integrator 12C Essentials

Pregunta 1 de 79

1

You need to implement security mechanisms that allow only user "A" to view all the Mappings contained in a specific project named "P1." How must you proceed? (Choose the best answer.)

Selecciona una de las siguientes respuestas posibles:

  • Go to Security, assign the NG DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally setView privileges to Active for the Mapping objects.

  • Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Mapping objects.

  • Go to Security, assign the NG DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.

  • Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.

Explicación

Pregunta 2 de 79

1

You must modify the order in which data stores are being journalized in a model.
What sequence of steps do you follow to achieve this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Open the model, go to the Journalizing tab, and modify the order there.

  • Right-click Datastore, select Changed Data Capture, and then select Order.

  • Open the model, go to the Journalized tables tab, and modify the order there.

  • Open the data stores, go to the Journalizing tab, and modify the order there.

Explicación

Pregunta 3 de 79

1

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.

  • It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.

  • It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.

  • It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

Explicación

Pregunta 4 de 79

1

Which statement is correct about choosing the join order in an ODI Mapping when defining a join? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • This option is inherited from reverse engineering.

  • This option is always available.

  • You can never make this choice.

  • This option may be available only if the underlying technology supports it.

Explicación

Pregunta 5 de 79

1

You need to reverse engineer a flat file that contains multiple record formats. How must you
proceed? (Choose the best answer.)

Selecciona una de las siguientes respuestas posibles:

  • Create a Data Server by using the File technology and specify the various record formats while reverse engineering the file.

  • Create a Data Server by using the XML technology, create an nXSD file by using the Native Format Builder, and then reverse engineer it in a Model

  • Create a Data Server by using the File technology, create an nXSD file by using the Native Format Builder, and then reverse engineer it in a Model.

  • Create a Data Server by using the Complex File technology, create an nXSD file by using the NativeFormat Builder, and then reverse engineer it in aModel.

Explicación

Pregunta 6 de 79

1

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • extracting source data to flat files

  • triggers

  • Oracle GoldenGate

  • before-and-after database image comparison

Explicación

Pregunta 7 de 79

1

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • conditions

  • foreign keys

  • primary keys

  • alternate keys

  • not null

Explicación

Pregunta 8 de 79

1

How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Use a dedicated schema such as ODI_STAGING.

  • Use TEMP.

  • Use the same schema as the Data Schema.

  • Use SYSTEM.

Explicación

Pregunta 9 de 79

1

You want to modify the code generated by a failed Task and restart the session. How must you proceed? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Open the Task in Operator, go to Code, click Edit, use Pre-execution Code to edit the code, andsave it.

  • It is not possible to modify the code once it has been generated.

  • Open the Step in Operator, edit the code, and save it.

  • Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it.

Explicación

Pregunta 10 de 79

1

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this? (Choose the best answer)

Selecciona una o más de las siguientes respuestas posibles:

  • Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design.

  • Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.

  • Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.

  • Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design.

Explicación

Pregunta 11 de 79

1

You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How must you implement this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Create a custom KM to handle this by using ODI variables defined at the Topology level to createunique temporary object names.

  • Use variables in the Logical Design of the Mapping to create unique temporary object names.

  • Create a custom Knowledge Module (KM) to handle this by using ODI variables to create uniquetemporary object names.

  • Select the Use Unique Temporary Object Names check box at the Physical Design level.

Explicación

Pregunta 12 de 79

1

Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • Run Exception and Restart

  • Run Exception and Continue

  • Run Exception and Ignore

  • Run Exception and Fail

  • Run Exception and Raise

Explicación

Pregunta 13 de 79

1

How are the ODI repositories upgraded? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • by using Opatch

  • by using ODI Studio

  • by using the import/export utilities

  • by using Upgrade Assistant

Explicación

Pregunta 14 de 79

1

Which are the two correct statements about Work repositories? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • They contain project and security information.

  • They contain data models and execution information.

  • They contain data and security information

  • They contain data models and project information.
    Answer:

Explicación

Pregunta 15 de 79

1

You are setting up the topology for an infrastructure with three different environments: Dev, QA, and Prod. How must you create Logical Schemas? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Create one Logical Schema per Physical Schema.

  • Create one Logical Schema per Physical Schema that stores the same type of data.

  • Create one Logical Schema per Data Server.

  • Create one Logical Schema per Context.

Explicación

Pregunta 16 de 79

1

You need to create a package that automatically sends an alert to users in case the third step fails.Which option represents the steps to accomplish this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a greenOK arrow.

  • Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KOarrow.

  • Add anOdiReadMailstep to My Package and link the My Third Package step to it by using a red KOarrow.

  • Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a red KOarrow.

Explicación

Pregunta 17 de 79

1

You want to override the code generated by ODI and provide a custom SQL statement as the source of a Mapping. How must you proceed? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Duplicate theIntegration Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it withinthe Mapping.

  • Duplicate the Check Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within theMapping.

  • In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options, andenter the SQL statement in theCUSTOM_TEMPLATEfield.

  • Duplicate the Loading Knowledge module, add an optionCUSTOM_TEMPLATE, and set it within theMapping

Explicación

Pregunta 18 de 79

1

You design a package with mappings that consume data from journalized data stores in Consistent Set CDC mode. Which option represents the steps that must be performed at the beginning of your package to accomplish this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Add data stores to the package, set Datastores steps to Journalizing Datastore, and select theExtend Window and Lock Subscriber check boxes.

  • Add data stores to the package, set Datastores steps to Journalizing Datastore, and select theUnlock Subscriber and Purge Journal check boxes.

  • Add a model to the package, set the Model step to Journalizing Model, and select the ExtendWindow and Lock Subscriber check boxes.

  • Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select theExtend Window and Lock Subscriber check boxes.

Explicación

Pregunta 19 de 79

1

Which is the correct statement about the contents of Master repositories? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • They contain data model and security information.

  • They contain security and topology information.

  • They contain project and topology information.

  • They contain project and security information.

Explicación

Pregunta 20 de 79

1

Identify the correct variable step type to use when assigning a value to a variable with an SQL query. (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Evaluate Variable

  • Set Variable

  • Declare Variable

  • Refresh Variable

Explicación

Pregunta 21 de 79

1

Identify two correct statements about reusable Mappings. (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • They can have generic input and output signatures.

  • They contain both a Logical and Physical Mapping design.

  • They can be used within regular Mappings.

  • They can be executed directly.

  • They can be shared across projects.

Explicación

Pregunta 22 de 79

1

You are designing a load plan in which you must run Mappings A and B one after the other while running Mapping C at the same time. Which option represents the steps to accomplish this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Add a parallel step, add three serial steps underneath it, then addAto the first parallel step, B to the second one, and C to the last one.

  • Create a scenario from the variable and add the scenario to the load plan to create a case step

  • Add a parallel step, add two parallel steps underneath it, then add A and B tooneparallel step, and C to the other.

  • Add a parallel step, add two serial steps underneath it, then add A and B to one serial step, and C to the other.

Explicación

Pregunta 23 de 79

1

Which two statements are true about big data support in ODI? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • ODI uses its own transformation engine to process data in a Hadoop cluster.

  • ODI performs data transformations inside a Hadoop cluster.

  • ODI must perform data transformations outside Hadoop in an Oracle database.

  • ODI allows moving data in and out of a Hadoop cluster.

Explicación

Pregunta 24 de 79

1

The source and target data stores are located on the same data server. Which statement is correct about the need for a Loading Knowledge Module to load the data on the target? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Only an Integration KnowledgeModule single-technology is required.

  • Only an Integration Knowledge Module multitechnology is required.

  • A loading Knowledge Module multitechnology and an IntegrationKnowledgeModulesingletechnology are required.

  • Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required.

Explicación

Pregunta 25 de 79

1

You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Create a single Mapping with two Physical Designs: one for the initial load and one for the incremental updates.

  • Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required.

  • Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.

  • Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

Explicación

Pregunta 26 de 79

1

Which tables created by ODI contain error records? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • ERR$

  • ERROR$

  • ODI_ERR$

  • E$

Explicación

Pregunta 27 de 79

1

You are a project developer using ODI and want to consolidate your own local metadata repositories. Identify the true statement. (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • You must consolidate your own local metadata repositories. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developers.

  • You must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bus

  • You need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common metadata of a specific project.

  • You need not consolidate yourown local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.

Explicación

Pregunta 28 de 79

1

Updates have been made to Mappings in a package. What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenario's schedule? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Regenerate the existing scenario.

  • Nothing, the existing scenario will automaticallybe updated.

  • Generate a new scenario and create a new schedule.

  • Generate a new scenario and attach the previous scenario's schedule to it.

Explicación

Pregunta 29 de 79

1

You must send the same message in multiple packages to several email addresses stored in
the same database table. How do you accomplish this by using a reusable package step? (Choose the
best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Create a procedure and add two tasks. The first one must have a Command on Source that reads
    the email addresses from the database table and stores them in a bind variable, and the second must
    have a Command on Target that usesOdiSendMailto send the email by using the bind variable
    defined in the first task.

  • Createa Knowledge Module. Add a task with a Command on Source that reads the email addresses
    from the database table and stores them in a bind variable, and a Command on Target that
    usesOdiSendMailto send the email using the bind variable defined in the Command on Source.

  • Create a counter variable that gets the total number of email addresses stored in the database
    table. Next, create another variable that selects the email addresses from the database table. Then,
    create a loop in the packages by using the variables and anOdiSendMailstep.

  • Create a procedure. Add a task with a Command on Source that reads the email addresses from
    the database table and stores them in a bind variable, and a Commandon Targetthat
    usesOdiSendMailto send the email using the bind variable defined in the Command on Source.

Explicación

Pregunta 30 de 79

1

As part of your QA process you want to view code at the Step level in Operator. How must you proceed? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • It is only possible to see code at the Session level.

  • It is only possible to view code at the Task level.

  • Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed.

  • All generated code can be viewed together at the step level, with a complete list of executed code.

Explicación

Pregunta 31 de 79

1

Which statement is correct about all expressions in a Mapping? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • It is possible to set the execution location on source, staging area, or target.

  • All transformations are executed on the staging area.

  • Only the source and target servers can be used to execute expressions.

  • All expressions are executed on the source area

Explicación

Pregunta 32 de 79

1

You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B. How must you test this by using ODI Studio running on machine C? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • UseOdiPingAgentin a package to ping AGT agent.

  • In Topology, test the connections to servers A and B by using the AGT agent.

  • In Topology, test the connections to the AGT agent.

  • In Topology, test the connections to servers A and B by using Local (No Agent).

Explicación

Pregunta 33 de 79

1

Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Data transformation must be distributed across several scalable nodes.

  • It is mandatory to have an intermediate server.

  • It is better to load data directly from sources into a data warehouse server.

  • It is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.

Explicación

Pregunta 34 de 79

1

You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI. What must you do to accomplish this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.

  • You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected.

  • You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI.

  • You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers.

Explicación

Pregunta 35 de 79

1

What is the main benefit of using consistent set journalizing compared to simple journalizing? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Consistent set journalizing runs faster than simple journalizing.

  • Consistent set journalizing always uses Oracle GoldenGate.

  • Consistent set journalizing treats each data store individually.

  • Consistent set journalizing provides a guarantee of consistency of the captured changes.

Explicación

Pregunta 36 de 79

1

Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • The intermediate integration table prefixed with I$is required to determine which records must be inserted.

  • If Flow Control is not necessary, an I$ table is not created.

  • The intermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.

  • Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.

Explicación

Pregunta 37 de 79

1

You must split a model with many database tables into multiple sub-models based on their
names. How must you proceed? (Choose the best answer)

Selecciona una o más de las siguientes respuestas posibles:

  • Create new submodels and drag data stores individually to each submodel.

  • Use automatic distribution feature at the models level to automatically create the submodels and move the data stores based on their names.

  • Create new submodels and leverage the automatic distribution feature at the submodels level to
    automatically move the data stores based on their names.

  • Create new models, drag the data stores individually to each model and then drag the models to
    the parent model to create submodels.

Explicación

Pregunta 38 de 79

1

You have to loop through a Mapping step three times in a package by using variables. Identify
the correct variable data type to create the loop. (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • numeric

  • alphanumeric

  • date

  • text

Explicación

Pregunta 39 de 79

1

Your package logic requires you to retrieve the status of the previous package step into avariable.
How must you implement this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

  • Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

  • Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

  • Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

Explicación

Pregunta 40 de 79

1

You need to deploy ODI JEE Components on WebLogic Server. Where should you deploythem? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • on the Coherence Server

  • on the Administration Server

  • on the Node Manager

  • on the Managed Server

Explicación

Pregunta 41 de 79

1

How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the bestanswer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the

  • Extend Window and Lock Subscriber check boxes.

  • Add anOdiSendMailstep to a knowledge module.

  • Duplicate theOdiSendMailstepinto multiple packages.

  • Create a procedure with a step that usesOdiSendMailand add this procedure

Explicación

Pregunta 42 de 79

1

You must monitor and manage a co-located stand-alone agent, OracleDIAgent1, by using theODI plug-in for Enterprise Manager Cloud Control. Which is the correct command to start this agenton Linux? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • ./agent.sh -NAME=OracleDIAgent1 -PORT=20910

  • ./agent.sh -NAME=OracleDIAgent1

  • ./startComponent.sh OracleDIAgent1

  • ./startComponent.sh OracleDIAgent1 -PORT=20910

Explicación

Pregunta 43 de 79

1

Which two statements are true about ODI web-based components? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • ODI Console allows administrators to edit users' information.

  • Enterprise Manager Cloud Control provides access to ODI data servers' settings.

  • ODI sessions can be monitored in Enterprise Manager Cloud Control.

  • ODI Console provides access to project and mapping details.

Explicación

Pregunta 44 de 79

1

If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK.
What happens at run time when a Mapping gets executed? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • All distinct entries are processed.

  • Only the latest entry is processed based on theJRN_DATEfield.

  • Only the first entry is processed based on theJRN_DATEfield.

  • A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.

Explicación

Pregunta 45 de 79

1

How are the domains of ODI Agents configured? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • by using Upgrade Assistant

  • by using ODI Studio

  • by using Domain Creation Assistant

  • by using Configuration Wizard

Explicación

Pregunta 46 de 79

1

You create two mappings that both use the same changed data and run at different times.
One runs every 15 minutes and the other runs once every day.
What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.

  • Create a third mapping to copy the changed data to a staging table, which is used as the source ofthe second Mapping

  • Duplicate the source data store for each Mapping.

  • Create two distinct subscribers for each Mapping.

Explicación

Pregunta 47 de 79

1

Identify the name of the default WebLogic data source created for the Master Repository when setting up a JEE domain. (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • odiMasterRepository

  • MasterRepository

  • odimasterrepository

  • ODIMasterRepository

Explicación

Pregunta 48 de 79

1

You are designing a load plan in which you must create multiple branches based on the value of a variable. How do you accomplish this by using Load Plan Editor? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Add a case step and drag the variable into the case step.

  • Create a scenario from the variable and add the scenario to the load plan to create a case step.

  • Add a case step in the load plan and select a variable in the wizard.

  • Drag the variable into the load plan and define a case step.

Explicación

Pregunta 49 de 79

1

Which product is included in ODI web-based components? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Oracle BPEL Process Manager

  • Oracle GoldenGate

  • ODI Console

  • Oracle WebLogic Server

Explicación

Pregunta 50 de 79

1

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • The Knowledge Module must be customized because business rules and the physical
    implementation are strictly interlayed in ODI.

  • The Knowledge Module must be customized only for aggregation functions.

  • The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.

  • The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

Explicación

Pregunta 51 de 79

1

Identify two correct Restart values for parallel steps in load plans. (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • Restart from new session.

  • Restart from failure.

  • Restart from failed children.

  • Restart all children.

Explicación

Pregunta 52 de 79

1

The workflow you are designing requires checking to see whether there are records available in a source table before doing anything. Which ODI tool must you use to implement this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • OdiWaitForData

  • OdiWaitForCDCData

  • OdiWaitForLogData

  • OdiWaitForTable

Explicación

Pregunta 53 de 79

1

Identify three capabilities of load plans. (Choose three.)

Selecciona una o más de las siguientes respuestas posibles:

  • restart from failed tasks

  • exception handling

  • native support for parallelism

  • support for Open Tools

  • restart of an agent

Explicación

Pregunta 54 de 79

1

You are designing a Mapping. How are target and source tables defined? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

  • Their definition is imported with a reverse-engineering process directly from databases and other sources.

  • Forevery load the definition of the tables used, their columns and constraints must be manually built.

  • An external engine must be run to describe what metadata is needed for a Mapping.

Explicación

Pregunta 55 de 79

1

You need to troubleshoot the execution of a Mapping and visualize the data contained in theODI Staging tables while the Mapping is being executed. How must you proceed? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Start a Mapping in Debug mode and use breakpoints and the Get Data feature to query the datacontained in the Staging tables.

  • Modify a Knowledge Module to dump the Staging tables' data into log files for review.

  • Use variables in a Package to query the Staging tables and evaluate the variable values.

  • Reverse engineer the Staging tables in a Model and review the data contained in it.

Explicación

Pregunta 56 de 79

1

What must you set on the Definition tab of a variable to protect the variable value from beingdisplayed in the Operator logs? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Select the Secure Value check box.

  • Select the Hide Value check box.

  • Set the Keep History field to No History.

  • Leave the Default Value field empty.

Explicación

Pregunta 57 de 79

1

Which ODI Agent is deployed in Oracle WebLogic Server? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • ODI Runtime Agent

  • ODI Standalone Agent

  • ODI JEE Agent

  • ODI Colocated Standalone Agent

Explicación

Pregunta 58 de 79

1

Which statement is correct about the tasks that Standalone Agents perform? (Choose the bestanswer.)

Selecciona una o más de las siguientes respuestas posibles:

  • They update or modify code to be executed, check security, select database servers, and updatelog files after execution.

  • They schedule scenarios to be executed, check security, constraints and update log files afterexecution.

  • They retrieve code from the execution repository and request database servers, operatingsystems,or scripting engines for execution.

  • They schedule code from the execution repository and update log files after execution.

Explicación

Pregunta 59 de 79

1

Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required. How do you accomplish this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Link the last step of the package to its first step to create an infinite loop.

  • Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.

  • Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.

  • Drag the package to the last step in the package, run it asynchronously, and then save.

Explicación

Pregunta 60 de 79

1

You are using a customized reverse knowledge module. You want the execution to be performed in only the development data environment. Which statement is true? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • The execution should be done only on the development data environment, as long as the other environment is a mirrored copy.

  • Only the production environment can be used.

  • All environments linked to a logical schema can be used to reverse-engineer table structures.

  • Only a Java engine intermediate environment can be processed.

Explicación

Pregunta 61 de 79

1

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • It enables developers to execute most ODI operations through a Java program.

  • It can be used to embed ODI processes into another product.

  • It is used to load data between Teradata and Oracle.

  • It must be used by ETL developers to develop ODI processes.

Explicación

Pregunta 62 de 79

1

How do you provide a timeout value for an exception step? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • by using a custom Groovy script

  • by using a variable

  • by using the Timeout field

  • by using a Timeout knowledge module

Explicación

Pregunta 63 de 79

1

When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • transform only

  • load and transform

  • extract and load

  • extract and transform

Explicación

Pregunta 64 de 79

1

(Choose one.)

Selecciona una o más de las siguientes respuestas posibles:

  • Add a new subscriber and edit the default Journalizing filter in your Mappings.

  • Drop the journal, add a new subscriber, start the journal, and edit the defaultJournalizing filter in your Mappings.

  • Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings.

  • Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings.

Explicación

Pregunta 65 de 79

1

Which two statements are true about using ODI and Oracle GoldenGate together? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • Oracle GoldenGate primarily performs aggregations for ODI.

  • GoldenGate and ODI are used together primarily for running weekly batch jobs.

  • Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.

  • ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.

  • ODI and Oracle GoldenGate enable real-time business intelligence.

Explicación

Pregunta 66 de 79

1

You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • Right-click the step in Package Editor and select the No Logging menu item.

  • Modify Operator Navigator settings to disable that step from being displayed.

  • In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.

  • Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs.

Explicación

Pregunta 67 de 79

1

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog. How can you accomplish this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store.

  • You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.

  • You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.

  • You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints.

Explicación

Pregunta 68 de 79

1

Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • OdiOutFile

  • OdiFileCopy

  • OdiFileMove

  • OdiInFile

Explicación

Pregunta 69 de 79

1

You want to deploy the generated code manually in a source or target server, before executing a mapping in ODI. How can you accomplish this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • You need not deploy the generated code manually in a source or target server. ODI Agent coordinates the execution of commands prepared for the job, and executes them on the correct server.

  • You must deploy the generated code manually in a source or target server. You must then compile the generated code and then double-check if the code prepared for the development server is the same as the code for the production server.

  • You need not deploy the generated code manually in a source or target server. ODI prepares a package for the development environment.

  • You must deploy the generated code manually in a source or target server. You must copy all procedures generated into the development, test, and production servers.

Explicación

Pregunta 70 de 79

1

You need to create a Model that works with multiple underlying technologies. How must you proceed? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • This works only for Oracle and Informix.

  • This works only for Oracle and MySQL.

  • Create a new generic technology to support it.

  • Use the out-ofthe box Generic SQL technology.

Explicación

Pregunta 71 de 79

1

Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality. How can you achieve this? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • The project must be explicitly mapped within an ODI mapping.

  • A customize knowledge module is needed.

  • An ODI procedure must be associated with it.

  • It can be defined for every technology listed in the topology.

Explicación

Pregunta 72 de 79

1

You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error. Why did this happen? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.

  • It is not possible to enforce constraints on any technology.

  • It is only possible to forward-engineer it to the flat file definition.

  • It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file.

Explicación

Pregunta 73 de 79

1

Which two objects can be dragged to a Mapping? (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • Variables

  • Datastores

  • Knowledge Modules

  • Reusable Mappings

Explicación

Pregunta 74 de 79

1

A Mapping that uses CDC does not load any source data and you want to check the
SNP_CDC_SET table to find out the current window ID. In which database schema must you look to find this table? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • the schema hosting the Work repository

  • the schema hosting theWork schema of the default schema defined for your source data server

  • the schema hosting the Staging Area

  • SYS

Explicación

Pregunta 75 de 79

1

How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • from the source database into flat files that are then loaded into the target database

  • directly from the source database to the target database

  • from the source database onto the server running the Agent and then into the target database

  • from the source database into the machine running ODI Studio and then into the target database

Explicación

Pregunta 76 de 79

1

You are working on notifications in a package and you must send an email containing an error message in case a Package step fails. Which odiRef method do you use to access the error message? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • odiRef.getSession()

  • odiRef.getInfo()

  • odiRef.getPrevStepLog()

  • odiRef.getStep()

Explicación

Pregunta 77 de 79

1

In a Mapping, you want to load the data by using a specific partition that is declared for a Target table. Which statement is correct in this situation? (Choose the best answer)

Selecciona una o más de las siguientes respuestas posibles:

  • It is not possible to use a specific partition.

  • Only ODI variables can be used to filter the target table loading.

  • An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.

  • An option in the Mapping can be used to declare the partition that has to be used for the loading.

Explicación

Pregunta 78 de 79

1

How can you define the order in which target data stores are loaded in a Mapping? (Choose the best answer.)

Selecciona una o más de las siguientes respuestas posibles:

  • ODI automatically computes the load order based on the order on which the data stores were added to the Mapping.

  • You can use the Target Order field.

  • You can use the Target Load Order field.

  • You can use the Load Order field.

Explicación

Pregunta 79 de 79

1

Identify two benefits that are unique to ODI JEE Agents. (Choose two.)

Selecciona una o más de las siguientes respuestas posibles:

  • high availability

  • minimal footprint

  • access to WebLogic connection pools

  • management in Enterprise Manager Cloud Control

Explicación