HCL-BF-PRO-10 practice question 2 of 15
Which of the following is the correct upgrade process when performing a BigFix Windows Root server upgrade that uses a remote database?
Full set: 60 questionsWhen upgrading an HCL BigFix Root Server on Windows that utilizes a remote database, the installation process involves updating the database schema. To perform these modifications on the remote SQL server, the user account running the installer on the BigFix server must have the necessary permissions. The sysadmin fixed server role in SQL Server is required to ensure the installer can successfully connect to the remote database and apply all necessary schema changes, create or modify database objects, and update data as part of the upgrade.
A. Running the installer as only a local administrator is insufficient, as this account lacks the required permissions to modify the schema and objects on the remote database server.
B. While upgrade Fixlets can be used to download and stage the installer, they do not inherently grant the necessary database permissions. The installer must still be executed with appropriate credentials.
C. This option is incorrect because it omits the critical requirement for database sysadmin permissions, which is the central challenge when dealing with a remote database upgrade.
1. HCL BigFix Platform 10.0 Installation Guide, "Upgrading on Windows systems with remote database," Section: "Before you begin." The documentation states: "Before upgrading the server, ensure that the user who runs the installation has the system administrator privileges on the local computer and the sysadmin authority on the remote database." (URL: https://help.hcltechsw.com/bigfix/10.0/platform/Platform/Installation/cupgradingonwindowssystemsw.html)
2. HCL BigFix Platform 10.0 Installation Guide, "Upgrading on Windows systems with remote database," Section: "Procedure," Step 2. The guide instructs: "To upgrade the server components, run the installer as a user that has sysadmin permissions to the database server." This explicitly confirms the requirement. (URL: https://help.hcltechsw.com/bigfix/10.0/platform/Platform/Installation/cupgradingonwindowssystemsw.html)
Keep practicing
Take the free HCL-BF-PRO-10 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other HCL-BF-PRO-10 practice questions
- Question 1A BigFix Administrator will be performing an upgrade in a Distributed Server Architecture…
- Question 3The Big Fix Diagnostics Tool performs a complete test on the server components. When can …
- Question 4How can the Relay Diagnostics page be secured?
- Question 5BigFix Console operators have various rights and restrictions when activating, deactivati…
- Question 6Which type of operators are allowed to create an analysis?
- Question 7Which of the following must be performed by the Site Administrator?
