CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. CompTIA
  5. DS0-001

Free DS0-001 Exam Braindumps (page: 8)

Page 7 of 21
PDF with 93 Questions

A programmer wants to configure a database to only allow read or write access when requests are coming from specific IP addresses.
Which of the following can be used to configure IP addresses to allow access to the database?

  1. Static IP address
  2. Firewall
  3. Dynamic IP address
  4. IDNS

Answer(s): B

Explanation:

The best option to configure IP addresses to allow access to the database is a firewall. A firewall is a network device or software that controls the incoming and outgoing traffic based on a set of rules or policies. A firewall can be used to filter the traffic by IP addresses, ports, protocols, or other criteria,

and allow or deny access to the database accordingly. The other options are either not relevant or not sufficient for this task. For example, a static IP address is an IP address that does not change over time, but it does not determine the access to the database; a dynamic IP address is an IP address that changes periodically, but it does not control the traffic to the database; an IDNS is an Internet Domain Name System, which translates domain names into IP addresses, but it does not regulate the access to the database.


Reference:

CompTIA DataSys+ Course Outline, Domain 4.0 Data and Database Security, Objective 4.2 Given a scenario, implement security controls for databases.



A company needs to prepare a document that establishes the responsibilities, metrics, penalties, and other generalities that a provider would have to fulfill for customers to use its platforms.
Which of the following documents meets these requirements?

  1. DOU
  2. SLA
  3. MOU
  4. SOW

Answer(s): B

Explanation:

The document that meets these requirements is an SLA. An SLA, or Service Level Agreement, is a contract between a service provider and a customer that defines the scope, quality, and terms of the service delivery. An SLA typically includes the responsibilities, metrics, penalties, and other generalities that a provider would have to fulfill for customers to use its platforms. An SLA also establishes the expectations and obligations of both parties, as well as the methods for measuring and monitoring the service performance. The other options are either different types of documents or not related to service delivery. For example, a DOU, or Data Use Agreement, is a document that governs the sharing and use of data between parties; an MOU, or Memorandum of Understanding, is a document that expresses a mutual agreement or intention between parties; a SOW, or Statement of Work, is a document that describes the specific tasks and deliverables of a project or contract.


Reference:

CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.4 Given a scenario, implement service level agreements.



A DBA left the company, and the DBA's account was removed from the system. Soon after, scheduled jobs began failing.
Which of the following would have most likely prevented this issue?

  1. Load balancing
  2. Business continuity plan
  3. Service accounts
  4. Assigning a data steward

Answer(s): C

Explanation:

The most likely way to prevent this issue is to use service accounts. Service accounts are special accounts that are used by applications or services to perform tasks or run jobs on behalf of users. Service accounts have limited permissions and access rights that are tailored to their specific functions. By using service accounts, the DBA can ensure that scheduled jobs can run independently of individual user accounts, and avoid failures due to account removal or changes. The other options are either not related or not effective for this issue. For example, load balancing is a technique that distributes the workload across multiple servers or resources to improve performance and availability; business continuity plan is a plan that outlines how an organization will continue its operations in the event of a disaster or disruption; assigning a data steward is a process that designates a person who is responsible for ensuring the quality and governance of data.


Reference:

CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.3 Given a scenario, migrate data between databases.



A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table.
Which of the following describes where the undo is stored?

  1. In the system global area
  2. In the undo
  3. In the SYSAUX
  4. In the temporary

Answer(s): D

Explanation:

The correct answer is D. When undo management with temporary undo is enabled, the undo data is stored in the temporary tablespace instead of the undo tablespace. The temporary tablespace is a tablespace that stores temporary data such as sort results or intermediate query results. The undo data is the data that records the changes made by transactions on the database. Undo data is used to roll back transactions in case of errors or failures, or to provide read consistency for concurrent queries. By storing undo data in the temporary tablespace, the database can reduce the space consumption and contention in the undo tablespace, and improve performance and scalability. The other options are either incorrect or irrelevant for this question. For example, the system global area is a memory area that stores information shared by all sessions connected to an instance; the undo tablespace is a tablespace that stores undo data by default; the SYSAUX tablespace is a tablespace that stores auxiliary information for various database features.


Reference:

CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.1 Given a scenario, perform common database maintenance tasks.






Post your Comments and Discuss CompTIA DS0-001 exam with other Community members:

DS0-001 Discussions & Posts