サンプル問題 1： Over 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.)
A: The access permissions for the service account used by the reporting application were not changed.
B: The new database server has its own reporting system, so the old one is not needed.
C: The reporting jobs that could not process during the database migration have locked the application.
D: The reporting application's mapping to the database location was not updated.
E: The database server is not permitted to fulfill requests from a reporting application.
F: The reporting application cannot keep up with the new, faster response from the database.
正解：A, D
Explanation: The most likely causes of the reporting application not working are that the access permissions for the service account used by the reporting application were not changed, and that the reporting application’s mapping to the database location was not updated. These two factors could prevent the reporting application from accessing the new database server. The other options are either irrelevant or unlikely to cause the problem. Reference: CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.2 Given a scenario, troubleshoot common database issues
サンプル問題 2： 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.
正解：A
Explanation: The approach that the administrator should use when conducting the stress test is to capture business logic, check the performance of codes, and report findings. This will help the administrator to evaluate how well the application handles high volumes of data and transactions, identify any bottlenecks or errors in the code, and provide feedback to the development team on how to improve the application’s efficiency and reliability. The other options are either too narrow or too broad in scope, and do not address the specific needs of an application that uses the Entity Framework. Reference: CompTIA DataSys+ Course Outline, Domain 4.0 Data and Database Security, Objective 4.3 Given a scenario, monitor database performance and security.
サンプル問題 3： 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?
A: [Peer-to-peer replication
B: Failover clustering
C: Log shipping
D: Availability groups
正解：A
Explanation: The administrator should use peer-to-peer replication to achieve this objective. Peer-to-peer replication is a type of replication that allows data to be distributed across multiple database instances that are equal partners, or peers. Each peer can read and write data that will be synchronized across all peers. This provides high availability, scalability, and load balancing for the application. The other options are either not suitable for this scenario or do not support bidirectional data synchronization. For example, failover clustering provides high availability but does not distribute the workload across multiple instances; log shipping provides disaster recovery but does not allow writing data to secondary instances; availability groups provide high availability and read-only access to secondary replicas but do not support peer-to-peer replication. Reference: CompTIA DataSys+ Course Outline, Domain 5.0 Business Continuity, Objective 5.3 Given a scenario, implement replication of database management systems.
