CompTIA DataSys+ (DS0-001) Certification Sample Questions
The purpose of this Sample Question Set is to provide you with information about the CompTIA DataSys+ exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the DS0-001 certification test. To get familiar with real exam environment, we suggest you try our Sample CompTIA DataSys+ Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual CompTIA DataSys+ certification exam.
These sample questions are simple and basic questions that represent likeness to the real CompTIA DS0-001 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium CompTIA DataSys+ Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.
CompTIA DS0-001 Sample Questions:
01. Profiling shows an ORM issues one query to load a list of authors, then a separate query per author to load each author's books, producing hundreds of small round trips to render one page. Which ORM configuration change resolves this most directly?
a) Switch the association to lazy loading
b) Increase the ORM connection-pool size
c) Enable eager loading so related books are fetched in a single join
d) Add a per-entity cache expiry to each author object
02. An application connects to the database using a service account that is currently a member of the highest-privilege administrative role. Which changes BEST apply the principle of least privilege to this account?
(Choose two.)
a) Reuse the same account across all applications for consistency.
b) Remove the account from the administrative role.
c) Enable interactive login so administrators can share the account.
d) Give the account rights to change server-wide configuration for flexibility.
e) Grant only the specific object permissions the application actually requires.
03. During a load test, throughput rises with load until about 400 concurrent connections, then plateaus while response latency climbs sharply. Server CPU holds steady near 55%, and the database's wait statistics are dominated by lock waits. What does this result MOST likely indicate?
a) Lock contention, not hardware, is the primary bottleneck limiting concurrency.
b) The load test is invalid and its results should be discarded.
c) The server needs additional CPU cores to scale further.
d) Network bandwidth between the client and server is saturated.
04. A database in the full recovery model experiences rapid transaction-log growth during nightly bulk operations. Which two actions help control the log growth without abandoning point-in-time recovery?
(Choose two.)
a) Rewrite every query to use nested subqueries
b) Repeatedly shrink the log file after each batch
c) Break very large single transactions into smaller committed batches
d) Take more frequent transaction-log backups during the operation
e) Disable all indexes on the affected tables
05. To reduce fraud risk, an organization ensures that the person who requests a production data change is never the same person who approves and applies it. Which principle is being enforced?
a) Least privilege.
b) Separation of duties.
c) Data minimization.
d) Defense in depth.
06. A table OrderLines(OrderID, ProductID, Quantity, ProductName, ProductPrice) uses the composite primary key (OrderID, ProductID). The values in ProductName and ProductPrice depend only on ProductID, not on the whole key. Which normalization issue does this table exhibit, and to which normal form should it be taken to resolve it?
a) Partial dependency; normalize to second normal form (2NF)
b) Transitive dependency; normalize to third normal form (3NF)
c) Multivalued attribute; normalize to first normal form (1NF)
d) Redundant candidate key; convert to Boyce-Codd normal form (BCNF)
07. Whenever a row is removed from the accounts table, the system must automatically write a record to an audit table — without relying on application developers to remember to call any routine. Which database object enforces this most reliably?
a) A scalar user-defined function
b) A stored procedure invoked by the application
c) A materialized view over the accounts table
d) An after-delete trigger
08. A backup job has reported success every night for months, yet the team wants proof that the backups are actually recoverable. Which actions confirm that a backup is usable?
(Choose two.)
a) Confirm the backup file grew in size compared to the prior night.
b) Confirm the backup job's status shows success.
c) Validate row counts and integrity checks against the restored data.
d) Restore the backup to an isolated environment.
09. Inside one transaction, a report reads a row and records its value. A second transaction then updates that same row and commits. When the first transaction reads the row again, it sees the new value. Which anomaly is this, and what is the LOWEST isolation level that prevents it?
a) Dirty read; prevented by Read Committed.
b) Non-repeatable read; prevented by Repeatable Read.
c) Lost update; prevented by Read Uncommitted.
d) Phantom read; prevented by Serializable.
10. An application stores small precomputed results, each retrieved by a single unique string identifier. The workload never filters or queries by any other attribute and needs very fast get and put operations by that identifier alone. Which non-relational database model is the BEST fit?
a) Key-value store
b) Graph database
c) Column-oriented database
d) Relational database
Answers:
|
Question: 01 Answer: c |
Question: 02 Answer: b, e |
Question: 03 Answer: a |
Question: 04 Answer: c, d |
Question: 05 Answer: b |
|
Question: 06 Answer: a |
Question: 07 Answer: d |
Question: 08 Answer: c, d |
Question: 09 Answer: b |
Question: 10 Answer: a |
Note: For any error in CompTIA DataSys+ (DS0-001) certification exam sample questions, please update us by writing an email on feedback@edusum.com.
