File Info
| Exam | PureData System for Analytics v7.1 |
| Number | C2090-560 |
| File Name | IBM.C2090-560.PrepAway.2018-08-07.74q.vcex |
| Size | 570 KB |
| Posted | Aug 07, 2018 |
| Download | IBM.C2090-560.PrepAway.2018-08-07.74q.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 mechanism does NPS use for LDAP authentication?
- Pluggable Authentication Module (PAM)
- Generic Security Services API (GSSAPI)
- Simple Authentication and Security Layer (SASL)
- Berkeley Software Distribution Authentication (BSDAuth)
Correct answer: A
Question 2
The Pure Data System for Analytics implements which level of transaction isolation?
- Serializable
- Committed read
- Repeatable read
- Uncommitted read
Correct answer: A
Explanation:
Question 3
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 4
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 5
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 6
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 7
What can be backed up using the nzbackup utility?
- Host data
- pg.log files
- Temporary tables
- User permissions
Correct answer: A
Question 8
Which of the following will NOT show the current sessions on the Netezza server?
- nzsql\act
- nzsession
- nzsystem-showSessions
- SELECT* FROM_v_session
Correct answer: D
Question 9
Which of the following statements about temporary tables is TRUE?
- Synonyms can be created for temporary tables
- Temporary tables have been deprecated as of NPS 7.0.3
- Temporary tables can be specified as a base table for materialized views
- When a user executes the command "SET SESSION READ ONLY", they are still able to create and write to temporary tables
Correct answer: C
Question 10
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
