DS0-001 Practice Exam — 144 Free CompTIA Questions
Ask AstroTutor
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 following is the most likely cause of the issue?
AThe SQL Server codes are performing badly.
BThe SQL Server has not been tested properly.
CThe SQL Server ports to the main machine are closed.
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 following SQL commands should the administrator use to ensure that records from the two tables are not duplicated?
AUNION
BJOIN
CINTERSECT
DCROSS JOIN
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 its platforms.
Which of the following documents meets these requirements?
ADOU
BSLA
CMOU
DSOW
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?
AIn the system global area
BIn the undo tablespace
CIn the SYSAUX tablespace
DIn the temporary tablespace
Which of the following is the deployment phase in which a DBA ensures the most recent patches are applied to the new database?
AImporting
BUpgrading
CProvisioning
DModifying
Question 6
Database Fundamentals
0
Question 7
Data and Database Security
Question 8
Database Deployment
Question 9
Database Fundamentals
Question 10
Business Continuity
Question 11
Data and Database Security
Question 12
Database Fundamentals
Question 13
Database Fundamentals
Question 14
Data and Database Security
Question 15
Database Fundamentals
Question 16
Data and Database Security
Question 17
Database Fundamentals
Question 18
Data and Database Security
Question 19
Database Fundamentals
Question 20
Data and Database Security
Question 21
Business Continuity
Question 22
Database Deployment
Question 23
Database Fundamentals
Question 24
Database Management and Maintenance
Question 25
Database Deployment
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ad
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Which of the following types of RAID, if configured with the same number and type of disks, would provide the best write performance?
ARAID 3
BRAID 5
CRAID 6
DRAID 10
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?
ACreate a new service account exclusively for the business intelligence application.
BBuild a separate data warehouse customized to the business intelligence application's specifications.
CSet up a nightly FTP data transfer from the database server to the business intelligence application server.
DSend the business intelligence administrator the approved TNS names file to configure the data mapping.
EOpen a new port on the database server exclusively for the business intelligence application.
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.)
AThe access permissions for the service account used by the reporting application were not changed.
BThe new database server has its own reporting system, so the old one is not needed.
CThe reporting jobs that could not process during the database migration have locked the application.
DThe reporting application’s mapping to the database location was not updated.
EThe database server is not permitted to fulfill requests from a reporting application.
FThe reporting application cannot keep up with the new, faster response from the database.
Given 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?
A
B
C
D
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?
AMonthly full, daily differential
BDaily differential
CDaily full
DWeekly full, daily incremental
Which of the following is part of logical database infrastructure security?
ASurveillance
BBiometric access
CPerimeter network
DCooling system
A database administrator would like to extract a sales performance report from more than one database instance. Which of the following keywords should the database administrator use?
AUNION ON
BUNION AND
CJOIN ON
DWITH
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 appropriate for the analyst to use to create this database view?
AINNER JOIN ON Client.Key = Invoice.Key
BRIGHT JOIN ON Client.Key = Invoice.Key WHERE BY Client.Key IS NULL
CLEFT JOIN ON Client.Key = Invoice.Key
DLEFT JOIN ON Client.Key = Invoice.Key WHERE BY Invoice.Key IS NULL
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?
ACircuit-level
BStateful
CProxy
DPacket
Which of the following statements contains an error?
ASelect EmpId from employee where EmpId=90030
BSelect EmpId where EmpId=90030 and DeptId=34
CSelect* from employee where EmpId=90030
DSelect EmpId from employee
An automated script is using common passwords to gain access to a remote system. Which of the following attacks is being performed?
ADoS
BBrute-force
CSQL injection
DPhishing
Which of the following computer services associates IP network addresses with text-based names in order to facilitate identification and connectivity?
ALDAP
BNTP
CDHCP
DDNS
Which of the following is recommended in order to provide encrypted data communication pathways for information as it is transmitted over a network?
ATCP/IP
BNFS
CSMB
DTLS
Which of the following services is responsible for assigning, managing, and reclaiming IP addresses on a TCP/IP-based network?
ADNS
BDHCP
CLDAP
DSMTP
Which of the following is an attack in which an attacker hopes to profit from locking the database software?
ASpear phishing
BRansomware
CSQL injection
DOn-path
Which of the following sets the age requirement for data that should be recovered after a major disaster?
AMTBF
BRTO
CMTTF
DRPO
Which of the following tools is used for natively running a Linux system in Windows?
AWSL
BRemote Desktop Protocol
CSSH
DTelnet
Which of the following indexes stores records in a tabular format?
AColumnstore
BNon-clustered
CUnique
DSecondary
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?
ACapture business logic, check the performance of codes, and report findings.
BCheck the clustered and non-clustered indexes, and report findings.
CReview application tables and columns, and report findings.
DWrite queries directly into the database and report findings.
Which of the following is the correct order of the steps in the database deployment process?