Identify the three components that serve a purpose only in the Database Machine.
A.
ASM intelligent Data Placement (IDP)
B.
Intelligent Database Protocol (IDB)
C.
Database Resource Manager (DBRM)
D.
I/O Resource Manager (IORM)
E.
Database Filesystem (DBFS)
F.
The DISKMON process
Explanation:
A:Intelligent Data Placement, a feature of ASM that allows placing data in such a
way that more frequently accessed data is located close to the periphery of the disk where the
access is faster.
B:The Exadata software is optimally divided between the database servers and Exadata
cells. The database servers and Exadata Storage Server Software communicate using the iDB –
the Intelligent Database protocol. iDB is implemented in the database kernel and transparently
maps database operations to Exadata-enhanced operations. iDB implements a function shipping
architecture in addition to the traditional data block shipping provided by the database. iDB is
used to ship SQL operations down to the Exadata cells for execution and to return query result
sets to the database kernel. Instead of returning database blocks, Exadata cells return only the
D:The inter-database I/O allocations are defined within the software in the Exadata cell and
managed by the I/O Resource Manager (IORM). The Exadata cell software ensures that interdatabase I/O resources are managed and properly allocated within, and between, databases.
I think correct answer should be F instead of A as Diskmon process is not dedicated for exadata and it is not running in grid database 11.2.0.3 and later.
Confusing! except B & D all other processes are from 11gR2 and earlier. I don’t know how to pick third choice here which is only present in Exadata Database Machine.
donkeys – BDF, @rumi why are you confused? if the diskmon just run on the database machine.
cachero -When it says database machine it include compute node and cell node .In your opinion then B is wrong it is running on cell node .
the correct answer is BDE
B, D, E, F all are correct answers. DBFS exist in non-exadata also but does not functional. DBFS exist only in exadata.
b d f
B, D & F is correct answer.
DBFS is not an exadata specific feature. PFB the corresponding blog and its implementation requirement which doesnt mandate for exadata machine
http://kevinclosson.net/2009/12/17/oracle-database-file-system-dbfs-its-not-an-exadata-feature-part-i/
https://ronnyegner.wordpress.com/2009/10/08/the-oracle-database-file-system-dbfs/
And to add diskmod plays its role in exadata env only.
http://dbmentors.blogspot.in/2013/10/exadata-what-differentiates-gi-on.html
Database Machine refers to Exadata, including compute nodes and cell nodes
A is wrong. IDP is not exadata specific.
B is right. compute node and cell node use iDB to communicate
C is wrong. DBRM is not exadata specific.
D is right. IORM only exists in exadata
E is wrong. DBFS is not exadata specific.
F is right. DISKMON process only for exadata but running on compute node (CRS)
So B.D.F. are correct
B.D.F. are correct
BDF
B Intelligent Database Protocol (IDB)
D I/O Resource Manager (IORM)
F The DISKMON process
Explanation:
IDB it’s the protocol used by infiniband
IORM allow workload and databases to share I/O resources and is executed inside exadata storage
DISKMON is a monitoring processes that checks whether cells are alive or not and it’s also responsible for propagating DBRM plan to storage cell. Normally when you install grid in a non-exadata environment this component appears as “offline”
Cleared the 1Z0-027 exam several days ago!
Scored 87% for the second try! (The passing score is 60%.)
Total 90 questions, they are mainly on Exadata Database Machine, ILOM, RMAN, I/O resource, CellCLI (commands), OLTP…etc.
I used the latest version PassLeader 107q dumps (here it is: http://www.passleader.com/1z0-027.html)
Almost all questions were from it, and some wrong answers have been corrected in that PL 107q dumps, the most valid 1Z0-027 dumps!
By the way, part of that 107q PassLeader 1Z0-027 dumps are available on Google Drive for free:
https://drive.google.com/open?id=0B-ob6L_QjGLpZ05EYlhnaTd2VGs
(It seems that PL just updated that 107q files…)
Good Luck!!!