1Z0-515 | What High value 1Z0-515 practice test Is?
Q21. Knowledge Modules are:
A. Reusable code templates for Oracle Data Integrator
B. Prebuilt applications for Oracle Business Intelligence
C. Options for Oracle Enterprise Manager
D. Algorithms for data mining
Answer: A
Q22. Which Oracle option might be used to encrypt sensitive data in an Oracle data warehouse?
A. Active Data Guard
B. Total Recall
C. Advanced Security Option
D. Virtual Private Database
Answer: C
Q23. Identify the statement about ASM that is NOT true.
A. ASM is easier to manage than file systems.
B. ASM delivers the performance of raw partitions.
C. ASM is an extra cost option for Oracle databases.
D. ASM delivers automatic striping and mirroring.
Answer: B
Q24. Identify the benefit of using bitmap join indexes.
A. Faster query performance for all queries.
B. Reduced space for indexes.
C. Faster query performance for some queries.
D. Lower memory usage.
Answer: B
Q25. How many Exadata Storage Server cells can be used in a grid?
A. 7
B. 14
C. 128
D. No practical limit
Answer: D
Q26. HI want to enable result set caching to quickly see if this feature will help the performance of your application. Which is the quickest way to make this determination?
A. Set RESULT_CACHE_MODE = FORCE in the initialization file.
B. Set RESULT_CACHE = ENABLED in the initialization file.
C. Set RESULT_CACHE_MAX_SIZE = 0.
D. Set RESULT_CACHE = ENABLED in the initialization file and use a RESULT_CACHE hint in queries.
Answer: A
Q27. You can perform what-if analysis of potential changes with Oracle Warehouse Builder.
A. TRUE
B. FALSE
Answer: A
Q28. What are Oracle Data Integrator templates used for?
A. To model SAP applications
B. To define how to transform data
C. As reports to monitor ETL activity
D. None of these
Answer: B
Q29. Your customer wants to determine "market baskets." What do you recommend?
A. Use Oracle OLAP Option.
B. Use Oracle SQL Analytic Functions.
C. Useassociations algorithm in Oracle Data Mining.
D. Use regression analysis in Oracle Data Mining
Answer: C
Q30. Identify the benefit of using interval partitioning.
A. Automatic creation of new partitions based on hash values
B. Automatic creation of new partitions based on the value of data being entered
C. Improved performance compared to range partitions
D. Automatic transfer of older partitions lower cost storage
Answer: B