C1000-085 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

Question No : 1
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 copy of FACT_SALES table with zip_code as integer data type.
B.alter table fact_sales to organize on zip_code. followed by groom.
C.CREATE ORGANIZED view for FACT_SALES table
D.Create a view with a typecast to integer and use view for query purposes

正解:

Question No : 2
What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

A.online
B.running
C.stopped
D.paused

正解:

Question No : 3
Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?

A._v_sched_gra
B._v_system_util
C._v_qryhist
D._v_plan_resource

正解:

Question No : 4
What ap cli command is used to disable a node?

A.ap node power off
B.ap node set__personality fail
C.ap stopnode
D.ap node disable

正解:

Question No : 5
Which date time format is used to capture history activities?

A.system time
B.local time
C.EST
D.GMT

正解:

Question No : 6
What is the maximum length of a CHAR/VARCHAR column?

A.65.535
B.32.000
C.64,000
D.16.000

正解:

Question No : 7
When computing the row size for a table row, what overhead should be accounted for?

A.48 bytes for ROWID, CREATEXID and DELETEXID only
B.32 bytes for ROWI
C.CREATEXID, DELETEXID and the null vector
D.32 bytes for ROWI
E.CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns
F.24 bytes for ROWI
G.CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

正解:

Question No : 8
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.Sysmgr will remount it as part of the IBM Netezza Performance Server environment
C.A containers do not allow for NFS mounts.
D.It will be automatically mounted by the ipsnfs service.

正解:

Question No : 9
When integrating IBM Spectrum Protect into IBM Netezza Performance Server (NPS) for backup and restore, how must the NPS host be defined?

A.as a client of the storage manager server
B.as the primary storage manager server
C.as the primary backup target
D.as a cloud storage repository

正解:

Question No : 10
Which two commands can be used to get a plan file for a query?

A.nzsql -c "show planfile <planid>"
B.nzsql -c "select plan_text from _v_plan"
C.nzsql -c "get planfile <planid>"
D.nz_get <planid>
E.nz_plan <planid>

正解:

Question No : 11
Which statement is accurate regarding snippets?

A.The number of snippets depends on query and complexity.
B.Every query is always turned into four snippets.
C.Every query is always turned into one snippet.
D.The number of snippets is always based on the size of the system.

正解:

Question No : 12
Which log file provides a DBA with an actual SQL statement that was executed?

A.clientmgr.log
B.pg.log
C.sysmgr.log
D.dbos.log

正解:

Question No : 13
When restoring a database using nzrestore utility, which is true for the npshost option?

A.It is the hostname of the storage server
B.It is a HOSTNAME value set in backupHostname.txt file on the backup source system.
C.It is a host name of the target system to restore a database to.
D.It is a remote host name or IP address of the system to connect to.

正解:

Question No : 14
When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

A.The PK constraint is never checked when a row is inserted into the table.
B.After the row is inserted into the table.
C.Before the row is inserted into the table.
D.The PK constraint is only checked during a GENERATE STATISTICS operation.

正解:

Question No : 15
To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?

A.system.cfg
B.pg_hba.conf
C.postgresql.conf
D.startup.cfg

正解:

IBM C1000-085 問題練習