[2022] Free C1000-085 Exam Dumps to Pass Exam Easily
C1000-085 Exam Dumps, C1000-085 Practice Test Questions
NEW QUESTION 13
Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?
- A. It reclaims space from deleted rows and re-orders data.
- B. Enough space is required for GROOM to make a complete copy of the table
- C. It reclaims space from deleted rows and does not re-order data
- D. GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.
Answer: C
NEW QUESTION 14
Which two products or methods can be used for disaster recovery when using IBM Netezza Performance Servers?
- A. Data Serialization
- B. Netezza Replication Services
- C. InfoSphere Data Replication
- D. NPS Backup and Restore
- E. Cloud Pak for Data
Answer: C,D
NEW QUESTION 15
Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?
- A. nzsqa
- B. nzbackup
- C. nzsql
- D. nz tables
- E. nz_stats
- F. nz_ddl
Answer: A,B,D
NEW QUESTION 16
What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?
- A. nzsqa wlm
- B. nzsqa progress
- C. nzsqa responders
- D. nzsqa schedqueues -sys
Answer: C
NEW QUESTION 17
How can a user update statistics on a table?
- A. by running a query against the table
- B. by restarting the database
- C. by running UPDATE STATISTICS
- D. by running GENERATE STATISTICS
Answer: C
NEW QUESTION 18
What is the order of the operations of a typical snippet in a query plan?
Answer:
Explanation:
NEW QUESTION 19
What are two valid column constraints?
- A. DEFAULT
- B. INITIALLY IMMEDIATE
- C. NULL
- D. INITIALLY DEFERRED
- E. DEFERRABLE
Answer: C,D
NEW QUESTION 20
Which state does the nzstate command show when the IBM Netezza Performance Server system fails to initialize?
- A. stopped
- B. paused
- C. discovering
- D. down
Answer: B
NEW QUESTION 21
What is the duration of SQB by default?
- A. 3 seconds
- B. 6 seconds
- C. 10 seconds
- D. 2 seconds
Answer: D
NEW QUESTION 22
Which two commands will show a query plan without running the query?
- A. EXPLAIN querytext
- B. nzsql -t querytext -0 planfile.pln
- C. nz_plan querytext
- D. EXPLAIN PLAN FILE querytext
- E. EXPLAIN PLANGRAPH querytext
Answer: A,C
NEW QUESTION 23
What is a purpose of the command nzsystem?
- A. to show and change system users
- B. to show and change the system state
- C. to show and change nzroot use
- D. to show and change system access
Answer: B
Explanation:
Explanation
https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.adm.doc/r_sysadm_nzsystem_cmd.
NEW QUESTION 24
Which two external methods can IBM Netezza Performance Server use to authenticate database users?
- A. PKI-Based
- B. Radius
- C. LDAP
- D. Kerberos
- E. SSH
Answer: A,C
NEW QUESTION 25
Which is a valid statement regarding event rules on the IBM Netezza Performance Server (NPS) Console?
- A. New event rules must be added using the npsaddevent command.
- B. New event rules can be added using the queries panel in NPS Console.
- C. New event rules can only be added in the host container.
- D. New event rules can be added using the event rules panel in NPS Console.
Answer: A
NEW QUESTION 26
What are Clustered Base Tables (CBT)?
- A. Tables that contain sorted data using one to four columns.
- B. Tables that replicate the base table.
- C. Tables that increase pre-sorting of new table records before a loading operation.
- D. Tables that decrease allocated storage
Answer: A
NEW QUESTION 27
Which two commands can be used to get a plan file for a query?
- A. nz_plan <planid>
- B. nzsql -c "show planfile <planid>"
- C. nzsql -c "get planfile <planid>"
- D. nz_get <planid>
- E. nzsql -c "select plan_text from _v_plan"
Answer: B,D
NEW QUESTION 28
Which partition on the SPU node us used to store transient working data that is generated during query execution?
- A. Mirror
- B. Nzscratch
- C. nzlocal
- D. Primary
Answer: D
NEW QUESTION 29
The nzhostbackup command backs up which directory by default?
- A. /nzscratch/
- B. /nz/kit/
- C. /ex port/ho me/nz
- D. /nz/data/
Answer: B
NEW QUESTION 30
Which two commands are used to list all hardware and software components on Cloud Pak for Data System?
- A. ap sw
- B. nzsw
- C. ap hw
- D. oc pod -h -s
- E. nzhv
Answer: A,C
NEW QUESTION 31
By default, when are the postgres logs rotated on an IBM Netezza Performance Server?
- A. daily or greater than 1 GB
- B. weekly or greater than 5 GB
- C. hourly or greater than 100 MB
- D. monthly or greater than 10 GB
Answer: C
NEW QUESTION 32
To how many resource groups can a user be assigned?
- A. three
- B. unlimited
- C. one
- D. four
Answer: A
NEW QUESTION 33
Which statement regarding drive failure is true?
- A. Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.
- B. Queries and transactions are not interrupted in the event of a drive failure.
- C. Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.
- D. Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.
Answer: D
NEW QUESTION 34
What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?
- A. stopped
- B. running
- C. online
- D. paused
Answer: A
NEW QUESTION 35
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. The PK constraint is only checked during a GENERATE STATISTICS operation.
- D. Before the row is inserted into the table.
Answer: D
NEW QUESTION 36
Which statement is correct about command nz_responders?
- A. displays user activity in tabular format
- B. displays information from nzsql responders -all in a more user-friendly format
- C. displays resource utilization statistics in JSON format
- D. displays information from nzsqa responders -sys in a more user-friendly format
Answer: B
NEW QUESTION 37
......
C1000-085 Exam Dumps, C1000-085 Practice Test Questions: https://examtorrent.actual4test.com/C1000-085_examcollection.html