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 is a reason to create a stored procedure?

• A.To minimize storage space
• B.To improve performance
• C.To bypass case sensitivity requirements
• D.To give control of the query logic to the user

Comment: *

Name: *

Email: *

Verification: *

Which of the following is an attack in which an attacker hopes to profit from locking the database software?

• A.Spear phishing
• B.Ransomware
• C.SQL injection
• D.On-path

Comment: *

Name: *

Email: *

Verification: *

An on-premises application server connects to a database in the cloud. Which of the following must be considered to ensure data integrity during transmission?

• A.Bandwidth
• B.Encryption
• C.Redundancy
• D.Masking

Comment: *

Name: *

Email: *

Verification: *

Which of the following is a potential issue raised by enterprise database users?

• A.The need for multiple views or windows into the same database
• B.The need to manage long transactions
• C.The need for concurrent access and multiuser updates
• D.The need to manually transfer records to paper

Comment: *

Name: *

Email: *

Verification: *