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

Question

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.

• 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.

No community discussion yet for this question.