Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Oracle 1Z0-640
Title
: Siebel7.7 Analytics
DataWarehouse
Dev.Prof.Core Exam
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. 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
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. 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
4. 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
5. 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
6. Which of the following is true of the ETL process?
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
A.SDE routines are used to extract data from the SRMW tables
B.SDE routines are only for full extraction
C.Staging tables have to be persistent until the next ETL processes
D.SIL processes load data from the staging tab