C1000-085問題集、IBM実際の試験問題

質問 1

Within a database session, which syntax allows a user to change to a different schema (NEW_SCHEMA)?

A. SET CURRENT SCHEMA TO NEW_SCHEMA

B. ALTER SESSION SET SCHEMA=NEW_SCHEMA

C. SET SCHEMA NEW_SCHEMA

D. ALTER DATABASE database name SET DEFAULT SCHEMA NEW SCHEMA

正解: C

質問 2

What command is used to add an event?

A. nzevent load

B. nzevent create

C. nzevent insert

D. nzevent add

正解: D

質問 3

What happens to NFS mounts after a container failover?

A. NFS is handled by Red Hat OpenShift and does not need to be mounted.

B. It will be automatically mounted by the ipsnfs service.

C. A containers do not allow for NFS mounts.

D. Sysmgr will remount it as part of the IBM Netezza Performance Server environment

正解: A

質問 4

Which command is used to register a user defined table function in the database?

A. ALTER FUNCTION

B. nzudxcompile

C. CREATE FUNCTION

D. ECHO

正解: C

質問 5

What is required in order to restore a specific table using the nz_restore support tool?

A. The userspace must be provided

B. The table structure (DDL) needs to exist

C. A table needs to be backed up by using nzbackup utility.

D. A table that is being restored must have the same name in the backup set.

正解: C

質問 6

What is the purpose of the nzstate command?

A. list the state of a running query

B. list the state of the system

C. list the states of backups available

D. restore the database to the last backup

正解: D

質問 7

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char(5| They frequently restrict on this column, but the query is very inefficient.
What is the correct way to optimize this query without modifying the column?

A. Create a view with a typecast to integer and use view for query purposes

B. alter table fact_sales to organize on zip_code. followed by groom.

C. Create a copy of FACT_SALES table with zip_code as integer data type.

D. CREATE ORGANIZED view for FACT_SALES table

正解: D

IBM Netezza Performance Server V11.x Administrator - C1000-085 模擬練習