1Z0-515 | Up to the minute 1Z0-515 Exam Study Guides With New Update Exam Questions
Q11. Which statement is true for you to get the benefits of partition-wise joins?
A. The parent table must be partitioned on the join Key and the child table must be partitioned on the join key.
B. The parent table must be partitioned on the primary key and the child table must be partition the join key.
C. The child table must use a reference partition.
D. The parent table must be partitioned on the primary key and the child table must use a ref partition.
Answer: A
Q12. How can you use Oracle Data Mining with Oracle Warehouse builder?
A. To identify records to extract
B. As a standard transform operation
C. To increase write performance
D. To eliminate ETL logging
Answer: A
Q13. Which feature would enable higher availability during maintenance operations while also improving query response performance?
A. Partitioning
B. Materialized views
C. Bitmap Indexing
D. OLAP
Answer: A
Q14. What is the difference between an ETL (Extraction Transformation LoaD. approach and an ELT (Extraction Load Transformation) approach to data integration?
A. ETL can operate between heterogeneous data sources.
B. ELT requires a separate transformation server.
C. ELT transforms data on the target server.
D. ELT cannot be used for incremental data loading.
Answer: C
Q15. You have analyzed your client's workload and the Materialized Views Advisor in Enterprise Manager recommends that you create some materialized views to improve performance. What should you do in order to most simply implement this change?
A. Rewrite all the queries in the application to identify materialized view
B. Rewrite existing queries. New queries will automatically use the views.
C. Respond positively to the Advisor to create the materialized views.
D. Build virtual views on a third normal form schema.
Answer: C
Q16. You are looking for some general design principles that could be used in designing every large scale data warehouse you create. Identify the principle that would have the widest applicability.
A. Partition your tables appropriately to produce partition-wise joins.
B. Always use a star schema or snowflake schema design.
C. Do as much analytics as possible in your BI tools.
D. Always use Oracle OLAP.
Answer: A
Q17. For data warehousing, identify the benefits that would NOT be provided by the use of RAC.
A. Distribute workload across all the nodes.
B. Distribute workload to some of the nodes.
C. Provide parallel query servers.
D. Provide high availability for all the operations.
Answer: B
Q18. Identify the statement about Oracle OLAP that is NOT true.
A. Oracle OLAP cubes are stored in the Oracle relational database
B. Oracle OLAP uses standard Oracle database security.
C. Meta data for Oracle OLAP is accessible in an external data dictionary
D. Oracle OUP can be deployed using RAC.
Answer: C
Q19. You want to create an optimally performing data warehouse hardware configuration for your customer. Which way of creating a hardware configuration will reduce the implementation time the most?
A. Use reference configurations or an appliance-like configuration.
B. Use the existing system and add on relevant components.
C. Customize a configuration from a vendor.
D. Build the system from scratch.
Answer: A
Q20. What areas can SQL Access Advisor give advice on?
A. Partitioning advice, index advice, and materialized views advice
B. Index advice and compression advice
C. Index advice and data masking advice
D. Partitioning advice and compression advice
Answer: A