26 errors in answers 1Z0-515-Q&A-Troytec (Источник ответов: http://wenku.baidu.com/view/179108d080eb6294dd886c83.html?from=related)

QUESTION Correct answer
4 B.Substring functions Wrong E.
9 D.Provide high availability for all the operations
16 B.Reduced space for indexes.
18 C.Physically stores MOLAP cubes as objects within the relational database/
19 C.Using Insert as Select(IAS)
24 A.Reduces storage requirements for tables.
25 B.SQL result sets are invalidated in the Result Set Cache after DML is performed against any of tables in the SQL query.
27 C.6 GB/s
36 B.False
37 B.Time dimension
40 C.It depends on the workload specifics and the effect of a node failure.
44 C.Partitioning and Advanced Compression
45 B.External tables for loading flat files
47 C.Use association algorithm in Oracle Data Mining
49 D.Reducing the amount of data used in a data warehouse
51 A.SQL
52 D.When catching up after a network failure
53 A.To model SAP applications
56 D.Limiting access to particular data for a resource group
58 A.It is turned on by default.
59 C.Meta data for Oracle OLAP is accessible in an external data dictionary
61 C.ASM is an extra cost option for Oracle databases
66 D.28 TB
67 D.Avoid compressing any data.
69 B.Data profiling
70 D.Locally attached and network-attached disk




Add QUESTION:
1. Your customer wants to reduce backup volumes by not backing up older data on an ongoing basis/
Which type of partitioning would you recommend for addressing this scenario?
A.Range Partitioning
B.Hash partitioning
c. List Partitioning
D. RAC

Answer: A

2.Your customer wants you to design their data warehouse, and a highly available solution is their
top priority. Giving emphasis to this, which feature would you omit for your design?
A. Active Data Guard
B. RAC
C. Global nonpartitioned indexes
D. Partitioning

Answer: C

3.Which is the most important Oracle database feature in enabling near real-time Oracle-based data werehouses&
A. Oracle Bit-mapped indexes
B. Oracle's multi-version read consistency during data loading
C. Oracle's Hybrid Columnar Compression
D. Oracle's Global indexing

Answer: B

4. What is Oracle's market share in the data warehousing market?
A. Less than 10%
B. 10% to 20%
C. 20% to 30%
D. Aproximately 40%

Answer: D

5. Can database resource manager define the degree of parallelism for a custom group?
A. NO
B. Yes, since Oracle database 9i
C. Yes, since Oracle database 10g
D. Yes, since Oracle database 11g

Answer:


6. You are creating a configuration for a data warehouse, and your server has 4 CPUs, each of wich
can support a sustained rate of throughput of 350 MB/s. You are going to use 1/2 Gbit HBAs
which can support a sustained throughput of 200 Mb/s. How many HBAs should you use in the configuration &
A. 2
B. 4
C. 6
D. 7

Answer: 7

----- оригинал 1Z0-515-Q&A-Troytec.pdf (26 ошибок не исправлено)
Edition: 2.0
Data Warehousing 11g Essentials
Exam: 1Z0-515
1Z0-515
1
QUESTION: 1
Indentify the true statement about REF partitions.
A. REF partitions have no impact on partition-wise joins.
B. Changes to partitioning in the parent table are automatically reflected in the child table.
C. Changes in the data in a parent table are reflected in a child table.
D. REF partitions can save storage space in the parent table.
Answer: B
Explanation:
http://rajeshwaranbtech.blogspot.com/2010/06/ora-14652-in-reference-partitioning- in.html
QUESTION: 2
Identify the control structure that would NOT be defined as part of a data flow with Oracle
Data Integrator.
A. Loops
B. Conditions
C. Error handling
D. GOTOs
Answer: D
Explanation:
http://www.oracle.com/global/hu/events/20080917/1_odi_odd_%20introduction_and_architect
ure. pdf
QUESTION: 3
For which type of query is the SQL result cache automatically disabled?
A. Queries that access data which changes frequently
B. Queries that return large amounts of data
C. Queries that use SQL functions such as SYSDATE
D. Queries that are used infrequently
1Z0-515
2
Answer: C
Explanation:
http://books.google.com/books?id=-4S6xQurmYC&
pg=PA821&lpg=PA821&dq=SQL+result+cache+automatically+disabled&source=bl
&ots=cmCLbFNfO-&sig=0EPaIT1ws3PkpqVhs-DSfalAnrQ&hl=en&ei=o8YTZtD0_
fiBs6GzKUK&sa=X&oi=book_result&ct=result&resnum=1&ved=0CBUQ6AEwAA#
v=onepa ge&q=SQL%20result%20cache%20automatically%20disabled&f=false
QUESTION: 4
Which is NOT among Oracle SQL Analytic functions included in Oracle Database 11g?
A. Ranking functions
B. Substring functions
C. Window aggregate functions
D. LAG/LEAD functions
E. All of the above
Answer: E
Explanation:
All Functions are there in 11G http://education.oracle.com/pls/web_prod-plqdad/
db_pages.getCourseDesc?dc=D52496GC10&p_org_id=68&lang=US
QUESTION: 5
How many Exadata Storage Server cells can be used in a grid?
A. 7
B. 14
C. 128
D. No practical limit
Answer: D
Explanation:
http://www.pythian.com/news/1267/interview-kevin-closson-on-the-oracle-exadata- storageserver/
1Z0-515
3
QUESTION: 6
Identify the action that you CANNOT perform using Database Resource Manager.
A. Define Consumer Groups.
B. Create rules to map sessions to Consumer Groups.
C. Define a Resource Plan.
D. Allocate individual CPUs to Consumer Groups.
Answer: D
Explanation:
http://www.oracle.com/technetwork/database/features/performance/resource- manager-twp-
133705.pdf
QUESTION: 7
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?
A. Bitmap indexes
B. B*-tree indexes
C. Reverse indexes
D. Invisible indexes
Answer: A
Explanation:
http://www.toadworld.com/Newsletter/TWPIPELINEJanFeb2010/PIPEJanFeb10Oracle/tabid/
672/ Default.aspx
QUESTION: 8
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.
A. The scenario consists mainly of queries that are used infrequently.
B. The scenario consists mainly of queries that work on data which changes frequently.
1Z0-515
4
C. The scenario consists mainly of queries with long run times and small result sets.
D. All data warehouse scenarios will benefit from result set caching.
Answer: C
QUESTION: 9
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
QUESTION: 10
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?
A. Hash
B. List
C. Invisible
D. Interval
Answer: D
Explanation:
http://books.google.com/books?id=tdRes4IdLiIC&pg=PA303&lpg=PA303&dq=invisible+part
itionin g+in+oracle&source=bl&ots=7QCZ1beter&sig=FXoQ-4FtF3cB6HgYG8q3TWHrqc&
hl=en&ei=I90-
TcinE4aL4AaH1OWkCg&sa=X&oi=book_result&ct=result&resnum=5&ved=0CDQQ6AEw
BA#v=o nepage&q=invisible%20partitioning%20in%20oracle&f=false
QUESTION: 11
Identify the benefit of using interval partitioning.
1Z0-515
5
A. Automatic creation of new partitions based on hash values
B. Automatic creation of new partitions based on the value of data being entered
C. Improved performance compared to range partitions
D. Automatic transfer of older partitions lower cost storage
Answer: B
Explanation:
http://prutser.wordpress.com/2010/01/11/dropping-interval-partitions/
QUESTION: 12
Your customer wants to implement an ILM strategy. The customer must have which option
when deploying Oracle's ILM Assistant to implement this strategy?
A. RAC
B. Partitioning
C. OLAP
D. Oracle Clusterware
Answer: B
Explanation:
http://www.oracle.com/technology/deploy/ilm/index.html
QUESTION: 13
Why does partitioning help parallelism with RAC?
A. The ability to do partition-wise joins reduces interconnect traffic.
B. Partitioning allows you to split data storage across nodes.
C. Partitioning reduces storage requirements.
D. RAC will spawn additional parallel servers to meet the needs of requesting applications.
Answer: A
Explanation:
http://download.oracle.com/docs/cd/A87860_01/doc/server.817/a76994/parpart.htm
1Z0-515
6
QUESTION: 14
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
Explanation:
http://www.oracleracsig.org/pls/apex/RAC_SIG.download_my_file?p_file=1002364
QUESTION: 15
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: A, C
QUESTION: 16
Identify the benefit of using bitmap join indexes.
A. Faster query performance for all queries.
B. Reduced space for indexes.
C. Faster query performance for some queries.
D. Lower memory usage.
Answer: C, D
Explanation:
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10736/indexes.htm#CIHGAFFF
1Z0-515
7
QUESTION: 17
What data can you compress using Advanced Compression in Oracle Database 11g?
A. Read only data
B. Data that can be updated, inserted and/or deleted (DML)
C. Only data being archived
D. Data warehousing data
Answer: B
Explanation:
https://ophelia.cs.put.poznan.pl/webdav/dbdw/students/dbdw- summer_2009/lectures/etl.pdf
QUESTION: 18
Which best describes Oracle's OLAP Option for Oracle Database 11g Release 2?
A. Is stored as relational tables and is considered a ROLAP solution
B. Uses bitmap indexes
C. Physically stores MOU\P cubes as objects within the relational database
D. Is available both within the Oracle Database and as a stand-alone solution
Answer: A, B
QUESTION: 19
The most performant way to load data from an external table that will also guarantee direct
path loading is:
A. Using Create Table as Select (CTAS)
B. Using Data Pump
C. Using Insert as Select (IAS)
D. Using transparent gateways
Answer: A
Explanation:
1Z0-515
8
http://www.filibeto.org/sun/lib/nonsun/oracle/11.1.0.6.0/B28359_01/server.111/b28310/tables0
04.h tm
QUESTION: 20
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
QUESTION: 21
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: D
Explanation:
http://oracle.su/docs/11g/server.112/e10837/partition.htm
QUESTION: 22
What would you use to evenly distribute data across the disk in your Oracle data warehouse?
A. Range Partitioning
B. Automatic Storage Management (ASM)
C. List Partitioning
1Z0-515
9
D. RAC
Answer: B
Explanation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28314/tdpdw_system.htm
QUESTION: 23
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?
A. Set RESULT_CACHE_MODE = FORCE in the initialization file.
B. Set RESULT_CACHE = ENABLED in the initialization file.
C. Set RESULT_CACHE_MAX_SIZE = 0.
D. Set RESULT_CACHE = ENABLED in the initialization file and use a RESULT_CACHE
hint in queries.
Answer: A
Explanation:
http://www.globusz.com/ebooks/Oracle11g/00000014.htm
QUESTION: 24
Which is NOT an advantage provided by partitioning?
A. Reduces storage requirements for tables
B. Can add to the benefits of parallelism through parallel partition-wise joins
C. Can improve performance by reducing I/O
D. Provides added flexibility for maintenance operations
Answer: C
QUESTION: 25
Which condition can cause a change in the contents of the SQL Result Set Cache?
A. SQL result sets age out of the Result Set Cache based on the KEEP parameter.
1Z0-515
10
B. SQL result sets are invalidated in the Result Set Cache after DML is performed against any
of tables in the SQL query.
C. SQL result sets are pinned in the Result Set Cache with the KEEP parameter.
D. None of these would cause a change.
Answer: A
Explanation:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/memory.htm
QUESTION: 26
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
Explanation:
http://www.oracle-base.com/articles/11g/SQLAccessAdvisor_11gR1.php
QUESTION: 27
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?
A. 25 GB/s
B. 18 GB/s
C. 6 GB/s
D. It depends on how many processors are in the servers.
Answer: D
Explanation:
http://download.oracle.com/docs/cd/E11882_01/server.112/e10578/tdpdw_system.htm
1Z0-515
11
QUESTION: 28
What are three advantages provided by proper partitioning in a data warehouse?
A. Partition pruning will occur
B. Faster sorting
C. Efficient parallel joins
D. Efficient data loading
E. Reduced disk usage
Answer: A, C, D
Explanation:
http://www.databasejournal.com/features/oracle/article.php/3317621/A-Practical- Guide-to-
Data-Warehousing-in-Oracle---Part-3.htm
QUESTION: 29
Exadata uses smart scans, which are executed in________.
A. Exadata Storage Server cells
B. Database Server node memory
C. Database Server node CPUs
D. Exadata does not use smart scans.
Answer: A
Explanation:
http://www.oracle.com/technetwork/database/exadata/index.html
QUESTION: 30
Identify the indexing technique you would use to minimize partition maintenance.
A. Local indexes
B. Global partitioned indexes
C. Global nonpartitioned indexes
D. Both global partitioned and global nonpartitioned indexes
1Z0-515
12
Answer: A
Explanation:
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/partconc.htm
QUESTION: 31
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
Explanation:
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/partconc.htm
QUESTION: 32
What two types of results can be cached in the Result Set Cache?
A. Results of an SQL query
B. Results from a PL/SQL function
C. Sequence object results
D. Result sets derived from data dictionary tables
Answer: A, B
Explanation:
http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/stmtcach.htm
QUESTION: 33
Knowledge Modules are:
1Z0-515
13
A. Reusable code templates for Oracle Data Integrator
B. Prebuilt applications for Oracle Business Intelligence
C. Options for Oracle Enterprise Manager
D. Algorithms for data mining
Answer: A
Explanation:
http://www.oracle.com/technetwork/articles/bethke-odi-090881.html
QUESTION: 34
Which Oracle option might be used to encrypt sensitive data in an Oracle data warehouse?
A. Active Data Guard
B. Total Recall
C. Advanced Security Option
D. Virtual Private Database
Answer: C
Explanation:
http://www.oracle.com/technetwork/database/options/advanced-security/ds-securityadvanced-
security-11gr2-1-129479.pdf
QUESTION: 35
Which unique method of improving performance is NOT used by the Oracle Exadata Database
Machine?
A. Flash to improve query performance
B. Reduces the amount of data required to flow through I/O
C. Increases the I/O using InfiniBand
D. Performs analysis in a special in-memory database
Answer: D
Explanation:
http://techsatwork.com/blog/?p=743
1Z0-515
14
QUESTION: 36
You can perform what-if analysis of potential changes with Oracle Warehouse Builder.
A. TRUE
B. FALSE
Answer: A
QUESTION: 37
Indentify the dimension that appears most often in queries in a data warehouse.
A. Product dimension
B. Time dimension
C. Cost dimension
D. Location dimension
Answer: A
Explanation:
http://philip.greenspun.com/sql/data-warehousing.html
QUESTION: 38
Which questions CANNOT be addressed by Oracle Data Mining?
A. Fraud detection
B. Prediction of customer behavior
C. Root cause de
D. Identify factors associated with a business problem
Answer: C
QUESTION: 39
Which is NOT an available composite partition in Oracle Database 11g?
1Z0-515
15
A. range-list
B. list-list
C. list-range
D. interval-hash
Answer: D
Explanation:
http://www.oracle-base.com/articles/11g/PartitioningEnhancements_11gR1.php
QUESTION: 40
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
configuration with n smaller nodes?
A. A few large nodes always perform better than many small nodes.
B. A few large nodes always perform worse than many small nodes.
C. It depends on the workload specifics and the effect of a node failure.
D. Performance should be the same with either option.
Answer: A
Explanation:
http://www.oracle.com/us/solutions/datawarehousing/039574.pdf
QUESTION: 41
You can use Oracle Data Mining unstructured data.
A. TRUE
B. FALSE
Answer: A
Explanation:
http://download.oracle.com/docs/cd/B28359_01/datamine.111/b28129.pdf
QUESTION: 42
1Z0-515
16
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: B
Explanation:
http://blogs.oracle.com/datamining/
QUESTION: 43
You customer wants to segment their customers1 demographic data into those that use and do
not use loyalty card. What would you recommend?
A. Use Oracle OLAP Option.
B. Use Oracle SQL Analytic Functions.
C. Use classification algorithm in Oracle Data Mining.
D. Use non-negative matrix factorization in Oracle Data Mining.
Answer: C
Explanation:
http://download.oracle.com/docs/cd/B28359_01/datamine.111/b28129/intro_concepts.htm
QUESTION: 44
One goal of your Information Lifecycle Management strategy using Oracle's ILM capabilities
is to reduce e cost or online storage. Identify two database options that would help in enabling
such a strategy.
A. RAC and Advanced Compression
B. RAC and Partitioning
C. Partitioning and Advanced Compression
D. RAC One and Advanced Compression
1Z0-515
17
Answer: B, D
QUESTION: 45
Which can be used in scenario where there are large data loads °f a "me sensitive nature into a
data warehouse?
A. Direct path loading
B. External tables for loading flat files
C. Partition exchange loading
D. Any of these are valid for certain situations.
Answer: A
Explanation:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1008815
QUESTION: 46
How can you implement near real time data integration with Oracle Data Integrator?
A. By accessing Change Data Capture records from logs
B. By using Exchange Partition
C. By mining Oracle UNDO segments
D. By reading operating system logs
Answer: B
QUESTION: 47
Your customer wants to determine "market baskets." What do you recommend?
A. Use Oracle OLAP Option.
B. Use Oracle SQL Analytic Functions.
C. Use associations algorithm in Oracle Data Mining.
D. Use regression analysis in Oracle Data Mining
Answer: D
1Z0-515
18
Explanation:
http://download.oracle.com/docs/cd/B28359_01/datamine.111/b28129/regress.htm
QUESTION: 48
Identify the type of refresh that is NOT supported by materialized views.
A. Deferred
B. Incremental
C. Full
D. Heuristic
Answer: D
Explanation:
http://download.oracle.com/docs/cd/B10500_01/server.920/a96520/mv.htm#42135
QUESTION: 49
For which task would you NOT use Oracle Data Mining?
A. Predicting customer behavior
B. Associating factors with a business issue
C. Determining associations within a population
D. Reducing the amount of data used in a data warehouse
E. All of the above
Answer: E
Explanation:
For All above we can use Oracle Data Mining http://portal.acm.org/citation.cfm?id=1157021
QUESTION: 50
What is the estimated maximum speed of data loads for a Quarter Rack with the Exadata
Storage Server?
A. 1 TB/hr
B. 2 TB/hr
C. 4 TB/hr
1Z0-515
19
D. 5 TB/hr
E. It depends on the number of CPUs in the server.
Answer: A
Explanation:
http://techsatwork.com/blog/?p=743
QUESTION: 51
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
Option What does tool generate in submitting queries that might include data stored in
relational tables and OLAP cubes?
A. SQL
B. PL/SQL
C. Proprietary API code
D. SQL for relational and proprietary API code for OLAP
Answer: B
QUESTION: 52
Data Guard compresses data:
A. Always
B. When using logical standby
C. When using physical standby
D. When catching up after a network failure
Answer: C
Explanation:
http://forums.oracle.com/forums/thread.jspa?threadID=886988
QUESTION: 53
What are Oracle Data Integrator templates used for?
1Z0-515
20
A. To model SAP applications
B. To define how to transform data
C. As reports to monitor ETL activity
D. None of these
Answer: B
Explanation:
http://www.docstoc.com/docs/24079944/Oracle-Data-Integrator-Architecture
QUESTION: 54
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
queries that might include data stored in cubes?
A. SQL
B. PIVSQL
C. Proprietary API code
D. SQL for relational and proprietary API code for OLAP
Answer: C
QUESTION: 55
How does compression affect resource utilization?
A. Reduces the amount of CPU and disk utilization
B. Increases the amount of CPU and disk utilization
C. Reduces the amount of disk but increases CPU utilization for loading
D. Increases the amount of disk but reduces CPU utilization for loading!
Answer: C
Explanation:
http://publib.boulder.ibm.com/tividd/td/ITSMFD/SC32-9065-
00/en_US/HTML/ab5w0007.htm
1Z0-515
21
QUESTION: 56
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 be imposed through Database Resource Manager?
A. Specifying the maximum number of concurrent operations for a resource group
B. Limiting resource consumption for a resource group
C. Specifying the amount of parallelism for a resource group
D. Limiting access to particular data for a resource group
Answer: A
QUESTION: 57
How many Exadata Storage Server cells are there in a Full Rack Exadata database machine
configuration that has 8 Database Server nodes?
A. 2
B. 14
C. 16
D. 24
Answer: B
QUESTION: 58
Identify the true statement about adaptive parallelism.
A. It Is turned on by default.
B. It is turned off by default.
C. You should always leave the default setting
D. There is no such thing.
Answer: B
Explanation:
http://kerryosborne.oracle-guy.com/category/oracle/exadata/page/3/
1Z0-515
22
QUESTION: 59
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 OU\P can be deployed using RAC.
Answer: A
Explanation:
http://download.oracle.com/docs/cd/B28359_01/olap.111/b28124/whatsnew.htm According to
the answer; "Oracle OLAP uses standard Oracle database security." is a false statement and
"Meta data for Oracle OLAP is accessible in an external data dictionary" is a correct statement.
But in Oracle
documentation,
http://download.oracle.com/docs/cd/E11882_01/olap.112/e17123/overview.htm#i1
011393 ; is says "With Oracle OLAP, standard Oracle Database security features are used to
secure your multidimensional data.".
QUESTION: 60
Identity the true statement about a data warehouse
A. The data warehouse is typically refreshed as often as a transactional system,
B. Data warehouse queries are simpler than OLTP queries.
C. A data warehouse typically contains historical data.
D. Queries against a data warehouse never need summarized information.
Answer: C
Explanation:
http://wiki.oracle.com/page/Oracle+OLAP+Terminology-D
QUESTION: 61
Identify the statement about ASM that is NOT true.
A. ASM is easier to manage than file systems.
B. ASM delivers the performance of raw partitions.
1Z0-515
23
C. ASM is an extra cost option for Oracle databases.
D. ASM delivers automatic striping and mirroring.
Answer: B
Explanation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/asmprepare.htm
QUESTION: 62
Which two statements are true about the advantages of using a data warehouse?
A. A data warehouse uses fewer database structures, so access to answers is faster and easier
B. A data warehouse is typically implemented with a different design, making access faster.
C. A data warehouse is optimized for ongoing write activity, making response faster.
D. A data warehouse uses specialized features of the Oracle database, like materialized views
and star transformations, making response faster.
Answer: A, D
QUESTION: 63
What are two ways in which query performance can be improved with partitioning?
A. Partition pruning
B. Partition optimization
C. Partition compression
D. Partition-wise joins
Answer: A, D
QUESTION: 64
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?
A. Star schema
B. Snowflake schema
1Z0-515
24
C. Third normal form schema
D. OLAP
Answer: A
QUESTION: 65
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
QUESTION: 66
A Full Rack Oracle Exadata Database Machine can contain 100 TB of disk space with high
performance. How much user data should you conservatively estimate this configuration can
hold?
A. 100 TB
B. 75 TB
C. 50 TB
D. 28 TB
E. 20 TB
Answer: A
QUESTION: 67
What would you do to compress data in partitions that are frequently updated in Oracle
Database11g?
A. Use Hybrid Columnar Compression.
B. Use Advanced Compression Option.
1Z0-515
25
C. Use Hybrid Partitions.
D. Avoid compressing any data.
Answer: A
Explanation:
http://blogs.oracle.com/datawarehousing/2010/01/new_whitepaper_on_exadata_hybr.html
QUESTION: 68
The Analytic Workspace Manager would be used to generate_______.
A. Materialized views
B. Oracle OLAP Option cubes
C. Oracle Data Mining algorithms
D. Oracle SQL Analytic functions
Answer: B
Explanation:
http://forums.oracle.com/forums/thread.jspa?threadID=616811
QUESTION: 69
Which feature of Oracle Warehouse Builder can be used to help ensure data quality?
A. Data extraction
B. Data profiling
C. Logical mapping
D. Exception reporting
Answer: A
QUESTION: 70
Flash in the Oracle Exadata Database Machine is of lower latency (and enables faster access to
data) than:
A. Memory

26
B. Memory and locally attached disk
C. Memory and network-attached disk
D. Locally attached and network-attached disk
Answer: B