SQL Server Practice Test 7

1. Which of the following element is installed locally on each node of the FCI?

Storage

WSFC Resource Group

Network Name

SQL Server Binaries

2. Grant ________ permission on the stored procedures to database roles for implementing call level security.

READ

EXECUTE

WRITE

EXEC

3. The high performance mode is only available in the __________ edition of SQL Server.

Express

Compact

Enterprise

None of the mentioned

4. Which of the following code is used to enable the sa login?

ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;
GO

None of the mentioned

ALTER LOGIN sa DISABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;
GO

ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN san WITH PASSWORD = '<enterStrongPasswordHere>' ;
GO

5. Which of the following database level event si raised whenever a REFERENCES permission is checked.

UPDATE

EXECUTE

REFERENCES

SELECT

6. Which of the following is a Windows Failover Cluster quorum mode?

Node Majority

None of the mentioned

No Majority: Read Only

File Read Majority

7. Point out the correct statement.

The CREATE SERVER AUDIT statement is in a transaction scope

None of the mentioned

To insert a server audit, principles require the ALTER ANY SERVER AUDIT or the CONTROL SERVER permission

An audit must exist before deleting a server audit specification for it

8. Selecting the _________ option can allow unaudited activity which could violate your security policies.

Break

Continue

Shut down

Fail

9. The Activity Monitor in SQL Server Management Studio graphically displays information about ______________

Blocked processes

User activity

Locks

All of the mentioned

10. Which of the following pair of technology is supported in SQL Server?

Mirroring and Log Shipping

Mirroring and Clustering

Mirroring and Replication

All of the mentioned