(Which of the following best describes the function of a wildcard in the WHERE clause?)

• A.An exact match is not possible in a CREATE statement.
• B.An exact match is necessary in a SELECT statement.
• C.An exact match is not possible in a SELECT statement.
• D.An exact match is necessary in a CREATE statement.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.The SQL Server codes are performing badly.
• B.The SQL Server has not been tested properly.
• C.The SQL Server ports to the main machine are closed.
• D.The SQL Server has many concurrent users.

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands when executed will rebuild statistics against user-defined tables in a database?

• A.DBCC UPDATEUSAGE
• B.DBCC SHOW_STATISTICS
• C.sp_autostats
• D.sp_updatestats

Comment: *

Name: *

Email: *

Verification: *

As part of an integrity check, a database administrator is creating both the primary and secondary snapshots. The database administrator notices the primary replica is failing over to the secondary replica. Which of the following describes how this will affect the database?

• A.All the data will have to be copied to a new primary snapshot.
• B.The database will not be impacted.
• C.The database will shut down unexpectedly.
• D.All the information in the database will be lost.

Comment: *

Name: *

Email: *

Verification: *

Which of the following is the deployment phase in which a DBA ensures the most recent patches are applied to the new database?

• A.Importing
• B.Upgrading
• C.Provisioning
• D.Modifying

Comment: *

Name: *

Email: *

Verification: *