Question 1

An administrator needs to provision a 3-node MSSQL Server AG with the following configuration: • Two database server VMS including the primary replica on a local site • A third database server VM on a remote site How many IP addresses will the network at each site require?

Options :

A : 2 Cluster VIP and 1 listener IP on the local site

B :

1 Cluster VIP and 1 listener IP on the remote site 2 IPs in the local site and 1 on the remote site for the database server nodes 1 Cluster VIP on the local site 1 Cluster VIP and 1 Listener IP on the remote site 2 IPs in the local site and 1 on the remote site for the database server nodes

C :

I Cluster VIP end I Listener IP on the local site 1 Listener IP on the local site 2 IPs in the local site and I on the remote site for the database server nodes

D :

Cluster VIP end I Listener IP on the local site 1 Cluster VIP and 1 Listener IP on the remote site 2 IPs in the local site and 1 on the remote site for the database server nodes

Answer: D

Question 2

An administrator would like to leverage the Oracle restore feature within NDB for a RAC database. Prior to the restoration operation, what must the administrator do?

Options :

A : Ensure the database is in a Down state.

B : Ensure the database is registered with NDB.

C : Ensure the database is in an Up state.

D : Ensure more than one node of the RAC is reachable.

Answer: B

Question 3

Era allows custom metadata to be assigned to entities (clones, time machines, databases, and database servers) by using which component?

Options :

A : Tags

B : Notes

C : Text

D : Index

Answer: A

Question 4

An administrator is creating a Windows Domain profile in Era. Which optional field can be skipped and provided during the provisioning process?

Options :

A : Domain to join

B : Domain Account

C : Organizational Units

D : SQL Service Startup Account

Answer: D

Question 5

What is used to temporarily store the transaction logs of the source database before they are copied to the log?

Options :

A : Database Agent

B : NDB Drive

C : Time Machine

D : NDB Profiles

Answer: A

Free NCP-DB-6.10 Mock Exam – Practice Online Confidently

Buying Options: