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?
- A. Create a new service account exclusively for the business intelligence application. Correct
- B. Build a separate data warehouse customized to the business intelligence application's specifications.
- C. Set up a nightly FTP data transfer from the database server to the business intelligence application server.
- D. Send the business intelligence administrator the approved TNS names file to configure the data mapping.
- E. Open a new port on the database server exclusively for the business intelligence application.
Explanation
Before an application can read the transactional data, it needs its own identity on the database, so the first step is a dedicated service account that can be granted least-privilege, read access and audited separately. Connection details such as a TNS names file only help once there is an account to connect with. Building a separate warehouse or a nightly FTP export is unnecessary to give access, and a dedicated port adds no access control.
