Step2Study

CompTIA DataSys+ (DS0-001) practice questions

231 free questions with answers and explanations.

Practice test
  1. 201.A database development team has completed a new database schema for an upcoming application release. Before deploying to the production environment, the database administrator needs to ensure that the new schema changes will not break existing applications or cause data integrity issues. Which of the following is the BEST approach to validate the new schema?Database Deployment
  2. 202.A database administrator is deploying a new database server that will host a real-time analytics application. The application frequently performs complex aggregations and joins over large datasets. Which type of database would be most suitable for this workload, prioritizing analytical query performance and scalability for large data volumes?Database Deployment
  3. 203.A database administrator is deploying a new PostgreSQL database server on a Linux host. As part of the post-installation configuration, the administrator needs to ensure that only specific IP addresses and users can connect to the database. Which configuration file should be modified to achieve this?Database Deployment
  4. 204.A database administrator is planning the deployment of a new database server for an application that will experience peak loads during specific business hours, requiring a significant increase in CPU and memory resources. Outside of these hours, resource utilization is low. Which cloud deployment model would be MOST cost-effective while ensuring performance during peak times?Database Deployment
  5. 205.A database administrator is deploying a new database server for a high-traffic e-commerce application. The application requires extremely low latency for read operations and must maintain data consistency across multiple geographically dispersed regions. Which replication strategy would best meet these requirements?Database Deployment
  6. 206.A database administrator is planning the deployment of a new PostgreSQL database on a virtual machine. To ensure consistent performance and prevent resource contention with other VMs on the same host, the administrator needs to reserve a specific amount of CPU and memory for the database VM. Which virtualization concept is being applied here?Database Deployment
  7. 207.A database administrator is deploying a new MySQL database server that will serve a high-volume transactional application. To optimize read performance and reduce I/O contention, the administrator wants to ensure that frequently accessed data and indexes are cached in memory. Which MySQL configuration parameter should be tuned to achieve this goal?Database Deployment
  8. 208.A database administrator is planning to deploy a new PostgreSQL database server on a Linux host. To ensure proper resource allocation and prevent the database from consuming all system memory, the administrator needs to configure the maximum amount of memory PostgreSQL can use for caching data and indexes. Which parameter in `postgresql.conf` controls this setting?Database Deployment
  9. 209.A data engineering team is deploying a new data lake solution that requires a database capable of storing vast amounts of unstructured and semi-structured data, with flexible schema capabilities. The primary access pattern will be retrieving entire documents or collections of documents based on various attributes. Which NoSQL database type is most suitable for this scenario?Database Deployment
  10. 210.A database administrator is planning the deployment of a new PostgreSQL database on a virtual machine (VM). The application using this database is mission-critical and requires consistent, high-performance I/O and CPU resources. To prevent resource contention with other VMs on the same host, what configuration should the administrator implement?Database Deployment
  11. 211.A database administrator is installing a new Oracle database server. After the installation, the administrator needs to verify that the Oracle Listener service is running correctly and accepting connections. Which command should the administrator use to check the status of the Listener?Database Deployment
  12. 212.A database administrator is performing pre-deployment validation for a new critical financial application. The application requires that all database transactions are processed reliably, maintaining data consistency even in the event of system failures. Which set of properties must the underlying database system adhere to to meet this requirement?Database Deployment
  13. 213.A database development team has completed a new database schema for an upcoming application. Before deploying to production, the team needs to verify that the new schema is syntactically correct, adheres to naming conventions, and is compatible with existing data and applications. Which of the following is the MOST appropriate step to perform?Database Deployment
  14. 214.A database administrator is planning to deploy a new database server for a web application that will experience unpredictable and spiky traffic patterns. The application needs to scale quickly and automatically to handle sudden increases in load without manual intervention. Which cloud database deployment model would be most appropriate?Database Deployment
  15. 215.A database administrator is planning to deploy a new database system that will primarily store and analyze time-series data from IoT sensors. The data arrives at a very high ingestion rate, and queries will mostly involve aggregations over time ranges (e.g., 'average temperature over the last hour'). Which database type is best suited for this specific workload?Database Deployment
  16. 216.A database administrator is planning to deploy a new database server for an application that requires highly sensitive data to be encrypted at rest and in transit. Additionally, the application developers need to perform complex queries on encrypted columns without decrypting the entire database or transferring decryption keys to the application server. Which SQL Server feature addresses these requirements?Database Deployment
  17. 217.A database administrator is planning to deploy a critical reporting database that must be available 24/7 with minimal downtime. The solution needs to support read scaling while maintaining data consistency. The architecture should allow for rapid recovery in case of a primary database failure. Which deployment pattern best describes these requirements?Database Deployment
  18. 218.A database administrator is deploying a new PostgreSQL database server. As part of the post-installation configuration, the administrator needs to ensure that only specific client IP addresses can connect to the database. Which configuration file and parameter should be modified in PostgreSQL?Database Deployment
  19. 219.A database administrator is planning the storage requirements for a new data warehouse. The data warehouse will store 500 TB of raw data, and a 20% overhead is expected for indexes and temporary files. The company requires a 3x replication factor for disaster recovery and high availability. What is the minimum raw storage capacity (in TB) that should be provisioned?Database Deployment
  20. 220.A database administrator is planning to expand the storage capacity of an existing database server. The current storage is running out of space, and the database requires continuous operation without downtime during the expansion. Which storage expansion method is MOST suitable for this requirement?Database Deployment
  21. 221.A database administrator is evaluating different storage options for a new database that will primarily store time-series data from IoT sensors. The data is written continuously in large volumes, and queries often involve aggregating data over specific time ranges. Which storage approach would be most efficient for this type of workload?Database Deployment
  22. 222.A database development team has completed a new database schema for an upcoming application. Before deploying to production, the database administrator needs to verify that the new schema is correctly structured, all foreign key constraints are valid, and indexes are properly defined. Which of the following is the MOST effective method to perform this validation?Database Deployment
  23. 223.A database administrator is deploying a new MySQL server on a Linux host. After the initial installation, the administrator needs to secure the installation by removing anonymous users, disallowing remote root login, and removing the test database. Which command-line utility is specifically designed for these post-installation security tasks?Database Deployment
  24. 224.A database administrator is planning to expand the storage capacity of an existing database running on a Linux server. The database is critical and requires minimal downtime. The current storage is managed by Logical Volume Management (LVM), and there is unallocated space available on the underlying physical disks. Which method should the administrator use to expand the database storage with minimal downtime?Database Deployment
  25. 225.A database administrator is planning the deployment of a new database server for an application that will experience highly variable workloads, with peak demands occurring unpredictably. The administrator wants to ensure that the database can automatically scale its compute and storage resources up and down based on demand, without manual intervention. Which database deployment model would best meet these requirements?Database Deployment
  26. 226.A database administrator is planning to migrate an existing on-premises SQL Server database to Azure SQL Database. The database contains highly sensitive personal identifiable information (PII) that must remain encrypted throughout its lifecycle, including while in use by the application. Which SQL Server feature, when migrated, provides this 'always encrypted' capability in Azure SQL Database?Database Deployment
  27. 227.A database administrator is optimizing a large `Orders` table. They notice that queries frequently join `Orders` with `Customers` on `CustomerID` to retrieve customer details. To improve the performance of these join operations, which type of index would be most beneficial to create on the `CustomerID` column in the `Orders` table?Database Fundamentals
  28. 228.A database administrator is setting up a new production database server. To ensure optimal performance and prevent I/O bottlenecks, they decide to store the database data files, transaction log files, and temporary files on separate physical disks. Which of the following database management practices are they primarily applying?Database Management and Maintenance
  29. 229.A database administrator is investigating a report of intermittent query slowdowns on a critical production database. They suspect that the database optimizer might be using outdated information for query plan generation, leading to inefficient execution paths. Which database maintenance task should the administrator prioritize to address this issue?Database Management and Maintenance
  30. 230.A database administrator is evaluating different disaster recovery strategies for a critical online transaction processing (OLTP) database. The business requires a Recovery Time Objective (RTO) of 4 hours and a Recovery Point Objective (RPO) of 1 hour. The solution must minimize operational overhead during normal operations. Which of the following disaster recovery strategies best meets these requirements?Business Continuity
  31. 231.A database administrator is configuring a high availability solution for a critical OLTP database. The business requires that in the event of a primary server failure, the database system automatically switches to a standby server with minimal downtime and no manual intervention. Which of the following high availability solutions best meets these requirements?Business Continuity