ExamGecko
Question list
Search
Search

Related questions

Question 59 - NCP-DB-6.5 discussion

Report
Export

An administrator needs to deploy a cumulative update (CU) for SQL Server.

What steps would the administrator take to prepare this deployment with NDB?

A.
Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.
Answers
A.
Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.
B.
Create a new Software Profile version using the CU executable and publish that version.
Answers
B.
Create a new Software Profile version using the CU executable and publish that version.
C.
Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
Answers
C.
Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
D.
Create a new Software Profile using the CU executable and publish that profile.
Answers
D.
Create a new Software Profile using the CU executable and publish that profile.
Suggested answer: C

Explanation:

The correct answer is C because it follows the recommended procedure for applying a CU to a SQL Server Software Profile in NDB. By applying the patch to the profile VM, the administrator ensures that the CU is compatible with the existing Software Profile settings and configuration. By creating a new Software Profile version, the administrator preserves the previous version of the Software Profile for rollback purposes and allows the new version to be tested and published. Option A is incorrect because it deletes the existing Software Profile, which may cause data loss and prevent rollback. Option B is incorrect because it does not apply the patch to the profile VM, which may result in errors or inconsistencies in the Software Profile. Option D is incorrect because it creates a new Software Profile instead of a new version, which may cause confusion and duplication.

Nutanix Database Management & Automation (NDMA) course, Module 5: Patching Databases Using NDB, Lesson 5.2: Creating and Modifying Software Profiles

Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 4 - Operate and Maintain an NDB Environment

Nutanix Database Service (NDB) User Guide, Chapter 5: Patching Databases Using NDB, Section 5.2: Creating and Modifying Software Profiles

Nutanix Database Service (NDB) User Guide, Chapter 5: Patching Databases Using NDB, Section 5.3: Testing and Publishing Database Patches

asked 23/09/2024
Oleksii Ivanov
45 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first