CompTIA DataSys+ Free Sample Questions

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 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? A.Monthly full, daily differentialB.Daily differentialC.Daily fullD.Weekly full, daily incremental

A 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? A.Create a new service account exclusively for the business intelligence application.B.Build a separate data warehouse customized to the business intelligence application's specifications.C.Set up a nightly FTP data transfer from the database server to the business intelligence application server.D.Send the business intelligence administrator the approved TNS names file to configure the data mapping.E.Open a new port on the database server exclusively for the business intelligence application.

A financial services company is deploying a new PostgreSQL database cluster for its high-frequency trading application. The primary requirements are zero data loss (RPO=0) upon primary node failure and automatic failover within 30 seconds (RTO<30s). The solution must also allow read-only queries to be distributed across secondary nodes. Which deployment architecture should the database architect implement?

A database administrator is tasked with migrating an on-premises 10TB data warehouse from a legacy system to a cloud platform. A key requirement is to minimize the initial migration downtime. The on-premises network has a stable but limited upload bandwidth of 1 Gbps. Which data transfer method should be used for the initial bulk data load?

A developer has created a report query that joins a Sales table (50 million rows) with a Customers table (2 million rows) and a Products table (10,000 rows). The query performance is unacceptably slow. The DBA analyzes the execution plan and discovers that the database is performing a full table scan on the Sales table. The WHERE clause filters on CustomerID and OrderDate. Which action would provide the MOST significant performance improvement?

A security audit of a company's main transactional database reveals that developers have direct SELECT access to tables containing Personally Identifiable Information (PII) for debugging purposes. To comply with GDPR and reduce the risk of data exposure, the security team mandates that direct table access must be revoked. However, developers still need a way to query non-sensitive data from these tables. Which security mechanism should be implemented to meet these requirements?

True or False: The primary purpose of the CONSISTENCY property in ACID is to ensure that a transaction, upon successful completion, will be permanently saved and survive any subsequent system failure.

A database administrator is setting up a new server and needs to automate a nightly task that involves exporting data, compressing it, and moving it to a network share. The server environment is Windows-based. Which scripting method would be MOST appropriate for automating this multi-step process with native tools?

A manufacturing company is designing a database to track its assembly line process. The system needs to capture data from IoT sensors at each stage of production. The data arrives at a very high velocity and has a simple structure (sensor_id, timestamp, value). The primary query pattern will be retrieving all data for a specific sensor over a given time range. High write throughput and horizontal scalability are critical. Which type of NoSQL database is the BEST fit for this workload?