C-BODI-20 試験問題を無料オンラインアクセス

You are working in a multi-user central repository based environment. You select "Rename owner" on an object which is not checked out. The object has one or more dependent objects in the local repository. What is the outcome?

• A.Data Integrator renames the individual object owner.
• B.Data Integrator displays the "This object is checked out from central repository "X". Please select Tools Central Repository. to activate that repository before renaming Message.
• C.Data Integrator renames the owner of all 0bjects within the selected data store.
• D.Data integrator displays a second window listing the dependent objects. when you click "continue" the object owner is renamed and all of the dependent objects are modified.

You want to join a "sales", "customer" and "product" table. Each table resides on a different data store and will not pushdown to one SQL command. The "sales" table contains approximately five millions rows. The "customer" table contains approximately five thousand rows. The "product" table contains fifty records.
How would you set the source table options to maximize performance of this operation?

• A.Set the sales table joins rank to 20 and cache to "No". Set the customer table joins rank to 10 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
• B.Set the sales table joins rank to 10 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 30 and cache to "yes".
• C.Set the sales table joins rank to 30 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
• D.Set the sales table joins rank to 20 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".

Which two objects can be used in a Work Flow? (Choose two)

• A.Try/catch
• B.Datastore
• C.Work Flow
• D.Custom Function

Which two data integrator objects/operations support load balancing in a server Group based architecture? (Choose two.)

• A.Job
• B.While loop
• C.Lookup_ext
• D.Script

What are three ways to view the push down SQL generated by a Data Flow? (Choose three)

• A.Right -click on the Data Flow and select "Display Optimized SQL"
• B.Select "Display Optimized SQL" from the Validation menu.
• C.Select "Trace SQL Readers" from the Trace options when executing a Job.
• D.Right -click on the Data Flow and select "Audit I Store push-down SQL".