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

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?

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 IP addresses to allow access to the database?

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

A)

B)

C)

D)

Which of the following services is responsible for assigning, managing, and reclaiming IP addresses on a TCP/IP-based network?

Which of the following tools is used for natively running a Linux system in Windows?

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

Which of the following is a reason to create a stored procedure?

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?

A)

B)

C)

D)

Which of the following are the best resources for monitoring potential server issues? (Choose two.)

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 performfirst?

Which of the following have data manipulation and procedural scripting power? (Choose two.)

Which of the followingbestdescribes the category of SQL commands required to revoke access to database objects?

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 before giving the developers access to the environment?

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 the following is thebestway for the administrator to accomplish this task?

A DBA is reviewing the following logs to determine the current data backup plan for a primary data server:

Which of the followingbestdescribes this backup plan?

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 themostlikely cause of the issue?

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?

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?

A database administrator needs a tool to document and explain the relationships between data in an organization's database. Which of the following is thebesttool to accomplish this task?

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?

Which of the following constraints is used to enforce referential integrity?

Which of the following computer services associates IP network addresses with text-based names in order to facilitate identification and connectivity?