1Z0-515 - Data Warehousing 11g Essentials
Go back to
Identify the action that you CANNOT perform using Database Resource Manager.
Allocate individual CPUs to Consumer Groups.
Which two statements are true about the advantages of using a data warehouse?
A data warehouse uses fewer database structures, so access to answers is faster and easier
A data warehouse uses specialized features of the Oracle database, like materialized views and star transformations, making response faster.
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?
Direct path loading
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.
Partition your tables appropriately to produce partition-wise joins
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?
All of the above
Identify the benefit of using interval partitioning.
Automatic creation of new partitions based on the value of data being entered
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?
Data that can be updated, inserted and/or deleted (DML)
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
A data warehouse typically contains historical data.
What two types of results can be cached in the Result Set Cache?
Results of an SQL query
Results from a PL/SQL function
The Analytic Workspace Manager would be used to generate_______.
Oracle OLAP Option cubes
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?
Use reference configurations or an appliance-like configuration
How can you implement near real-time data integration with Oracle Data Integrator?
By accessing Change Data Capture records from logs
Why does partitioning help parallelism with RAC?
The ability to do partition-wise joins reduces interconnect traffic
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?
Set RESULT_CACHE_MODE = FORCE in the initialization file.
Which statement is true for you to get the benefits of partitions-wise joins?
The parent table must be partitioned on the primary key and the child table must use a reference partition
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?
To define how to transform data
The most performant way to load data from an external table that will also guarantee direct path loading is:
Using Create Table as Select (CTAS)
Which questions CANNOT be addressed by Oracle Data Mining?
Root cause de
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?
ELT transformation data on the target server
Data Guard compresses data:
When using physical standby
How does compression affect resource utilization?
Reduces the amount of disk but increases CPU utilization for loading
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?
It depends on how many processors are in the servers.
Identify the statement about ASM that is NOT true.
ASM delivers the performance of raw partitions.
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.
Oracle OLAP cubes are stored in the Oracle relational database
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.
Partitioning and Advanced Compression
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?
ETL can operate between heterogeneous data sources.
ELT transforms data on the target server.
What would you do to compress data in partitions that are frequently updated in Oracle Database 11g?
Use Hybrid Columnar Compression.
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?
No practical limit
Which unique method of improving performance is NOT used by the Oracle Exadata Database Machine?
Performs analysis in a special in-memory database
What are three advantage provided by proper partitioning in a data warehouse?
Partition pruning will occur
Efficient parallel joins
Efficient data loading
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 scenario consists mainly of queries with long run times and small result sets
The most performance way to load data from an external table that will also guarantee direct path load is:
Using Insert as Select(IAS)
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
Exadata Storage Server cells
Which is NOT an advantage provided by partitioning?
Can improve performance by reducing I/O
Your customer wants to determine "market baskets." What do you recommend?
Use regression analysis in Oracle Data Mining