EMT Practice Test

1. Question Content...

---

Question1: Which level of transaction isolation does IBM Netezza Performance Server implement?

Question2: Which two external methods can IBM Netezza Performance Server use to authenticate database users?

Question3: Which date time format is used to capture history activities?

Question4: The nzhostbackup command backs up which directory by default?

Question5: By default, when are the postgres logs rotated on an IBM Netezza Performance Server?

Question6: What is a purpose of the command nzsystem?

Question7: What is the maximum length of a CHAR/VARCHAR column?

Question8: Which two command line support tools are used to determine the order of data for a given table?

Question9: Which partition on the SPU node us used to store transient working data that is generated during query execution?

Question10: What are two important factors to consider when selecting a distribution key?

Question11: What two files are extracted from the SQL Extension toolkit package?

Question12: What are Clustered Base Tables (CBT)?

Question13: When computing the row size for a table row, what overhead should be accounted for?

Question14: Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char(5| They frequently restrict on this column, but the query is very inefficient.
What is the correct way to optimize this query without modifying the column?

Question15: What is a valid selection from the home page of the IBM Netezza Performance Server web console?

Question16: To how many resource groups can a user be assigned?

Question17: When integrating IBM Spectrum Protect into IBM Netezza Performance Server (NPS) for backup and restore, how must the NPS host be defined?

Question18: To how many resource groups can a user be assigned?

Question19: Which command is used to register a user defined table function in the database?

Question20: How can a user update statistics on a table?

Question21: What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?