C2090-560

C2090-560 practice questions, page 5 of 6, with answer review and explanations.

Question 21

Netezza database accounts are NOT created and/or managed using

  1. The NzAdmin tool
  2. The Netezza Performance Portal
  3. The Netezza command line interface
  4. The Netezza host's command line interface

Question 22

What database object in the history database will you use to find the version number of the history database?

  1. _t_version
  2. _vt_version
  3. Histversion
  4. $hist_version

Question 23

What CANNOT be measured and managed by system views?

  1. Power supply status for each rack
  2. Temperature values on an S-blade
  3. Status of the host attached storage
  4. Resource group utilization and history

Question 24

Which of the following is NOT performed by the nzhw utility?

  1. It shows the current storage topology
  2. It shows the role of each component in the appliance
  3. It shows the location of each component in the appliance
  4. It shows the hardware ID of each component in the appliance

Question 25

Which statement about external tables is TRUE?

  1. Materialized views can be created for external tables
  2. External table data is deleted using the DELETE statement
  3. The GENERATE STATISTICS command can be run against external tables
  4. External tables can be used to unload data to a Microsoft Windows directory