File Info
| Exam | PureData System for Analytics v7.1 |
| Number | C2090-560 |
| File Name | IBM.C2090-560.Pass4Sure.2018-11-29.77q.vcex |
| Size | 394 KB |
| Posted | Nov 29, 2018 |
| Download | IBM.C2090-560.Pass4Sure.2018-11-29.77q.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
What is the maximum number of columns you can choose as organizing keys for a clustered base table?
- 1
- 2
- 4
- 8
Correct answer: C
Question 2
Which of the following is NOT true about the createxid column?
- They can be queried
- They are updated to zero during a DELETE operation
- Rows loaded in a transaction are assigned the same value
- They contain the ID of the transaction that created the record
Correct answer: D
Question 3
What is nzconvert used for?
- To convert compressed external tables into ASCII text
- To convert between character encodings before loading data
- To translate stored procedures into NZPLSOL compatible syntax
- To upgrade/downgrade the database to a different software version
Correct answer: B
Question 4
Dirty reads occur when a transaction reads data that is written by concurrentuncommitted transactions. Under what conditions are dirty reads allowed on the IBM PDA system?
- When an FPGA is busy
- By turning off serialization within the system
- They are never permitted under any conditions
- When the transaction isolation is read-committed
Correct answer: B
Question 5
What are two considerations for usage of materialized views? (Choose two.)
- Materialized views are not supported.
- Materialized views are logical entities.
- Materialized views may improve query performance.
- Materialized views are the same as database views.
- Materialized views are considered for usage by the Optimizer.
Correct answer: CE
Question 6
Netezza database accounts are NOT created and/or managed using
- The NzAdmin tool
- The Netezza Performance Portal
- The Netezza command line interface
- The Netezza host's command line interface
Correct answer: B
Question 7
What database object in the history database will you use to find the version number of the history database?
- _t_version
- _vt_version
- Histversion
- $hist_version
Correct answer: C
Question 8
What CANNOT be measured and managed by system views?
- Power supply status for each rack
- Temperature values on an S-blade
- Status of the host attached storage
- Resource group utilization and history
Correct answer: C
Question 9
Which of the following is NOT performed by the nzhw utility?
- It shows the current storage topology
- It shows the role of each component in the appliance
- It shows the location of each component in the appliance
- It shows the hardware ID of each component in the appliance
Correct answer: D
Question 10
Which statement about external tables is TRUE?
- Materialized views can be created for external tables
- External table data is deleted using the DELETE statement
- The GENERATE STATISTICS command can be run against external tables
- External tables can be used to unload data to a Microsoft Windows directory
Correct answer: B
