510-702 試験問題を無料オンラインアクセス

The ability of the Sybase IQ server to create an FP(3) index on a column with 10 million distinct values is controlled by the database options FP_LOOKUP_SIZE and FP_LOOKUP_SIZE_PPM. The default values of these database options directly related to the ?FP_LOOKUP_SIZE and FP_LOOKUP_SIZE_PPM. The default values of these database options directly related to the

• A.size of the IQ Main Store Cache.
• B.size of the Catalog Store Cache.
• C.amount of free space in the IQ Main Store.
• D.size of the IQ Temporary Store Cache.

What happens to the loading process when character data is inserted into an integer column when the database option CONVERSION_ERROR is set to N?to ?N?

• A.NULL is inserted into the column in the row
• B.Conversion error messages are sent to the IQ Message File
• C.Load will stop and cause a rollback
• D.Data conversion error will be ignored

All of the following statements are TRUE regarding client-side bulk data loading EXCEPT:

• A.The character set of the file on the client must match the server collation.
• B.Client-side bulk data loading does not incur any extra disk space overhead on the server.
• C.Sybase IQ will process files in the file list of the LOAD TABLESING CLIENT FILE command inparallel.Sybase IQ will process files in the file list of the LOAD TABLE?SING CLIENT FILE command in parallel.
• D.Client-side bulk loading allows data to be loaded from files located on the client.

The server parameter qnumbercpus is used ?Choose 2)The server parameter ?qnumbercpus is used ?Choose 2)

• A.on servers wherehyperthreading is enabled to override the number of physical cores detected by the Sybase IQ server.
• B.to limit the number of cores Sybase IQ will use on a host.
• C.to specify the number of cores available for resource planning purposes by the Sybase IQ optimizer.
• D.to limit the number ofcpus available to the Sybase IQ server in order to comply with Sybase licensing.

On which node should the ALTER MULTIPLEX SERVER command be performed?

• A.The node being altered
• B.The Coordinator node
• C.Any writer node
• D.Any secondary node
• E.Any reader node