DS0-001: CompTIA DataSys+ — Free Practice Questions
10 free sample questions from a bank of 10, with the correct answers and explanations. No signup required — start practising right now.
1Over the weekend, a company’s transaction database was moved to an upgraded server. All validations performed after the migration indicated that the database was functioning as expected. However, on Monday morning, multiple users reported that the corporate reporting application was not working.
Which of the following are the most likely causes? (Choose two.)
- The access permissions for the service account used by the reporting application were not changed.
- The new database server has its own reporting system, so the old one is not needed.
- The reporting jobs that could not process during the database migration have locked the application.
- The reporting application’s mapping to the database location was not updated.
- The database server is not permitted to fulfill requests from a reporting application.
- The reporting application cannot keep up with the new, faster response from the database.
Answer: A, D
2Given the following customer table:
Which of the following ORM snippets would return the ID, state, and country of all customers with the newest customers appearing first?
Answer: B
3A DBA is reviewing the following logs to determine the current data backup plan for a primary data server:
Which of the following best describes this backup plan?
- Monthly full, daily differential
- Daily differential
- Daily full
- Weekly full, daily incremental
Answer: D
4A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company’s transactional data. Which of the following tasks should the administrator perform first?
- Create a new service account exclusively for the business intelligence application.
- Build a separate data warehouse customized to the business intelligence application's specifications.
- Set up a nightly FTP data transfer from the database server to the business intelligence application server.
- Send the business intelligence administrator the approved TNS names file to configure the data mapping.
- Open a new port on the database server exclusively for the business intelligence application.
Answer: A
5Which of the following scripts would set the database recovery model for sys.database?
Answer: A
6A 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.
Answer: A
7A 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?
Answer: D
8A database administrator wants to remove inactive customers from a database. Which of the following statements should the administrator use?
Answer: D
9Which of the following is the correct order of the steps in the database deployment process?
- 1. Connect 2. Install 3. Configure 4. Confirm prerequisites 5. Validate 6. Test 7. Release
- 1. Configure 2. Install 3. Connect 4. Test 5. Confirm prerequisites 6. Validate 7. Release
- 1. Confirm prerequisites 2. Install 3. Configure 4. Connect 5. Test 6. Validate 7. Release
- 1. Install 2. Configure 3. Confirm prerequisites 4. Connect 5. Test 6. Validate 7. Release
Answer: C
10A 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?
- Peer-to-peer replication
- Failover clustering
- Log shipping
- Availability groups
Answer: A
Want the full bank of 10 questions for DS0-001: CompTIA DataSys+? See all practice exams.