ExamGecko
Search Search Login
Home Home / CompTIA / DS0-001
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A database administrator would like to create a table named XYZ. Which of the following queries should the database administrator use to create the table? A) B) C) D)
Which of the following is most likely to prevent tampering with server hardware that houses data?
Which of the following is a characteristic of all non-relational databases?
Which of the following is the deployment phase in which a DBA ensures the most recent patches are applied to the new database?
A database administrator is new to a company and wants to create a document that illustrates the interaction between tables. Which of the following should the administrator create?
Which of the following is an attack in which an attacker hopes to profit from locking the database software?
Which of the following best describes the category of SQL commands required to revoke access to database objects?
A database's daily backup failed. Previous backups were completed successfully. Which of the following should the database administrator examine first to troubleshoot the issue?
Which of the following is a potential issue raised by enterprise database users?
Which of the following concepts applies to situations that require court files to be scanned for permanent reference and original documents be stored for ten years before they can be discarded?

Question 13 - DS0-001 discussion

Report
Export

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.
Answers
A.
Create a new service account exclusively for the business intelligence application.
B.
Build a separate data warehouse customized to the business intelligence application's specifications.
Answers
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.
Answers
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.
Answers
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.
Answers
E.
Open a new port on the database server exclusively for the business intelligence application.
Suggested answer: A

Explanation:

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.

Show Answer
asked 02/10/2024
m laven
30 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms