Exam Dumps VCE

QUESTION 47
A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?

QUESTION 48
Which of the following database structures is a type of NoSQL database?

QUESTION 49
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?

QUESTION 50
Which of the following is an advantage of creating indexes?

QUESTION 51
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?

QUESTION 52
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 issue?

QUESTION 53
A database administrator would like to create a table named XYZ. Which of the following queries should the database administrator use to create the table?

QUESTION 54
Which of the following can be used to protect physical database appliances from damage in a server room? (Choose two.)

QUESTION 55
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 56
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 this task?

QUESTION 57
A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company’s transactional dat a. Which of the following tasks should the administrator perform first?

QUESTION 58
Which of the following is recommended in order to provide encrypted data communication pathways for information as it is transmitted over a network?

QUESTION 59
Which of the following NoSQL database types best categorizes MongoDB?

QUESTION 60
Which of the following describes the purpose of a snapshot?

QUESTION 61
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.)

QUESTION 62
A database administrator wants to remove inactive customers from a database. Which of the following statements should the administrator use?

QUESTION 63
Which of the following would a database administrator monitor to gauge server health? (Choose two.)

QUESTION 64
Which of the following cloud storage options provides users with endpoints to retrieve data via REST API?

QUESTION 65
Which of the following sets the age requirement for data that should be recovered after a major disaster?

QUESTION 66
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?

QUESTION 67
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?

QUESTION 68
A database administrator is creating a table, which will contain customer data, for an online business. Which of the following SQL syntaxes should the administrator use to create an object?

QUESTION 69
Which of the following describes a scenario in which a database administrator would use a relational database rather than a non-relational database?