Online Access Free C-SASEAA-15 Practice Test

Which of the following is TRUE regarding semantic partitioning? (Choose three.)

• A.Rows are assigned to different partitions based on a logical test
• B.Configuration parameter is on by default
• C.Partitions can be dropped
• D.Requires sa_role to enable
• E.Partitioned tables can be created
• F.Computed columns are allowed in the key of range partitions

Which of the following can NOT be done by a dbo? (Choose two.)

• A.create a database
• B.grant permission to grant permission
• C.transfer object ownership
• D.use database objects
• E.create database objects

Which of the following tables do NOT store metadata in the metadata cache? (Choose two.)

• A.syspartitions
• B.syslogs
• C.syscolumns
• D.sysindexes
• E.sysdatabases

Which of the following privileges are associated with the Systems Security Officer role?

• A.The ability to perform a disk init or disk resize command
• B.The ability to shut down the server
• C.The ability to create user-defined roles
• D.The ability to back up any database

What is the system stored procedure used to display metadata cache usage statistics?

• A.sp_configure
• B.sp_monitorconfig
• C.sp_helpconfig
• D.sp_cacheconfig