A database administrator configured a connection to a SQL Server instance for a new user, but cannot connect from the user's workstation. Which of the following is the most likely cause of the issue?
A database administrator is migrating data from a legacy table to a newer table. Both tables have the same columns, and some data may overlap.
Which SQL command should the administrator use to ensure that records from the two tables are not duplicated?
Community Discussion
A company must prepare a document that defines the responsibilities, metrics, penalties, and other general terms a provider must meet so customers can use its platforms.
Which of the following documents satisfies these requirements?
Community Discussion
A database is set up to use undo management with temporary undo enabled. An UPDATE is executed on the table.
Which option describes where the undo is stored?
Community Discussion
Which of the following deployment phases is when a DBA ensures that the latest patches are applied to the new database?


Community Discussion