Data Warehousing 11g Essentials: 1Z0-515

Correct Answer: A

Explanation: Oracle Optimized Warehouse Reference Configurations are best practice guides to choosing the right server, storage and networking components to build an Oracle data warehouse. These best practice guides encapsulate years of configuration expertise from Oracle and its partners, helping customers take the risk out of implementing a data warehouse.

References:

Correct Answer: ACD

Explanation:

There are three major advantages of partitioning.

*

Partition Pruning - Oracle only accesses a limited set of table partitions if the FROM and WHERE clause

permit it to.

*

Partition-wise Joins - Where two tables that have compatible partitioning schemes are joined , Oracle

improves the efficiency of parallel operations by performing the join between individual partitions of the

tables.

*

Manageability - Partitioning allows DDL operations on a large subset of table rows with some element of

commonality defined through the partitioning type.

References:

Correct Answer: C

Explanation:

Association is a data mining function that discovers the probability of the co-occurrence of items in a

collection. The relationships between co-occurring items are expressed as association rules.

Market-Basket Analysis

Association rules are often used to analyze sales transactions. For example, it might be noted that

customers who buy cereal at the grocery store often buy milk at the same time. In fact, association

analysis might find that 85% of the checkout sessions that include cereal also include milk. This

relationship could be formulated as the following rule.

Cereal implies milk with 85% confidence

This application of association modeling is called market-basket analysis. It is valuable for direct

marketing, sales promotions, and for discovering business trends. Market-basket analysis can also be

used effectively for store layout, catalog design, and cross-sell.

Association Algorithm

Oracle Data Mining uses the Apriori algorithm to calculate association rules for items in frequent itemsets.

References: