Which of the following are TRUE regarding creating, modifying or dropping buffer pools? (Choose two.)
A. The minimum pool size is determined by a configuration parameter
B. As long as 1 pool remains in the cache, any pool can be removed
C. New pools are created using memory from the largest pool unless otherwise specified
D. The sum of all the buffers in the pool must be less than or equal to the total memory size of cache
E. The maximum I/O size for any cache is 8 pages
正解:D,E
質問 2:
Which database is most suitable for setting the "dsync" value to FALSE on its file system device?
A. model
B. tempdb
C. sybsystemprocs
D. sybsystemdb
E. master
正解:B
質問 3:
Which of the following can be used to identify frequently executed queries?
A. sp_sysmon
B. Monitor Server
C. Query Processing Metrics
D. Monitor and Data Analysis Tables
正解:C
質問 4:
Which of the following are TRUE about lock promotion? (Choose three.)
A. If other tasks hold locks conflicting with the type of table lock needed, lock escalation occurs.
B. Page locks can be promoted to intent locks.
C. Page locks can be promoted to table locks.
D. Row locks can be promoted to table locks.
E. If other tasks hold locks conflicting with the type of table lock needed, lock escalation does not occur.
F. Row locks can be promoted to page locks.
正解:C,D,E
質問 5:
Which of the following commands allow you to specify the partition? (Choose three.)
A. update statistics
B. insert
C. truncate table
D. reorg rebuild tablename
E. bcp in
正解:A,C,E
質問 6:
Which of the following are TRUE regarding partitions? (Choose two.)
A. Tables may be partitioned logically as well as physically
B. Global indexes may be created on each partition.
C. Data in each partition may be processed differently.
D. Each partition must reside on its own segment.
E. Global indexes can be clustered or nonclustered on range, hash, or list partitioned tables.
正解:A,C
Taniguchi -
5日前に急ぎでC_SASEAA_15を購入したんだけど、問題集にある内容だけ全部覚えて受験して、そのまま合格になったんだよ。試験の内容にほぼあってて凄すぎた。