CompTIA DS0-001 - CompTIA DataSys+ Exam
Page: 2 / 19
Total 93 questions
Question #6 (Topic: Exam A)
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?
A. Capture business logic, check the performance of codes, and report findings.
B. Check the clustered and non-clustered indexes, and report findings.
C. Review application tables and columns, and report findings.
D. Write queries directly into the database and report findings.
Answer: A
Question #7 (Topic: Exam A)
A database administrator is creating a table, which will contain customer data, for an online business. Which of the following SQL syntaxes should the administrator use to create an object?
A. <img title="image11" src="https://img.itexams.com/ds0-001/image11.png">
B. <img title="image12" src="https://img.itexams.com/ds0-001/image12.png">
C. <img title="image13" src="https://img.itexams.com/ds0-001/image13.png">
D. <img title="image14" src="https://img.itexams.com/ds0-001/image14.png">
Answer: D
Question #8 (Topic: Exam A)
A database administrator wants to remove inactive customers from a database. Which of the following statements should the administrator use?
A. <img title="image15" src="https://img.itexams.com/ds0-001/image15.png">
B. <img title="image16" src="https://img.itexams.com/ds0-001/image16.png">
C. <img title="image17" src="https://img.itexams.com/ds0-001/image17.png">
D. <img title="image18" src="https://img.itexams.com/ds0-001/image18.png">
Answer: D
Question #9 (Topic: Exam A)
Which of the following is the correct order of the steps in the database deployment process?
A. 1. Connect<br />
2. Install<br />
3. Configure<br />
4. Confirm prerequisites<br />
5. Validate<br />
6. Test<br />
7. Release
B. 1. Configure<br />
2. Install<br />
3. Connect<br />
4. Test<br />
5. Confirm prerequisites<br />
6. Validate<br />
7. Release
C. 1. Confirm prerequisites<br />
2. Install<br />
3. Configure<br />
4. Connect<br />
5. Test<br />
6. Validate<br />
7. Release
D. 1. Install<br />
2. Configure<br />
3. Confirm prerequisites<br />
4. Connect<br />
5. Test<br />
6. Validate<br />
7. Release
Answer: C
Question #10 (Topic: Exam A)
A company wants to deploy a new application that will distribute the workload to five different database instances. The database administrator needs to ensure that, for each copy of the database, users are able to read and write data that will be synchronized across all of the instances.
Which of the following should the administrator use to achieve this objective?
Which of the following should the administrator use to achieve this objective?
A. Peer-to-peer replication
B. Failover clustering
C. Log shipping
D. Availability groups
Answer: A
