nerdexam
CompTIA

DS0-001 · Question #4

A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company's transactional data. Which of the following tasks should the adminis

The correct answer is A. Create a new service account exclusively for the business intelligence application.. The first step is to create a dedicated service account exclusively for the business intelligence application. This follows the security principle of least privilege: each application should have its own identity so that access can be granted, audited, and revoked independently.

Data and Database Security

Question

A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company's transactional data. Which of the following tasks should the administrator perform first?

Options

  • ACreate a new service account exclusively for the business intelligence application.
  • BBuild a separate data warehouse customized to the business intelligence application's
  • CSet up a nightly FTP data transfer from the database server to the business intelligence
  • DSend the business intelligence administrator the approved TNS names file to configure the data
  • EOpen a new port on the database server exclusively for the business intelligence application.

How the community answered

(28 responses)
  • A
    79% (22)
  • C
    4% (1)
  • D
    11% (3)
  • E
    7% (2)

Explanation

The first step is to create a dedicated service account exclusively for the business intelligence application. This follows the security principle of least privilege: each application should have its own identity so that access can be granted, audited, and revoked independently. Without a service account, you cannot configure permissions, connection strings, or network access for the application. The other options (building a data warehouse, setting up FTP transfers, sharing TNS names, opening ports) are all downstream tasks that depend on first having a properly scoped identity for the application to authenticate with.

Topics

#Database security#Access control#Service accounts#Application integration

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice