1Z0-515 - Data Warehousing 11g Essentials

Go back to Oracle

Example Questions

Identify the action that you CANNOT perform using Database Resource Manager. Which two statements are true about the advantages of using a data warehouse? You will be implementing a data warehouse for one of your customers. In your design process, which index type is most likely to be used to improve the performance of some queries where the data is of low cardinality? Which can be used in scenario where there are large data loads °f a "me sensitive nature into a data warehouse? 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 Full Rack Oracle Exadata Database Machine can contain 100 TB of disk space with high performance disks. How much user data should you conservatively estimate this configuration can hold? Which is NOT among Oracle SQL Analytic functions included in Oracle Database 11g? Identify the benefit of using interval partitioning. What are two ways in which query performance can be improved with partitioning? What data can you compress using Advanced Compression in Oracle Database 11g? Identify the type of refresh that is not supported by materialized views Identify the indexing technique you would use to minimize partition maintenance. Identity the true statement about a data warehouse What two types of results can be cached in the Result Set Cache? The Analytic Workspace Manager would be used to generate_______. You want to create an optimally data warehouse configuration for your customer. Which way of creating a hardware configuration will reduce the implementation time the most? How can you implement near real-time data integration with Oracle Data Integrator? Why does partitioning help parallelism with RAC? 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? Which statement is true for you to get the benefits of partitions-wise joins? You want partitions to be automatically created when data that does not fit into current date range loaded. Which type of partitioning would you implement? What are Oracle Data Integrator templates used for? The most performant way to load data from an external table that will also guarantee direct path loading is: Which questions CANNOT be addressed by Oracle Data Mining? Which is NOT an available composite partition in Oracle Database 11g? How many Exadata Storage Server cells are there in a Full Rack Exadata database machine configuration that has 8 Database Server nodes? What is the difference between an ETL (Extraction Transformation Load) approach and an ELT (Extraction Load Transformation) approach to data integration? Data Guard compresses data: How does compression affect resource utilization? You are looking to size a data warehouse configuration. If the I/O throughput for the CPUs is 25 GB/s, the I/O throughput for the HBA is 18 GB/s, and the I/O throughput for the disk subsystem is 6 GB/s, what is the overall throughput of the data warehouse? Identify the statement about ASM that is NOT true. Identify the control structure that would not be defined as part of a data flow with Oracle Data Integrator? How many Exadata Storage Server cells are these in a Full Rack Exadata database machine configuration that has 8 Database Server nodes? Identify the statement about Oracle OLAP that is NOT true. One goal of your information Lifecycle Management strategy using Oracle’s ILM capabilities is to reduce the cost of online storage. Identify two database options that would help in enabling such a strategy. Which feature would enable higher availability during maintenance operations while also improving query response performance? Your customer is looking to implement ad-hoc analysis in a data warehouse. Which approach is least likely to be used assuming that the customer does not want the expense of managing view? What is the difference between an ETL (Extraction Transformation LoaD. approach and an ELT (Extraction Load Transformation) approach to data integration? What would you do to compress data in partitions that are frequently updated in Oracle Database 11g? Which feature of Oracle Warehouse Builder can be used to help ensure data quality? How many Exadata Storage Server cells can be used in a grid? Which unique method of improving performance is NOT used by the Oracle Exadata Database Machine? What are three advantage provided by proper partitioning in a data warehouse? You think that result set caching might provide some benefits for your current data warehouse scenario. you perform some analysis on the composition of the queries used in the scenario. Identify the result of the analysis that would indicate the most potential for improvement with result set caching. The most performance way to load data from an external table that will also guarantee direct path load is: You can use Oracle Data Mining on unstructured data. Identify the control structure that would NOT be defined as part of a data flow with Oracle Data Integrator. Exadata uses smart scans, which are executed in Which is NOT an advantage provided by partitioning? Your customer wants to determine "market baskets." What do you recommend?