1Z0-515 Exam Questions

Your customer wants to implement an ILM strategy. The customer must have which option when deploying Oracle's ILM Assistant to implement this strategy?

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 ti...

Which statement is true for you to get the benefits of partition-wise joins?

You can perform what-if analysis of potential changes with Oracle Warehouse Builder.

Indentify the dimension that appears most often in queries in a data warehouse.

Which questions CANNOT be addressed by Oracle Data Mining?

Which is NOT an available composite partition in Oracle Database 11g?

You are looking to create a RAC cluster to deliver high performance for your client's data warehouse. Which statement is true about a configuration with a few large nodes versus a...

You can use Oracle Data Mining unstructured data.

How can you use Oracle Data Mining with Oracle Warehouse builder?

You customer wants to segment their customers1 demographic data into those that use and do not use loyalty card. What would you recommend?

One goal of your Information Lifecycle Management strategy using Oracle's ILM capabilities is to reduce cost or online storage. Identify two database options that would help in ena...

Which can be used in scenario where there are large data loads of a sensitive nature into a data warehouse?

How can you implement near real time data integration with Oracle Data Integrator?

Your customer wants to determine "market baskets." What do you recommend?

Identify the type of refresh that is NOT supported by materialized views.

For which task would you NOT use Oracle Data Mining?

What is the estimated maximum speed of data loads for a Quarter Rack with the Exadata Storage Server?

Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Plus, Business Objects and Cognos) will be used to query an Oracle database that includes the Oracle OLAP...

Data Guard compresses data:

What are Oracle Data Integrator templates used for?

Your BI tool (for example, Oracle Business Intelligence Enterprise Edition Cognos) will be used to query an Oracle database that includes the Oracle BI tool generate in submitting...

How does compression affect resource utilization?

Your customer wants to use Database Resource Manager to help ensure consistent performance based on users and operations. In designing this implementation, which limitation CANNOT...

How many Exadata Storage Server cells are there in a Full Rack Exadata database machine configuration that has 8 Database Server nodes?

Identify the true statement about adaptive parallelism.

Identify the statement about Oracle OLAP that is NOT true.

The Analytic Workspace Manager would be used to generate_______.

Which feature of Oracle Warehouse Builder can be used to help ensure data quality?

Flash in the Oracle Exadata Database Machine is of lower latency (and enables faster access to data) than:

Indentify the true statement about REF partitions.

Identify the control structure that would NOT be defined as part of a data flow with Oracle Data Integrator.

For which type of query is the SQL result cache automatically disabled?

Which is NOT among Oracle SQL Analytic functions included in Oracle Database 11g?

How many Exadata Storage Server cells can be used in a grid?

Identify the action that you CANNOT perform using Database Resource Manager.

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 w...

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 scen...

For data warehousing, identify the benefits that would NOT be provided by the use of RAC.

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?

Identify the benefit of using interval partitioning.

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 dis...

What are three advantages provided by proper partitioning in a data warehouse?

Exadata uses smart scans, which are executed in________.

Identify the indexing technique you would use to minimize partition maintenance.

Which feature would enable higher availability during maintenance operations while also improving query response performance?

What two types of results can be cached in the Result Set Cache?

Knowledge Modules are:

Which Oracle option might be used to encrypt sensitive data in an Oracle data warehouse?

Which unique method of improving performance is NOT used by the Oracle Exadata Database Machine?