Go to C1000-085 Questions - Try C1000-085 dumps pdf
Dumps Practice Exam Questions Study Guide for the C1000-085 Exam
NEW QUESTION 15
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 16
Which two command line support tools are used to determine the order of data for a given table?
- A. nz_physical_table_layout
- B. nz_sort_order
- C. nz_pagemap
- D. nz_zonemap
- E. nz_get
Answer: C,D
NEW QUESTION 17
Which two file formats are valid for external tables?
- A. XML
- B. HL7
- C. text-delimited
- D. JSON
- E. fixed-length
Answer: C,D
NEW QUESTION 18
What is required in order to restore a specific table using the nz_restore support tool?
- A. A table needs to be backed up by using nzbackup utility.
- B. The userspace must be provided
- C. A table that is being restored must have the same name in the backup set.
- D. The table structure (DDL) needs to exist
Answer: A
NEW QUESTION 19
Which statement regarding the IBM Netezza Performance Server (NPS) admin database user is true?
- A. The admin user is the only owner of a database on NPS.
- B. The admin user can not be deleted after installing NPS.
- C. The admin user is added to the host OS before installing NPS.
- D. The admin user should be deleted after installing NPS.
Answer: D
NEW QUESTION 20
To how many resource groups can a user be assigned?
- A. three
- B. unlimited
- C. one
- D. four
Answer: A
NEW QUESTION 21
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 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
How does IBM Netezza Performance Server store data?
- A. Tables are distributed across a subset of data slices uncompressed.
- B. Tables are distributed across all data slices uncompressed.
- C. Tables are distributed across all data slices compressed
- D. Tables are distributed to a single data slice compressed.
Answer: C
NEW QUESTION 24
What access is required to create a new user in IBM Netezza Performance Server?
- A. An account with CREATE ID access on the host OS.
- B. An account with NEW USER administrative privilege
- C. An account with CREATE USER administrative privilege.
- D. An account with CREATE GROUP access on the host OS.
Answer: B
NEW QUESTION 25
Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?
- A. _v_system_util
- B. _v_sched_gra
- C. _v_qryhist
- D. _v_plan_resource
Answer: D
NEW QUESTION 26
Which log file provides a DBA with an actual SQL statement that was executed?
- A. clientmgr.log
- B. pg.log
- C. dbos.log
- D. sysmgr.log
Answer: D
NEW QUESTION 27
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 28
What is the purpose of the nzstate command?
- A. list the state of the system
- B. list the states of backups available
- C. list the state of a running query
- D. restore the database to the last backup
Answer: D
NEW QUESTION 29
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 30
What ap cli command is used to disable a node?
- A. ap stopnode
- B. ap node power off
- C. ap node disable
- D. ap node set__personality fail
Answer: C
NEW QUESTION 31
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 32
When restoring a database using nzrestore utility, which is true for the npshost option?
- A. It is a host name of the target system to restore a database to.
- B. It is a HOSTNAME value set in backupHostname.txt file on the backup source system.
- C. It is the hostname of the storage server
- D. It is a remote host name or IP address of the system to connect to.
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
Which level of transaction isolation does IBM Netezza Performance Server implement?
- A. serializable
- B. uncommitted read
- C. repeatable read
- D. committed read
Answer: A
NEW QUESTION 35
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 36
What are two important factors to consider when selecting a distribution key?
- A. table constraints
- B. not Nullable constraint
- C. columns used for filters
- D. columns used for joins
- E. distinct values
Answer: B,C
NEW QUESTION 37
......
Free IBM Certified Administrator C1000-085 Exam Question: https://actual4test.practicetorrent.com/C1000-085-practice-exam-torrent.html