2024 Valid DS0-001 FREE EXAM DUMPS QUESTIONS & ANSWERS [Q17-Q32]

Rate this post

2024 Valid DS0-001 FREE EXAM DUMPS QUESTIONS & ANSWERS

Free DS0-001 Exam Braindumps CompTIA Pratice Exam

Q17. Which of the following sets the age requirement for data that should be recovered after a major disaster?

MTBF

RTO

MTTF

RPO

Q18. 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?

Open access

Least resistance

Elevated privilege

Least privilege

Q19. Which of the following NFs is considered the most preferable for relational database design?

1 NF

3 NF

4 NF

2NF

Q20. An on-premises application server connects to a database in the cloud. Which of the following must be considered to ensure data integrity during transmission?

Bandwidth

Encryption

Redundancy

Masking

Q21. Which of the following statements contains an error?

Select EmpId from employee where EmpId=90030

Select EmpId where EmpId=90030 and DeptId=34

Select* from employee where EmpId=90030

Select EmpId from employee

Q22. Which of the following scripts would set the database recovery model for sys.database?

Q23. Which of the following would a database administrator monitor to gauge server health? (Choose two.)

CPU usage

Memory usage

Transaction logs

Network sniffer

Domain controllers

Firewall traffic

Q24. Which of the following is most likely to prevent tampering with server hardware that houses data?

Biometric locks

Strong password policy

Network firewall

Surveillance cameras

Q25. 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?

Data loss prevention

Data retention policies

Data classification

Global regulations

Q26. Which of the following best describes a collection of data that shares the same properties or attributes?

Relation set

ER model

Entity set

Tuples

Q27. A database administrator needs to provide access to data from two different tables to multiple group users in order to facilitate ongoing reporting. However, some columns in each table are restricted, and users should not be able to see the values in these columns.
Which of the following is the best action for the administrator to take?

Create a stored procedure.

Create a view.

Create a csv export.

Create a trigger.

Q28. A database administrator is conducting a stress test and providing feedback to a team that is developing an application that uses the Entity Framework. Which of the following explains the approach the administrator should use when conducting the stress test?

Capture business logic, check the performance of codes, and report findings.

Check the clustered and non-clustered indexes, and report findings.

Review application tables and columns, and report findings.

Write queries directly into the database and report findings.

Q29. Which of the following types of RAID, if configured with the same number and type of disks, would provide the best write performance?

RAID 3

RAID 5

RAID 6

RAID 10

Q30. 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?

DOU

SLA

MOU

SOW

Q31. A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?

Durability

Isolation

Atomicity

Consistency

Q32. Which of the following is an advantage of creating indexes?

To help with space allocation

To provide quick and efficient access to data