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

Which disk is omitted from a Software Profile?

Options :

A : System Page File

B : SQL Installation

C : User Database

D : System Database

Answer: A

Question 3

Which statement is true regarding the NDB alert retention feature?

Options :

A : NDB supports alert retention globally.

B : NDB supports retention at the individual policy.

C : NDB supports retention at the grouped policy.

D : NDB supports retention at the registered cluster.

Answer: A

Question 4

In NDB, which two Time Machine options are available when creating a database clone? {Choose two.)

Options :

A : Point in time

B : Restore point

C : Backup

D : Snapshot

Answer: A,D

Question 5

A Linux OS is running a PostgreSQL instance that is managed by NDB. This instance is not working properly after a manual OS update, so an administrator has prepared a new Linux DB server VM that is ready to host the data from the broken DB. Which action should the administrator perform to migrate data to the new DB server VM?

Options :

A : Provision a new PostgreSQL instance from the Databases page.

B : From The Machine policy, Authorize Database Sever VMs.

C : Follow the Provision a PostgreSQL Instance wizard.

D : Register the new DB Server VM in NDB.

Answer: D