1z0-640 Exam

- Covers the entire recommended syllabus
- Comprehensive questions and answers about 1z0-640 exam
- Verified Answers Researched by Industry Experts and almost 100% correct
- 1z0-640 exam questions updated on regular basis
- Same type as the certification exams, 1z0-640 exam preparation is in multiple-choice questions (MCQs)
- Tested by multiple times before publishing
- Try free 1z0-640 exam demo before you decide to buy it in Hiexam
- Technical support through Live Chat or Email

　
　
Exam : Oracle 1Z0-640
Title : Siebel7.7 Analytics DataWarehouse Dev.Prof.Core Exam


1. Which of the following Informatica Designer tools would you use to import, create, and maintain target definitions?
A.Warehouse Designer
B.Mapping Designer
C.Source Analyzer
D.Transformation Developer
E.Mapplet Designer
Answer: A

2. 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

3. Which of the following could be used to optimize ETL session performance? Choose two.
A.Drop indexes prior to loading, and then recreate indexes afterwards
B.Partition large fact tables
C.Build mappings to maximize connection time to the OLTP
D.Use constraint-based loading whenever possible
Answer: AB

4. What are some of the data-related challenges that create difficulties in making business decisions? Choose three.
A.Too much irrelevant data for the job role
B.A static reporting tool
C.A business analytics tool that is too easy to master
D.A reporting tool that allows the users to initiate their own query
E.Ever increasing data volume
Answer: ABE

5. Which is NOT true of Workflow session log files?
A.Generated for each session
B.Saved in the Informatica Client directory
C.Include allocation of system-shared memory
D.Default name is session_name.log
Answer: B

http://www.Hiexam.com The safer.easier way to get Other Oracle Certification Certification.