IBM C1000-085 Practice Test Questions

1. C1000-085 Free Questions C1000-085 Free Questions IBM Netezza Performance Server V11.x IBM Netezza Performance Server V11.x Administrator Administrator https://www.passquestion.com/ https://www.passquestion.com/C1000-085 C1000-085.html .html

2. Question 1 Question 1 What access is required to create a new user in IBM Netezza Performance Server? What access is required to create a new user in IBM Netezza Performance Server? A. An account with NEW USER administrative privilege A. An account with NEW USER administrative privilege B. An account with CREATE USER administrative privilege. B. An account with CREATE USER administrative privilege. C. An account with CREATE GROUP access on the host OS. C. An account with CREATE GROUP access on the host OS. D. An account with CREATE ID access on the host OS. D. An account with CREATE ID access on the host OS. Answer: A Answer: A

3. Question 2 Question 2 How does IBM Netezza Performance Server store data? How does IBM Netezza Performance Server store data? A. Tables are distributed across all data slices compressed A. Tables are distributed across all data slices compressed B. Tables are distributed to a single data slice compressed. B. Tables are distributed to a single data slice compressed. C. Tables are distributed across all data slices uncompressed. C. Tables are distributed across all data slices uncompressed. D. Tables are distributed across a subset of data slices uncompressed. D. Tables are distributed across a subset of data slices uncompressed. Answer: A Answer: A

4. Question 3 Question 3 Which two command line support tools are used to determine the order of data for a given table? Which two command line support tools are used to determine the order of data for a given table? A. nz_physical_table_layout A. nz_physical_table_layout B. nz_zonemap B. nz_zonemap C. nz_pagemap C. nz_pagemap D. nz_sort_order D. nz_sort_order E. nz_get E. nz_get Answer: B,C Answer: B,C

5. Question 4 Question 4 What are Clustered Base Tables (CBT)? What are Clustered Base Tables (CBT)? A. Tables that decrease allocated storage A. Tables that decrease allocated storage B. Tables that contain sorted data using one to four columns. B. Tables that contain sorted data using one to four columns. C. Tables that increase pre-sorting of new table records before a loading operation. C. Tables that increase pre-sorting of new table records before a loading operation. D. Tables that replicate the base table. D. Tables that replicate the base table. Answer: B Answer: B

6. Question 5 Question 5 To enable or disable multiple schema support on the IBM Netezza Performance Server, which To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated? configuration file needs to be updated? A. system.cfg A. system.cfg B. pg_hba.conf B. pg_hba.conf C. postgresql.conf C. postgresql.conf D. startup.cfg D. startup.cfg Answer: C Answer: C

7. Question 6 Question 6 When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table? table? A. The PK constraint is never checked when a row is inserted 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. B. After the row is inserted into the table. C. Before 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. D. The PK constraint is only checked during a GENERATE STATISTICS operation. Answer: C Answer: C

8. Question 7 Question 7 When restoring a database using nzrestore utility, which is true for the npshost When restoring a database using nzrestore utility, which is true for the npshost option? option? A. It is the hostname of the storage server A. It is the hostname of the storage server B. It is a HOSTNAME value set in backupHostname.txt file on the backup B. It is a HOSTNAME value set in backupHostname.txt file on the backup source system. source system. C. It is a host name of the target system to restore a database to. 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. D. It is a remote host name or IP address of the system to connect to. Answer: C Answer: C

9. Question 8 Question 8 Which log file provides a DBA with an actual SQL statement that was executed? Which log file provides a DBA with an actual SQL statement that was executed? A. clientmgr.log A. clientmgr.log B. pg.log B. pg.log C. sysmgr.log C. sysmgr.log D. dbos.log D. dbos.log Answer: C Answer: C

10. Question 9 Question 9 Which statement is accurate regarding snippets? Which statement is accurate regarding snippets? A. The number of snippets depends on query and complexity. A. The number of snippets depends on query and complexity. B. Every query is always turned into four snippets. B. Every query is always turned into four snippets. C. Every query is always turned into one snippet. C. Every query is always turned into one snippet. D. The number of snippets is always based on the size of the system. D. The number of snippets is always based on the size of the system. Answer: C Answer: C

11. Question 10 Question 10 Which two commands can be used to get a plan file for a query? Which two commands can be used to get a plan file for a query? A. nzsql -c "show planfile <planid>" A. nzsql -c "show planfile <planid>" B. nzsql -c "select plan_text from _v_plan" B. nzsql -c "select plan_text from _v_plan" C. nzsql -c "get planfile <planid>" C. nzsql -c "get planfile <planid>" D. nz_get <planid> D. nz_get <planid> E. nz_plan <planid> E. nz_plan <planid> Answer: A,D Answer: A,D