Which two statements are true for Data Guard environments with multi-tenant databases?
A.
Different pluggable databases within a logical standby database may have different guard statuses.
B.
The Data Guard broker automatically always opens the pluggable databases of a standby database after a
role change operation.
C.
The Data Guard broker automatically opens all pluggable databases of a primary database a role change
operation.
D.
The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root
container of a multi-tenant standby database.
E.
A multi-tenant standby database can have fewer pluggable databases than the primary container database.
Explanation:
C: If you execute a switchover or failover operation, the entire CDB undergoes the role change.
D: To administer a multitenant environment, you must have the CDB_DBA role.
https://docs.oracle.com/database/121/SBYDB/create_ps.htm
Correct Ans: A, D.
Data Guard Broker not necessary open all the pluggable databases. Operations are at the container level so there are chances that not ALL the pluggable databases are open so we need to manually open them using SQL.
It is not necessary to have same number of pluggable databases on Primary and Standby though it is recommended. All operations are container level so you cannot replicate across the containers and it will only synchronize the pluggable databases within the container database. In case you don’t have same number of pluggable databases then they are ignored during synchronization.
Sorry. It is C,D
I have the correct explanation but typo in earlier ans.
Oops D,E
A,B,C incorrect.
Can you share your email id
Let me know your email I’d if you want to connect
[email protected]
why C incorrect?
DG work at the container level and pluggable databases can have different open mode than the container database.
I made my own study notes and some of the answers are different order so few answers went sideways, however, the explanation is correct.
Why A incorrect? My email:[email protected] please help me
Explanation:
– To administer a multitenant environment, you must have the CDB_DBA role.
– Data Guard is managed at the CDB level. Individual PDBs cannot have a different database role than that of the CDB. Role transitions such as switchover and failover are performed at the CDB level. A primary database that is a CDB can have both physical and logical standby databases.
– You are not required to have the same set of PDBs at the primary database and standby. However, only tables that exist in the same container at both the primary and standby are replicated.
https://docs.oracle.com/database/121/SBYDB/create_ps.htm
Thank you
Can we communicate together as i have to join the exam next Monday and we need to discuss about some points stated here
my Email: [email protected] so please share with me your mail or Facebook account to communicate together
Have u cleared this exam?
yes
Sorry Ahmed. I didn’t see your comments until now. Hope you have cleared the exam. If you still want to communicate then let me know.
Let me know if you want to connect.
[email protected]
Yesterday I did the test 1z0-066. I failed the exam.
The most of questions were different of these
I found exam very difficult.
My score was 59%.
Does someone have the Oracle Data Guard 12c student guide ?
Thanks
Student Guide will not help. You have to read the 12c Manual. most of the questions they ask are actually from the manual