File Info
| Exam | PureData System for Analytics v7.1 |
| Number | C2090-560 |
| File Name | IBM.C2090-560.PracticeTest.2017-12-03.134q.vcex |
| Size | 521 KB |
| Posted | Dec 03, 2017 |
| Download | IBM.C2090-560.PracticeTest.2017-12-03.134q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which statement regarding temporary tables is TRUE?
- They are limited to 1 terabyte in size
- They may include a DISTRIBUTE ON clause
- They are limited to 16 tables per user per database
- They will be included in any nzbackup of the database
Correct answer: B
Question 2
Which procedural logic is NOT supported by NZPLSQL?
- Scrollable cursors
- Looping (while, for)
- Conditionals (if, else)
- Returning a scalar result or result set
Correct answer: A
Question 3
Which of the following properties about the rowid column is FALSE?
- At installation the initial rowid value is 100,000
- Rowid values are sequential across each table
- The system automatically assigns values for the column
- The host assigns a range of sequential rowids to each SPU
Correct answer: C
Question 4
Columns in a table may be zone mapped. How are those columns chosen?
- They are automatically selected by the system
- They are always based on the samecolumns as the table's distribution key
- They are added via the ALTER TABLE ADD INDEX(column_name) statement
- They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement
Correct answer: A
Question 5
Select the statement about the ENABLE_USER_SCHEMA variable that is TRUE in a system using Netezza Performance Server Release 7.0.3 or higher.
- The default value for this variable is FALSE
- This variable controls whether the system allows users to create and manage multiple schemas
- If the variable is set to TRUE and the user does not specify a schema, the system will connect to the default schema for the database
- If the variable is set to FALSE and the user does not specify a schema, the system will connect to a schema that matches the database user name
Correct answer: B
Question 6
When using a CREATE TABLE statement, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)
- NULL
- UNIQUE
- NOT NULL
- RIMARY KEY
- DEFAULT value
Correct answer: BD
Question 7
What is the host Linux file that must be modified to permanently adjust optimizer settings such as enabling schema support?
- /nz/data/postgresql.conf
- /nz/data/config/system.cfg
- /nz/kit/sys/initTopology.cfg
- /nz/kit/log/sysmgr/sysmgr.log
Correct answer: A
Question 8
What columns contain row count information in the system tables? (Choose two.)
- STAHIVAL
- RELREFS
- STALOVAL
- RELTUPLES
- ATTDISPERSION
Correct answer: BE
Question 9
Which statement or operation will cause IBM Netezza Replication Services to use the "By- VALUE" replication gmethod?
- Insert data from a non-replicated database
- LIMIT ALL
- RANDOMO
- A & C
- B & C
Correct answer: C
Question 10
The CUSTOMER table is distributed on "c_custkey".
The ORDERS table is distributed on "o_custkey".
Please refer to the SQL Query below:
Which of the following statements is TRUE?
- The query plan will show a double redistribute for both tables CUSTOMER and ORDERS followed by a HashJoinNode to compare all rows
- The query plan will show a broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using a HashJoinNode
- The query plan will show a broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using an ExprJoinNode
- The query plan will show a redistribute for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using an ExprJoinNode
Correct answer: D
