CompTIA CompTIA Certifications DS0-001 Questions & Answers

• Question 81:

  Which of the following is a reason to create a stored procedure?

  A. To minimize storage space

  B. To improve performance

  C. To bypass case sensitivity requirements

  D. To give control of the query logic to the user

  Correct Answer: B

  A reason to create a stored procedure is to improve performance. A stored procedure is a set of SQL statements or commands that are stored and compiled in the database server, and can be executed by name or by a trigger. A stored procedure can improve performance by reducing the network traffic between the client and the server, as only the name or the parameters of the stored procedure need to be sent, rather than the entire SQL code. A stored procedure can also improve performance by reusing the same execution plan, as the stored procedure is compiled only once and cached in the server memory. The other options are either not true or not relevant for this purpose. For example, a stored procedure does not necessarily minimize storage space, as it still occupies space in the database server; a stored procedure does not bypass case sensitivity requirements, as it still follows the rules of the database system; a stored procedure does not give control of the query logic to the user, as it is defined and maintained by the database administrator or developer. References: CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.2

  Given a scenario, create database objects using scripting and programming languages.

• Question 82:

  A server administrator wants to analyze a database server's disk throughput. Which of the following should the administrator measure?

  A. RPfvl

  B. Latency

  C. IOPS

  D. Reads

  Correct Answer: C

  The factor that the administrator should measure to analyze a database server's disk throughput is IOPS. IOPS, or Input/Output Operations Per Second, is a metric that measures the number of read and write operations that a disk can perform in one second. IOPS indicates the performance or speed of a disk and how well it can handle multiple requests or transactions. Higher IOPS means higher disk throughput and lower latency. IOPS can be affected by various factors, such as disk type, size, speed, cache, RAID level, etc. The other options are either not related or not sufficient for this purpose. For example, RPfvl is not a valid acronym or metric; latency is the time delay between a request and a response; reads are the number of read operations performed by a disk. References: CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.2 Given a scenario, monitor database performance.

• Question 83:

  Which of the following describes the purpose of a snapshot?

  A. To create a dynamic data replication

  B. To create a synonym

  C. To create a

  D. To create an image of a database

  Correct Answer: D

  The purpose of a snapshot is to create an image of a database. A snapshot is a copy of the state and content of a database at a specific point in time. A snapshot can be used for various purposes, such as backup and recovery, testing and development, reporting and analysis, etc. A snapshot can be created using various techniques, such as full copy, incremental copy, differential copy, etc. A snapshot can also be created using various tools or commands provided by the database system or software. The other options are either incorrect or irrelevant for this question. For example, dynamic data replication is a process that copies and synchronizes data from one database server (the source) to one or more database servers (the target) in real time; a synonym is an alias or an alternative name for an object in a database; C is an incomplete option. References: CompTIA DataSys+ Course Outline, Domain 5.0 Business Continuity, Objective 5.2 Given a scenario, implement backup and restoration of database management systems.

• Question 84:

  Following a security breach, a database administrator needs to ensure users cannot change data unless a request is approved by the management team. Which of the following principles addresses this issue?

  A. Open access

  B. Least resistance

  C. Elevated privilege

  D. Least privilege

  Correct Answer: D

  The principle that addresses this issue is least privilege. Least privilege is a security principle that states that users should only have the minimum level of access or permissions required to perform their tasks or roles. By applying this principle, the administrator can ensure that users cannot change data unless they have been authorized by the management team through a request approval process. This prevents unauthorized or accidental modifications of data that may compromise its integrity or security. The other options are either opposite or unrelated to this principle. For example, open access means that users have unrestricted access to data; least resistance means that users have the easiest or most convenient access to data; elevated privilege means that users have higher or more permissions than they need. References: CompTIA DataSys+ Course Outline, Domain 4.0 Data and Database Security, Objective 4.1 Given a scenario, apply security principles and best practices for databases.

• Question 85:

  Which of the followingbestdescribes a collection of data that shares the same properties or attributes?

  A. Relation set

  B. ER model

  C. Entity set

  D. Tuples

  Correct Answer: C

  The option that best describes a collection of data that shares the same properties or attributes is entity set. An entity set is a term used in the entity-relationship (ER) model, which is a conceptual model for designing and representing databases. An entity set is a collection of entities that have the same type or characteristics, such as students, courses, products, etc. An entity is an object or thing that can be identified and distinguished from others, such as a specific student, course, product, etc. An entity set can have one or more attributes that describe the properties or features of the entities, such as name, age, price, etc. An entity set can also have one or more relationships with other entity sets that define how the entities are associated or connected, such as enrolled, taught by, purchased by, etc. The other options are either different terms or not related to the ER model at all. For example, relation set is a term used in the relational model, which is a logical model for implementing and manipulating databases; ER model is a term used to refer to the entity-relationship model itself; tuples are rows or records in a table or relation. References: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.1 Given a scenario, identify common database types.

• Question 86:

  A database manager would like to reduce the overhead caused by log-based recoveries.

  Which of the following should the manager use to best mitigate the situation?

  A. Deadlocks

  B. Checkpoints

  C. Locks

  D. Indexes

  Correct Answer: B

• Question 87:

  Which of the following outlines why replication is important during database management?

  A. To ensure that all vulnerabilities within the database are classified and mitigated

  B. To ensure consistency, availability, and reliability between databases

  C. To ensure the performance of web applications is improved

  D. To ensure that an administrator can easily retrieve data from the database

  Correct Answer: B

• Question 88:

  Which of the following commands when executed will rebuild statistics against user-defined tables in a database?

  A. sp_autostats

  B. sp_updatestats

  C. DBCC UPDATEUSAGE

  D. DBCC SHOW_STATISTICS

  Correct Answer: B

• Question 89:

  Which of the following are ORM tools? (Choose two.)

  A. PLSQL

  B. XML

  C. Entity Framework

  D. T-SQL

  E. Hibernate

  F. PHP

  Correct Answer: CE

• Question 90:

  During a routine audit, a database administrator discovers that the department manager's birthday is next week. The database administrator decides to plan a birthday party for the manager. Which of the following guidelines would the administrator violate by planning the party?

  A. PII

  B. PCI DSS

  C. SOX

  D. ANSI

  Correct Answer: A