Online Access Free C-SASEAA-15 Exam Questions

Which of the following statements are NOT true about database dumps? (Choose two.)

• A.backs up the transaction log
• B.performs a checkpoint
• C.may dump unallocated pages
• D.truncates the transaction log
• E.cannot be run while anyone is in the database

Which of the following can be used to identify frequently executed queries?

• A.sp_sysmon
• B.Query Processing Metrics
• C.Monitor Server
• D.Monitor and Data Analysis Tables

What happens when a row is inserted into a list partitioned table but the key value is not within the list?

• A.The row is inserted into the last partition.
• B.The row is inserted into the first partition.
• C.The insert fails with an error message.
• D.The insert is discarded without an error message.

Which of the following is TRUE regarding the execution of dbcc checkstorage?

• A.Named cache must be configured
• B.Number of worker processes must be configured greater than 2
• C.Large buffer pool must be configured
• D.Workspace segments must be configured

Permissions on a table can be granted by all of the following EXCEPT: (Choose two.)

• A.logins with sso_role
• B.database owner
• C.table owner
• D.logins with oper_role
• E.logins with sa_role