Oracle Exam 1Z0-070 Topic 6 Question 5 Discussion

Actual exam question for Oracle's 1Z0-070 exam

Question #: 5
Topic #: 6

[All 1Z0-070 Questions]

Which two are true about Smart Scan?

AA query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.

BColumn projection does not contribute to the performance benefit of Smart Scan.

CA query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.

DIt is possible to offload single row functions to the Exadata Storage Servers.

EJoin processing can be partly offloaded to Exadata Storage Servers.

FJoin processing can be fully offloaded to Exadata Storage Servers.

Show Suggested Answer

Suggested Answer: D, E

D: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.

E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.

References:

http://www.centroid.com/blog/exadata-smart-scan-processing

by Carissa at May 05, 2022, 11:07 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-070 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!