1z0-640 Other Oracle Certification Braindump
ExamSoon 1z0-640 Exams
Oracle Siebel7.7 Analytics DataWarehouse Dev.Prof.Core Exam
O rder : 1z0-640 Exam
Practice Exam: 1z0-640
Exam Number/Code: 1z0-640
Exam Name: Siebel7.7 Analytics DataWarehouse Dev.Prof.Core Exam
Questions and Answers: 100 Q&As
Free 1z0-640 Braindumps
Exam : Oracle 1Z0-640
Title : Siebel7.7 Analytics DataWarehouse Dev.Prof.Core Exam
1. Which of the following DAC tasks can be used to populate the W_PARTY_LOGIN table?
A.Aggregate
B.Hierarchy
C.Visibility
D.Security
Answer: C
2. Which of the following port types is used in Source objects in a mapping?
A.Input
B.Output
C.Input/Output
D.Variable
Answer: B
3. In which of the following applications do you run Exception Reports?
A.Informatica Monitor
B.DAC client
C.DAC server
D.Siebel Tools
E.Analytics Administration Tool
Answer: B
4. Which of the following transformation types is used to perform simple calculations on a row-by-row basis?
A.Aggregator transformation
B.Filter transformation
C.Normalizer transformation
D.Expression transformation
Answer: D
5. Which of the following are recommended ETL configuration practices? Choose three.
A.Always run complete ETL process
B.Test the modified ETL by running an execution plan
C.Create a backup of the DAC repository
D.Document all changes made to the repository
Answer: BCD
6. Click the Exhibit button. Which table's properties are depicted here?
A.Type R Change Capture table
B.Type I Change Capture table
C.Internal table
D.Hierarchy table
Answer: A
7. Which of the following are the most important reasons why you would run Exception Reports? Choose two.
A.To increase ETL performance
B.To improve ETL mapping accuracy
C.To avoid running too many incremental ETL runs
D.To check the data integrity of the Siebel transactional database
E.To skip unnecessary DAC task phases
Answer: AD
8. Which of the following tables contains ROW_IDs of the records that have been identified as new or modified?
A.S_ETL_I_IMG_45
B.S_ETL_LOV
C.S_ETL_PARAM
D.S_ETL_RUN
E