CompTIA DS0-001 Exam - Topic 4 Question 49 Discussion

Actual exam question for CompTIA's DS0-001 exam

Question #: 49
Topic #: 4

A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company's transactional dat

a. Which of the following tasks should the administrator perform first?

ACreate a new service account exclusively for the business intelligence application.

BBuild a separate data warehouse customized to the business intelligence application's specifications.

CSet up a nightly FTP data transfer from the database server to the business intelligence application server.

DSend the business intelligence administrator the approved TNS names file to configure the data mapping.

EOpen a new port on the database server exclusively for the business intelligence application.

Show Suggested Answer

Suggested Answer: A

The first task that the administrator should perform is to create a new service account exclusively for the business intelligence application. This will ensure that the application has the appropriate permissions and credentials to access the company's transactional data. The other options are either unnecessary, inefficient, or insecure. For example, building a separate data warehouse would require additional resources and time, setting up a nightly FTP data transfer would expose the data to potential breaches, sending the TNS names file would not guarantee that the application can connect to the database, and opening a new port on the database server would create a vulnerability for attackers.Reference:CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.1 Given a scenario, install and configure database software and tools.

by Lonna at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium DS0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Raina

3 days ago

A) Can't have the BI app using the same account as everyone else. Gotta keep it locked down.

upvoted 0 times

...

Izetta

8 days ago

D) Seems like the quickest and easiest solution. Why complicate things?

upvoted 0 times

...

Walker

13 days ago

B) Definitely the way to go. Gotta keep that transactional data separate, you know?

upvoted 0 times

...

Patria

19 days ago

Building a separate data warehouse sounds important, but I wonder if that’s really the first task or if we should focus on access first.

upvoted 0 times

...

Chandra

24 days ago

I’m leaning towards option D, sending the TNS names file, but I feel like there might be something more critical to do first.

upvoted 0 times

...

Justa

29 days ago

I remember a similar question where we had to consider security first, so maybe the service account is the right choice here.

upvoted 0 times

...

Floyd

1 month ago

I think the first step should be creating a new service account for the application, but I'm not entirely sure if that's the best option.

upvoted 0 times

...

Corrie

1 month ago

I'm pretty confident the service account is the way to go here. It's a standard practice for isolating application access and keeping things secure.

upvoted 0 times

...

Marti

1 month ago

The FTP data transfer could work, but it might be a bit clunky. Sending the TNS names file seems like the most straightforward way to get the BI app connected to the data.

upvoted 0 times

...

Izetta

2 months ago

Opening a new port just for the BI app seems like it could create some security risks. I'd want to explore the other options first before going that route.

upvoted 0 times

...

Glenn

2 months ago

I'm a little confused on the difference between building a separate data warehouse and just configuring the data mapping. Wouldn't the data warehouse be overkill for this scenario?

upvoted 0 times

...

Trinidad

2 months ago

I think the best approach here is to create a new service account for the business intelligence application. That way we can ensure the proper permissions and access controls are in place.

upvoted 0 times

...