DS0-001 Practice Questions
149 real DS0-001 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1Database Deployment
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 exp...
Database MigrationApplication ConnectivityDatabase SecurityDatabase Configuration - Question #3Database Management and Maintenance
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?
Database Backup TypesBackup PlansDatabase AdministrationData Protection - Question #4Data and Database Security
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 task...
Database securityAccess controlService accountsApplication integration - Question #6Database Management and Maintenance
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 expla...
Stress TestingDatabase PerformanceApplication Performance MonitoringDatabase Administration - Question #9Database Deployment
Which of the following is the correct order of the steps in the database deployment process?
Database deploymentDeployment processPrerequisite checking - Question #10Database Deployment
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 o...
Database ReplicationHigh AvailabilityWorkload DistributionData Synchronization - Question #11Database Management and Maintenance
A database administrator manages a database server that is running low on disk space. A lot of backup files are stored on the server's disks. Which of the following is the best act...
Backup managementRetention policyDisk space management - Question #12Database Fundamentals
A business analyst is using a client table and an invoice table to create a database view that shows clients who have not made purchases yet. Which of the following joins is most a...
SQL JoinsOuter JoinsData RetrievalNULL Values - Question #14Data and Database Security
A database administrator needs to provide access to data from two different tables to multiple group users in order to facilitate ongoing reporting. However, some columns in each t...
ViewsData Access ControlColumn RestrictionDatabase Security - Question #15Database Fundamentals
Which of the following describes a scenario in which a database administrator would use a relational database rather than a non-relational database?
Relational databasesNon-relational databasesData consistencyDatabase models - Question #16Database Deployment
A database administrator set up a connection for a SQL Server instance for a new user, but the administrator is unable to connect using the user's workstation. Which of the followi...
SQL Server ConnectivityNetwork ConfigurationTroubleshooting - Question #17Data and Database Security
A group of developers needs access to a database in a development environment, but the database contains sensitive data. Which of the following should the database administrator do...
Data MaskingSensitive Data ProtectionDevelopment Environment SecurityAccess Control - Question #18Database Management and Maintenance
A database administrator needs to aggregate data from multiple tables in a way that does not impact the original tables, and then provide this information to a department. Which of...
Materialized viewsData aggregationDatabase objectsReporting - Question #19Database Fundamentals
A database administrator is migrating the information in a legacy table to a newer table. Both tables contain the same columns, and some of the data may overlap. Which of the follo...
SQL CommandsSet OperatorsData MigrationDuplicate Data Handling - Question #20Database Fundamentals
A company is launching a proof-of-concept, cloud-based application. One of the requirements is to select a database engine that will allow administrators to perform quick and simpl...
NoSQLUnstructured dataMongoDBDatabase types - Question #21Database Management and Maintenance
A database administrator needs to ensure database backups are occurring on a daily basis and at scheduled times. Which of the following actions should the administrator take?
Database BackupBackup MonitoringServer LogsDBA Tasks - Question #22Data and Database Security
Which of the following is a result of an on-path attack on a system?
On-path attackNetwork securityAttack types - Question #23Database Management and Maintenance
Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?
Data MigrationPerformance OptimizationConcurrency ControlBatch Processing - Question #24Data and Database Security
Following a security breach, a database administrator needs to ensure users cannot change data unless a request is approved by the management team. Which of the following principle...
Least PrivilegeAccess ControlDatabase SecurityUser Permissions - Question #25Data and Database Security
A programmer wants to configure a database to only allow read or write access when requests are coming from specific IP addresses. Which of the following can be used to configure I...
FirewallNetwork SecurityAccess ControlDatabase Security - Question #26Business Continuity
A company needs to prepare a document that establishes the responsibilities, metrics, penalties, and other generalities that a provider would have to fulfill for customers to use i...
Service Level AgreementSLAService ManagementBusiness Agreements - Question #27Data and Database Security
A DBA left the company, and the DBA's account was removed from the system. Soon after, scheduled jobs began failing. Which of the following would have most likely prevented this is...
Service accountsScheduled tasksAccount managementSecurity best practices - Question #28Database Management and Maintenance
A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table. Which of the following describes where the undo is stored?
Undo ManagementTemporary TablespacesDatabase StorageDML Operations - Question #29Data and Database Security
Which of the following concepts applies to situations that require court files to be scanned for permanent reference and original documents be stored for ten years before they can...
Data retention policiesRegulatory complianceInformation governance - Question #30Database Fundamentals
Which of the following is a potential issue raised by enterprise database users?
Concurrency ControlMultiuser DatabaseEnterprise DatabaseDatabase Challenges - Question #31Database Fundamentals
A database administrator is new to a company and wants to create a document that illustrates the interaction between tables. Which of the following should the administrator create?
Entity Relationship DiagramDatabase DesignTable RelationshipsDatabase Documentation - Question #32Data and Database Security
Which of the following can be used to protect physical database appliances from damage in a server room? (Choose two.)
Physical securityEnvironmental controlsFire suppressionCooling systems - Question #33Business Continuity
A database administrator needs to ensure continuous availability of a database in case the server fails. Which of the following should the administrator implement to ensure high av...
High AvailabilityReplicationContinuous AvailabilityFailover - Question #34Database Management and Maintenance
A database's daily backup failed. Previous backups were completed successfully. Which of the following should the database administrator examine first to troubleshoot the issue?
Backup failureTroubleshootingDatabase administrationEvent logs - Question #35Database Fundamentals
A database administrator is updating an organization's ERD. Which of the following is the best option for the database administrator to use?
ERDDatabase ModelingUML ToolsDatabase Design Tools - Question #36Database Fundamentals
A database administrator needs a tool to document and explain the relationships between data in an organization's database. Which of the following is the best tool to accomplish th...
Data modelingDatabase design toolsUML - Question #37Data and Database Security
A database administrator has been asked to assign a user the ability to view a data set. Which of the following practices best describes this request?
Access ControlPermissionsDatabase SecurityUser Management - Question #38Data and Database Security
Which of the following firewall types allows an administrator to control traffic and make decisions based on factors such as connection information and data flow communications?
Firewall typesNetwork securityStateful inspectionTraffic control - Question #39Data and Database Security
A new retail store employee needs to be able to authenticate to a database. Which of the following commands should a database administrator use for this task?
database user managementuser creationSQL DDLauthentication - Question #40Database Fundamentals
A developer is designing a table that does not have repeated values. Which of the following indexes should the developer use to prevent duplicate values from being inserted?
IndexesUnique IndexData IntegrityConstraints - Question #41Database Management and Maintenance
Which of the following would a database administrator monitor to gauge server health? (Choose two.)
Server MonitoringResource UtilizationDatabase AdministrationPerformance Metrics - Question #42Database Fundamentals
A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?
ACID propertiesDurabilityTransactionsSystem failure - Question #43Database Fundamentals
Which of the following is a reason to create a stored procedure?
Stored ProceduresDatabase PerformanceSQL Programming - Question #44
An on-premises application server connects to a database in the cloud. Which of the following must be considered to ensure data integrity during transmission?
- Question #45
Which of the following statements contains an error?
- Question #46
A database professional is considering denormalizing a database. Which of the following documents should be used to analyze the database's structure?
- Question #47
A company needs information about the performance of users in the sales department. Which of the following commands should a database administrator use for this task?
- Question #48
Which of the following are the best resources for monitoring potential server issues? (Choose two.)
- Question #49
An automated script is using common passwords to gain access to a remote system. Which of the following attacks is being performed?
- Question #50
Which of the following cloud delivery models provides users with the highest level of flexibility regarding resource provisioning and administration?
- Question #51
Which of the following should a company develop to ensure preparedness for a fire in a data center?
- Question #52
Which of the following is the deployment phase in which a DBA ensures the most recent patches are applied to the new database?
- Question #53
Which of the following computer services associates IP network addresses with text-based names in order to facilitate identification and connectivity?
- Question #54
Which of the following types of RAID, if configured with the same number and type of disks, would provide the best write performance?
- Question #55
Which of the following is recommended in order to provide encrypted data communication pathways for information as it is transmitted over a network?