Netezza Questions

8/17/2019 Netezza Questions

1/22

Questions 1. Which statement regarding temporary tables is TRUE?A. They are limited to 1 terabyte in sizeB. They may include a DISTRIBUTE ON clauseC. They are limited to 16 tables per user per databaseD. They will be included in any nzbackup of the databaseAnswer: BExplanation:

Questions 2. Which of the following properties about the rowid column is FALSE?A. At installation the initial rowid value is 100,000B. Rowid values are sequential across each tableC. The system automatically assigns values for the columnD. The host assigns a range of sequential rowids to each SPUAnswer: CExplanation:

Questions 3. Which of the following criteria can be limited for active plans? (Choose two.)A. User

B. RulesC. RuntimeD. Memory allocationE. Resource group priorityAnswer: A,DExplanation:

Questions 4. What is the maximum factor that page granular zone maps can improve performance over extent- based zone maps?A. 8 timesB. 16 timesC. 24 timesD. 48 times

Answer: CExplanation:

Questions 5. Why should Boolean data types be avoided when selecting a distribution key for a table?A. The table will not broadcastB. The table will be highly skewedC. The table is likely to be evenly spread across data slicesD. The table will not join to other tables unless both tables have a Boolean columnAnswer: BExplanation:

Questions 6. Which statement is true about queries on the Pure Data System for Analytics appliance?A. Queries are executed in parallel by the host.B. Queries must be compressed before they can be executed.C. Queries are compiled into snippets and executed in parallel by the S-Blades.D. Queries must be uncompressed by the user and executed in parallel by the host.E. A query is compiled into a snippet which is executed across all available S-Blades.Answer: C,EExplanation:

Questions 7. All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?A. GUEST


2/22

B. USERSC. PUBLICD. GLOBALAnswer: CExplanation:

Questions 8. Which command will backup users and groups on the system?

A. nzbackup -allB. nzhostbackupC. nzbackup-globalsD. nzbackup-systemAnswer: BExplanation:

Questions 9. Which statement is TRUE regarding any database user?A. The user has a tablespace definedB. The user can be assigned to more than one groupC. The user must have a corresponding host accountD. The user can be removed from the default PUBLIC group

Answer: BExplanation:

Questions 10. Why is it important to manage data skew?A. Low table skew negatively impacts performanceB. High table skew negatively impacts performanceC. Low table skew negatively impacts data compressionD. Deleted rows consume disk space until they are freedAnswer: BExplanation:Questions 11. When doing a CREATE SEQUENCE, which is always true about INCREMENT BY?A. The value may only be positive

B. The value may only be negativeC. Cross-database access is supportedD. The value may be either negative or positiveAnswer: CExplanation:

Questions 12. In order for an ODBC application running on Microsoft Windows to connect to Pure Data System for Analytics, which two steps must be performed? (Choose two.)A. Install nzsql for WindowsB. Install nzAdmin for WindowsC. Install an ODBC driver for WindowsD. Install an ODBC Driver Manager for WindowsE. Create or modify a Data Source Name (DSN) for a connection to a databaseAnswer: C,EExplanation:

Questions 13. Here's an excerpt from a successful query execution plan file:What does "DownloadTableNode distribute" indicate?

A. A broadcast is going to take place every time the query is executedB. A redistribution is going to take place every time the query is executedC. A broadcast is going to take place only the first time the query is executedD. A redistribution is going to take place only the first time the query is exec

utedAnswer: DExplanation:


3/22

Questions 14. What is a view?A. A virtual table stored in memory rather than on diskB. A pre-defined query executed in real time when the view is accessedC. A table of which only portions are visible to users based on user permissionsD. All of the aboveAnswer: B

Explanation:

Questions 15. A user is logged onto the PROD database. The user has access to other databases on the same appliance. Which types of objects from other databases can the user reference in queries?A. ViewsB. TablesC. SynonymsD. All of aboveAnswer: BExplanation:

Questions 16. Which log file should be reviewed to troubleshoot an intermittentSPU failure?A. pg.logB. dbos.logC. sysmgr.logD. eventmgr.logAnswer: CExplanation:

Questions 17. How are security labels represented?A. : : B. : : C. : :

D. : : Answer: AExplanation:

Questions 18. Which of the following statements is TRUE for an audit database in use?A. If the history data staging area exceeds its STORAGELIMIT value, the system continues to function normallyB. If the history data staging area exceeds its QUERYLIMIT value, the system stops, and the administrator must free up space and restart the system before users can resume activityC. If the history data staging area exceeds its STORAGELIMIT value, the system stops, and the administrator must free up space and restart the system before users can resume activityD. If the history data staging area exceeds its STORAGELIMIT value, the system stops, and the database security officer must free up space and restart the system before users can resume activityAnswer: CExplanation:

Questions 19. Which statement is TRUE regarding the NPS compression engine?A. Data automatically gets compressedB. Columns to be compressed must be definedC. The nzcompress utility must be run to compress the tableD. The nzcompress utility must be run to compress the database

Answer: AExplanation:


4/22

Questions 20. Short Query Bias is enabled by default. Which of the following isNOT an advantage of using Short Query Bias?A. It allows for all short queries to run in a guaranteed amount of timeB. The cost threshold is configurable with the hostschedSQBNominalSecs settingC. When the standard scheduler is full, short queries can take advantage of additional resources reserved for themD. It allows queries with a cost estimate less than or equal to the defined shor

t query length to run on a busy systemAnswer: DExplanation:Questions 21. Which statement is TRUE about a simple load using external tables? A. The load can be configured to automatically create a backup file of the table being loadedB. The load can be configured to automatically create a duplicate copy of the table being loadedC. The load can be configured to automatically remove duplicate rows from the table being loadedD. The load can be configured to automatically continue to load following an S-B

lade reset or failureAnswer: DExplanation:

Questions 22. NPS syncs up which two folder structures between the active and passive hosts? (Select two)A. /nz ElB. /logC. /hostD. /adminE. /export/homeAnswer: B,EExplanation:

Questions 23. What new feature simplifies the gathering of information for a problem management record (PMR) with IBM Support?A. Call IBMB. Call 911C. Call HomeD. File Open PMRAnswer: CExplanation:

Questions 24. Which of the following statements is TRUE when a table is created? A. 3MB of temporary space is allocated on each dataslice for the tableB. One page of storage space is allocated on each dataslice for the tableC. One extent of storage space is allocated on each dataslice for the tableD. No space is allocated by the system until a record is inserted into the tableAnswer: BExplanation:

Questions 25. Which of the following can the NZDUMPSCHEMA command be used for?A. Backup a databaseB. Dump the entire system catalogC. Output a shell script with SQL statementsD. Generate schema information, with its associated user dataAnswer: D

Explanation:

Questions 26. Dropping an external table does which of the following?


5/22

A. Deletes the data but not the table definitionB. Deletes the table definition but not the dataC. Deletes both the table definition and the dataD. Deletes neither the table definition nor the dataAnswer: AExplanation:

Questions 27. What will occur when two large tables are joined together and thedata is NOT co-located?A. A hash join is not performedB. No data movement is requiredC. Data is dynamically redistributed or broadcastedD. One of the tables must be manually redistributedAnswer: CExplanation:

Questions 28. Which of the following is FALSE?A. Outdated rows will cause queries to run slowerB. Outdated rows will cause disk space to be consumed by deleted data

C. Outdated rows consume space on a full backupD. Outdated rows will show up in the query's result setAnswer: BExplanation:

Questions 29. What are the two primary components of an S-Blade?A. CPUs and hostsB. FPGAs and hostsC. CPUs and FPGAsD. CPUs and the fabricAnswer: DExplanation:

Questions 30. In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items should be configured? (Choose two)A. The runaway query event must be enabledB. The pg.log file must be configured for two minutesC. The runaway query event must be configured for two minutesD. The nzsystem command must be used to set the QUERYTIMEOUT to two minutesE. The CREATE or ALTER USER command must be used to set the QUERYTIMEOUT to twominutesAnswer: A,CExplanation:

Questions 31. Which event type can be used to monitor queries that exceed configured query timeout limits?A. RunAwayQueryB. SystemStucklnStateC. InfiniteOueryDetectedD. Transaction LimitEventAnswer: CExplanation:

Questions 32. What is the function of the Distributed Replicated Block Device (DRBD)?A. DRBD allows both hosts to work on certain large processing loads concurrentlyB. DRBD allows the stand-by host to act as an "eighth SPU" to assist with processing queries

C. If the active host fails over to the stand-by host, DRBD allows specific files to immediately become available to the new active hostD. DRBD allows the stand-by host to perform various system functions, such as ba


6/22

ckups and logging, so the primary host is free to process queriesAnswer: BExplanation:

Questions 33. Which groups are used by default by Guaranteed Resource Allocation?A. Query

B. SystemC. PublicD. AdministratorsE. All the aboveAnswer: EExplanation:

Questions 34. Which statement about the Netezza System Health Check tool is TRUE?A. The tool stores captured data in the system catalogB. The tool is integrated with the failover and upgrade processesC. The tool must be manually started with the "nzhealthcheck-start" command

D. The tool can automatically fix the basic issues identified via Level 1 rule evaluationAnswer: CExplanation:

Questions 35. The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?A. The typical or most common types of queries.B. The longest and shortest running queries on the system.C. The queries submitted by specific users or groups of users.D. The rotational speed of the disk drives during query execution.Answer: DExplanation:

Questions 36. Which of the following will NOT change the priority of all jobs in a session?A. nzsystem -session -id 21664 -priority highB. ALTER SESSION 21664 SET PRIORITY TO HIGH;C. nzsession priority -high -u user -pw password -id 21664D. NzAdmin tool > click on Session > right click on session > change priority >click on priority levelAnswer: BExplanation:

Questions 37. When a CREATE TABLE AS (CTAS) is performed on a table inserting more than 1,000,000,000 rows, which statement is TRUE?A. Groom will be automatically invokedB. Primary key constraints will be checkedC. Statistics will automatically be generatedD. Materialized views will be automatically generatedAnswer: CExplanation:

Questions 38. After a successful upgrade, what must be done to place new session limits into effect?A. No further action is requiredB. Log out of NZ and log back inC. Execute the NZSESSION NEW command

D. Execute the NZSESSION REFRESH commandAnswer: DExplanation:


7/22

Questions 39. Data Restrict Optimization does NOT accomplish which of the following?A. Reduces latency of the queryB. Reduces the time taken to process a single snippetC. Allows multiple different snippets to run concurrentlyD. Reduces the number of drives searched by a snippet


Questions 40. When creating a table with nullable columns, which statement is TRUE?A. 0 is equal to null, the empty string (`') is equal to nullB. 0 is equal to null, the empty string (`') is not equal to nullC. 0 is not equal to null, the empty string (`') is equal to nullD. 0 is not equal to null, the empty string (`') is not equal to nullAnswer: BExplanation:

Questions 41. Within a single Pure Data System for Analytics, what is the fastest way to copy a very large table from database PROD to database TEST?A. Use a CTAS statementB. Use the COPY commandC. Use external tables and UNIX pipesD. Use nzbackup and nzrestore commandsAnswer: DExplanation:

Questions 42. Why is generating statistics on a table important to query performance?A. The table statistics are used to facilitate dislespace reclamation of deleted rows

B. The optimizer uses statistics to determine the optimal execution plan for queriesC. The zone map information cross references the table statistics for each column to avoid scanningD. The Field Programmable Gate Array (FPGA) utilizes the statistics to identifywhich rows/columns to filterAnswer: BExplanation:

Questions 43. What must be properly defined for a table in order to avoid data skew:A. Skew ratioB. DistributionC. OrganizationD. Statistics generationAnswer: CExplanation:

Questions 44. When reviewing the output of an EXPLAIN PLANGRAPH in IBM Netezza Performance Portal, how is the output read?A. Left to right, from top to bottomB. Left to right, from bottom to topC. Right to left, from top to bottomD. Right to left, from bottom to topAnswer: B

Explanation:

Questions 45. What utility is used to find out which host is currently active?


8/22

A. nzstateB. nzconfigC. crm_resourceD. service heartbeat startAnswer: AExplanation:

Questions 46. What information is the NZDUMPSCHEMA command capable of outputting?A. Table definitions onlyB. Table definitions, and view definitions onlyC. Table definitions, view definitions, and database statistical information onlyD. Table definitions, view definitions, database statistical information, and user-defined extensions registered within the databaseAnswer: DExplanation:

Questions 47. Columns in a table may be zone mapped. How are those columns chose

n?A. They are automatically selected by the systemB. They are always based on the samecolumns as the table's distribution keyC. They are added via the ALTER TABLE ADD INDEX(column_name) statementD. They are added via the ALTER TABLE ADD ZONEMAP(column_name) statementAnswer: AExplanation:

Questions 48. When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query history NOT collect data?A. PlansB. Disks

C. TablesD. QueriesAnswer: CExplanation:

Questions 49. When working with sequences, which statement will always be TRUE?A. Only integers are generatedB. The default data type is SMALL I NTC. The first value generated is the number 1D. Values generated by the sequence will be unique across all tables and databasesAnswer: DExplanation:

Questions 50. What is the only predefined database user, which is able to access all objects and perform all tasks against the database?A. RootB. PublicC. AdminD. SystemAnswer: BExplanation:Questions 51. Which of the following system views will NOT show information about active queries?A. _v_qryhist

B. _v_qrystatC. _v_planstatusD. _v_querystatus


9/22


Questions 52. What statement about LDAP security is TRUE?A. If a user can be authenticated locally, LDAP authentication will not be usedB. When LDAP authentication is used, NPS will require a password if the ALTER USER statement is run

C. If LDAP authentication fails, NPS will note the reason for the failure in the /nz/kit/log/postgres/pg.log fileD. When LDAP authentication is used, NPS will require a password if the CREATE USER statement is runAnswer: BExplanation:

Questions 53. Which two characteristics describe materialized views? (Choose two.)A. Materialized views can contain aggregatesB. Materialized views can contain a HAVING clauseC. Materialized views can contain a WHERE clause

D. Materialized views can contain an ORDER BY clauseE. Materialized views can reference only one base table in the FROM clauseAnswer: B,DExplanation:

Questions 54. A user is running Netezza Performance Server Release 7.0.3 on an environment where cross- database access has been enabled. The user sees the following prompt:DEV(ADMIN)=>Which two sets of statements will execute successfully? (Choose two.)A. CREATE SEQUENCE prod..seq1;B. INSERT INTO emp SELECT * FROM dev..emp;C. INSERT INTO prod..emp SELECT * FROM emp;

D. INSERT INTO emp SELECT * FROM prod..emp;E. CREATE MATERIALIZED VIEW emp AS SELECT * FROM prod..emp;Answer: A,CExplanation:

Questions 55. What two types of actions can be configured using the NZ Event Manager? (Choose two)A. Inserting a row into a tableB. Running a stored procedureC. Sending an email to a list of addressesD. Running a command on the active hostE. Sending a Simple Network Message Protocol (SNMP) eventAnswer: B,CExplanation:

Questions 56. What is the maximum supported size of a BLOB in NPS?A. 32k bytesB. 64k bytesC. 128k bytesD. BLOBs are not supported. A data warehouse is no place to store such large filesAnswer: AExplanation:

Questions 57. Here's an excerpt from a successful query execution plan:

Which of the following statements is TRUE?


10/22

A. 3 columns from FREQ_SHOPPER table were broadcast as a temporary table to allSPUsB. 3 columns from FREQ_SHOPPER table were redistributed in a temporary table named "LINK"C. 3 columns from FREQ_SHOPPER table were redistributed in a system-managed temporary tableD. 3 columns from FREQ_SHOPPER table were redistributed in a permanent table nam

ed "2147517585"Answer: CExplanation:

Questions 58. What mechanism does NPS use for LDAP authentication?A. Pluggable Authentication Module (PAM)B. Generic Security Services API (GSSAPI)C. Simple Authentication and Security Layer (SASL)D. Berkeley Software Distribution Authentication (BSDAuth)Answer: AExplanation:

Questions 59. The Pure Data System for Analytics implements which level of transaction isolation?A. SerializableB. Committed readC. Repeatable readD. Uncommitted readAnswer: AExplanation:

Questions 60. What is the maximum number of columns you can choose as organizing keys for a clustered base table?A. 1B. 2

C. 4D. 8Answer: CExplanation:Questions 61. Which of the following is NOT true about the createxid column?A. They can be queriedB. They are updated to zero during a DELETE operationC. Rows loaded in a transaction are assigned the same valueD. They contain the ID of the transaction that created the recordAnswer: DExplanation:

Questions 62. What is nzconvert used for?A. To convert compressed external tables into ASCII textB. To convert between character encodings before loading dataC. To translate stored procedures into NZPLSOL compatible syntaxD. To upgrade/downgrade the database to a different software versionAnswer: BExplanation:

Questions 63. 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?A. When an FPGA is busyB. By turning off serialization within the system

C. They are never permitted under any conditionsD. When the transaction isolation is read-committedAnswer: B


11/22

Explanation:

Questions 64. What can be backed up using the nzbackup utility?A. Host dataB. pg.log filesC. Temporary tablesD. User permissions

Answer: AExplanation:

Questions 65. Which of the following will NOT show the current sessions on the Netezza server?A. nzsql\actB. nzsessionC. nzsystem-showSessionsD. SELECT* FROM_v_sessionAnswer: DExplanation:

Questions 66. Which of the following statements about temporary tables is TRUE?A. Synonyms can be created for temporary tablesB. Temporary tables have been deprecated as of NPS 7.0.3C. Temporary tables can be specified as a base table for materialized viewsD. When a user executes the command "SET SESSION READ ONLY", they are still able to create and write to temporary tablesAnswer: CExplanation:

Questions 67. What are two considerations for usage of materialized views? (Choose two.)A. Materialized views are not supported.B. Materialized views are logical entities.

C. Materialized views may improve query performance.D. Materialized views are the same as database views.E. Materialized views are considered for usage by the Optimizer.Answer: C,EExplanation:

Questions 68. In NZPLSQL which of the following statements is TRUE?A. If you specify the BEGIN AUTOCOMMIT ON syntax, the procedure executes each statement in the block as a singleton statement with an implied COMMIT after eachstatementB. If you specify the BEGIN AUTOCOMMIT OFF syntax, the procedure executes each statement in the block as a singleton statement with an implied COMMIT after each statementC. If you specify the BEGIN AUTOCOMMIT OFF syntax, the procedure executes each statement in the block as a singleton statement with an implied ROLLBACK after each statementD. If you specify the BEGIN AUTOCOMMIT ON syntax, the procedure executes eachstatements the block as a singleton statement with an implied ROLLBACK after each statementAnswer: AExplanation:

Questions 69. Netezza database accounts are NOT created and/or managed usingA. The NzAdmin toolB. The Netezza Performance Portal

C. The Netezza command line interfaceD. The Netezza host's command line interfaceAnswer: B


12/22

Explanation:

Questions 70. 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.A. The default value for this variable is FALSEB. This variable controls whether the system allows users to create and manage multiple schemas

C. 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 databaseD. 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 nameAnswer: BExplanation:Questions 71. External tables that only exist for the duration of a single query are known asA. Hosted TablesB. Session TablesC. Transient External TablesD. Temp or Temporary External Tables


Questions 72. A user performs a full backup of a database on Monday and a differential backup on Tuesday. On Wednesday what is the fastest method to ensure a complete backup of user data?A. Perform a full backupB. Perform a differential backupC. Perform a cumulative backupD. Perform cumulative and differential backupsAnswer: DExplanation:

Questions 73. In Release 7.1 what happened to Gatekeeper registry settings?A. They were replaced by Scheduler RulesB. They were replaced by Gatekeeper RulesC. The number of registry settings was significantly reducedD. The number of registry settings was significantly increasedAnswer: BExplanation:

Questions 74. Which of the following statements about rowids is TRUE?A. They will always be unique within a tableB. They will always be sequential within a tableC. Unlike createxid and deletexid, rowids are only 8 bytesD. A&BAnswer: DExplanation:

Questions 75. A thermal fault has occurred. Where would more information be found regarding the problem?A. nz/kit/log/dbos/dbosJogB. nz/kit/log/postgres/pgJogC. /nz/kit/log/sysmgr/sysmgr.logD. /nz/kit/log/sysmgr/hardwareJogAnswer: CExplanation:

Questions 76. When a temporary table is created, where will the data be stored?A. In physical memory on the S-BladesB. On the host under the /nz/tmp directory


13/22

C. On the S-Blades under the data partitionD. On the S-Blades under the swap partitionAnswer: CExplanation:

Questions 77. Which of the following is FALSE about clustered base tables (CBT)?

A. A CTAS from a CBT results in another CBTB. You cannot create materialized views on a CBTC. Records are stored in nearby extents based on multiple key valuesD. "ALTER TABLE ... ORGANIZE ON NONE" changes a CBT into a regular tableAnswer: BExplanation:

Questions 78. A database administrator enters the following command: "nzhealthcheck." Select the statement that is FALSE.A. The command will generate and print a health check reportB. The command will request the monitoring daemon to evaluate policy rules.

C. The command will provide the power status of each hardware component in the system.D. The command will provide a path to a text file that contains advice on fixing existing issues.Answer: CExplanation:

Questions 79. What database object in the history database will you use to findthe version number of the history database?A. _t_versionB. _vt_versionC. HistversionD. $hist_version


Questions 80. What should be considered when selecting distribution key columns? A. Select as many columns as possibleB. Select columns that contain many nullsC. Select columns that contain few unique valuesD. Select columns used to join to other large tablesAnswer: BExplanation:Questions 81. Which of the following default Guaranteed Resource Allocation settings is correct?A. Admin user has 50% maximumB. Public group has 20% maximumC. Public group has 20% minimum & 50% maximumD. Admin user has 100% minimum & 100% maximumAnswer: CExplanation:

Questions 82. Where are the NPS log files located on the host?A. /var/logB. /usr/localC. /nz/kit/logD. The SYSTEM database



14/22

Questions 83. The CUSTOMER table has one column, customerid. Which statement can be used to determine the data skew of the table?A. SELECT DISTINCT (datasliceid) FROM customer;B. SELECT DISTINCT (customerid) FROM customer;C. SELECT datasliceid, COUNT(*) FROM customer GROUP BY 1 ORDER BY 2;D. SELECT customerid, COUNT(*) FROM customer GROUP BY 1 ORDER BY 2;Answer: D

Explanation:

Questions 84. Which additional feature in NPS would you need to configure to use an audit database?A. Call homeB. Multi-level securityC. Enhanced cryptography SP 800-131D. Workload Management Scheduler RulesAnswer: DExplanation:

Questions 85. Which of the following are valid types of scheduler rules? (Choose

two.)A. Resource scheduler ruleB. Limiting scheduler ruleC. Runtime scheduler ruleD. Modifying scheduler ruleE. Prioritizing scheduler ruleAnswer: A,EExplanation:

Questions 86. Which of the following statements will create a row secure table?A. Create rowsecure table myRST (aint, b int);B. Create table myRST (aint, b int) row security;C. Create table myRST (aint, b int) as row secure table;

D. Create table myRST (a int, b int, _sec_labelvarchar(4000));Answer: BExplanation:

Questions 87. nzload is invoked with the "allowReplay" option enabled- If the state changes from online to pausing then to online, which statement is TRUE?A. nzload will failB. nzload automatically continues without user interventionC. nzload must be stopped and resumed by the user from the last check pointD. nzload automatically restarts but the user must remove the allowReplay optionAnswer: CExplanation:

Questions 88. What CANNOT be measured and managed by system views?A. Power supply status for each rackB. Temperature values on an S-bladeC. Status of the host attached storageD. Resource group utilization and historyAnswer: CExplanation:

Questions 89. Which statement will cause IBM Netezza Replication Services to use "By-Value" instead of the "By-SQL" replication method?A. INSERT INTO customer VALUES (NULLIF(a, b),,);B. INSERT INTO customer VALUES (RANDOMO,,);

C. INSERT INTO customer SELECT rowid FROM orders;D. B & CE. A & B


15/22

Answer: EExplanation:

Questions 90. Which statement is TRUE regarding the NPS compression engine?A. Compression ratio is data dependentB. Compression is performed by the hostC. Compression degrades data scan speeds

D. Compression is performed by the SAS switchesAnswer: CExplanation:Questions 91. Which command is used to abort a user's SQL transaction?A. KillB. AbortC. NzstopD. NzsessionAnswer: DExplanation:

Questions 92. Which of the following statements is NOT true about Short Query Bi

as?A. The default length is 2 secondsB. Additional memory is allocated for short queriesC. It guarantees query run times of less than 2 secondsD. It is based on the optimizer's cost estimate of the query run timeAnswer: BExplanation:

Questions 93. Which of the following invisible columns exists on every table inthe database?A. EditidB. CreatexidC. Deletedate

D. CreatedateAnswer: BExplanation:

Questions 94. A user has access to two databases, DEV and PROD. Currently the user is connected to the DEV database.Which operation is permitted?A. DELETE FROM prod.dbuser.customerB. SELECT * FROM prod.dbuser.customerC. TRUNCATE TABLE prod.dbuser.customerD. INSERT INTO prod.dbuser.customer SELECT * FROM dev.dbuser.customerAnswer: DExplanation:

Questions 95. Which of the following statements about temporary tables is TRUE?A. A temporary table can have 1800 columnsB. A temporary table can only persist for the lifetime of a transactionC. Querying temporary tables typically performs slower than querying equivalentexternal tablesD. An ADMIN user using the nzsql utility can list existing temporary tables using the "\de" internal slash commandAnswer: CExplanation:

Questions 96. Which attribute CANNOT be defined for both users and groups?

A. Row set limitB. Default priorityC. Query time out


16/22

D. Password expirationAnswer: DExplanation:

Questions 97. Which nzload operation statement is TRUE?A. nzload must have a control fileB. nzload must be run from the host

C. nzload performs only singleton insertsD. nzload user must have CREATE EXTERNAL TABLE privilegeAnswer: BExplanation:

Questions 98. Which of the following is NOT performed by the nzhw utility?A. It shows the current storage topologyB. It shows the role of each component in the applianceC. It shows the location of each component in the applianceD. It shows the hardware ID of each component in the applianceAnswer: DExplanation:

Questions 99. What method will show only the deleted rows on the CUSTOMER table? A. SELECT * FROM customer WHERE deletexid 0;B. Deleted rows can't be shown as they have been deletedC. Set show_deleted_records = true; SELECT * FROM customer;D. Set show_deleted_records = true; SELECT* FROM customer WHERE deletexid 0;Answer: CExplanation:

Questions 100. Which option does NOT trigger a HardwareNeedsAttention event?A. A power supply has failedB. A switch has been rebooted

C. A SAS cable fails or is disconnectedD. A chassis or fabric switch port is in a down state for longer than the defined thresholdAnswer: BExplanation:Questions 101. With LDAP enabled, which of the following can be verified against an LDAP server?A. ADMIN user authenticationB. Non-ADMIN user authenticationC. Database user SELECT privilegesD. Database user GROUP authenticationAnswer: DExplanation:

Questions 102. Which of the following cannot be found with an EXPLAIN statement? A. Viewing scan orderB. Viewing active queriesC. Viewing confidence levelD. Viewing estimated costsAnswer: CExplanation:

Questions 103. What is the naming convention for system views?A. _v_

B. _$v_ rC. nz_v_ D. sys_v_


17/22

Answer: BExplanation:

Questions 104. If nzload is being used to load data into the customer table, which of the following operations will be blocked until the load has completed?A. SELECT from the customer tableB. DELETE from the customer table

C. TRUNCATE of the customer tableD. nzbackup of the database in which the customer table residesAnswer: AExplanation:

Questions 105. What does "Plan 4.457" signify in the attached snapshot of a plan file?

A. The query plan was built in 4457 secondsB. The query plan was saved in 4457 secondsC. The query plan was queued for 4457 seconds

D. The query plan was executed in 4457 secondsAnswer: DExplanation:

Questions 106. Which statement about external tables is TRUE?A. Materialized views can be created for external tablesB. External table data is deleted using the DELETE statementC. The GENERATE STATISTICS command can be run against external tablesD. External tables can be used to unload data to a Microsoft Windows directoryAnswer: BExplanation:

Questions 107. Which file format is NOT supported by the nzload utility?

A. ASCII delimited formatB. Fixed length record formatC. gzip compressed file formatD. Pure Data System for Analytics compressed file formatAnswer: CExplanation:

Questions 108. Which of the following is a valid data type definition?A. TEXTB. CLOBC. CHAR(128000)D. NUMERIC(38,1)Answer: AExplanation:

Questions 109. Which of the following is TRUE regarding distribution keys?A. Up to 4 columns can be specified for a distribution key on a tableB. The distribution key cannot be changed on a given table once that table is createdC. Rows with the same distribution key value are stored on the same data sliceD. All of the aboveAnswer: CExplanation:

Questions 110. Which log directories will record system state changes? (Choose t

wo)A. /nz/kit/log/bnrmgrB. /nz/kit/log/sysmgr


18/22

C. /nz/kit/log/fcommtxD. /nz/kit/log/eventmgrE. /nz/kit/log/sessionmgrAnswer: B,CExplanation:

Questions 111. What will prevent a GROOM TABLE command from running on a table?

A. There are active materialized views on the tableB. There are active selects running against the tableC. There are active nzloads running against the tableD. There are active updates running against the tableAnswer: CExplanation:

Questions 112. The DBA created and loaded the table CUSTOMER as follows:Please refer to the excerpt (highlighted in bold) of a successful query execution plan which used the CUSTOMER table.Which of the following statements is TRUE?

A. The FPGA cannot restrict columns declared as CHAR(7)B. The FPGA can only restrict columns which are distribution columnsC. The FPGA can directly compute the result of the table predicate while reading the rowsD. The FPGA cannot compute the result of the table predicate for varying character columnsAnswer: BExplanation:

Questions 113. What two conditions must be met to achieve a co-located join betw

een two tables without a dynamic redistribution? (Choose two.)A. Both tables have primary keys definedB. Both join columns have the same nameC. Both tables must be distributed on randomD. Both join columns have identical data typesE. Both tables must be distributed on their join columnAnswer: B,EExplanation:

Questions 114. A stored procedure returning one value is created. Which two methods can be used to execute the procedure? (Choose two.)A. EXECUTE commandB. SELECT statement within a FROM clauseC. SELECT statement within a HAVING clauseD. SELECT statement without a FROM clauseE. SELECT statement with tables in the FROM clauseAnswer: B,CExplanation:

Questions 115. Which of the following is TRUE regarding Multiple Schema Support? A. Schemas can contain several databasesB. Only the admin user can manage schemasC. Schemas allow users to reuse object namesD. Multiple schema support is enabled by default



19/22

Questions 116. When might a user receive an "unable to serialize" error?A. A user submits a stored procedureB. A user is notified of a system eventC. A user runs system diagnosticsD. None of the aboveAnswer: BExplanation:

Questions 117. In a UNIX 64-bit environment, a 64-bit application requires which software to execute SQL statements via ODBC? (Choose two.)A. nzsqlB. An ODBC driver managerC. The system does not support 64-bit ODBCD. A 64-bit ODBC driver for the same UNIX environmentE. A 32-bit ODBC driver for the same UNIX environmentAnswer: B,CExplanation:

Questions 118. Which will guarantee that a zonemap is generated for the NAME col

umn?A. CREATE TABLE customer (name VARCHAR(20));B. ALTER TABLE customer ZONEMAP ON (name);C. CREATE TABLE customer (name VARCHAR(20)) DISTRIBUTE ON (name);D. CREATE MATERIALIZED VIEW custview AS SELECT * FROM customer ORDER BY name;Answer: CExplanation:

Questions 119. Given the following query: SELECT * FROM customers;How does data flow through the Pure Data System for Analytics components?A. FPGA to Disk to Host to UserB. Disk to FPGA to CPU to Host to UserC. Disk to CPU to FPGA to Host to User

D. Disk to Host to S-Blade to FPGA to UserAnswer: BExplanation:

Questions 120. Which of the following statements is TRUE?A. Each table is assigned its own set of data slicesB. Each database is assigned its own set of data slicesC. When creating a database the maximum allowed space can be specifiedD. When the system creates records, it assigns them to a logical data slice based on their distribution key value.Answer: CExplanation:Questions 121. Which statement about nzrestore is NOT true?

A. nzrestore can restore selected tablesB. nzrestore can perform a redirected restoreC. nzrestore can restore from an nzbackup UNIX pipeD. nzrestore can restore to a different Pure Data System for Analytics server from the backup serverAnswer: DExplanation:

Questions 122. Which statement about the GROOM feature is TRUE?A. GROOM requires space to make a complete copy of the tableB. GROOM prevents nzload from inserting data while in progressC. GROOM only operates on tables that include an ORGANIZE ON clause

D. GROOM allows UPDATE, DELETE, and INSERT operations to occur while a backup is in progressAnswer: B


20/22

Explanation:

Questions 123. Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?A. AIX-HAB. Linux-HAC. SuSE-HA

D. Solaris-HAAnswer: BExplanation:

Questions 124. What is the definition of appliance topology?A. The ratio of CPU cores to FPGAs to disk drivesB. The model number of the appliance, e.g, N1000C. The map showing which SPUs manage which data slicesD. The number of disk drives in the system and in which disk enclosures they resideAnswer: CExplanation:

Questions 125. What command would you use to create a query history database?A. nzdbB. nzsqlC. nzhistcreatedbD. nzdatacreatedbAnswer: DExplanation:

Questions 126. The optimizer estimates cost in units of:A. Seconds (e.g. 1=1 second)B. Tenths of seconds (e.g. 10 = 1 second)C. Hundredths of seconds (e.g. 100 = 1 second)

D. Thousandths of seconds (e.g. 1000 = 1 second)Answer: BExplanation:

Questions 127. When setting up a crontab entry, what must be done on a Pure Data System for Analytics server?A. Pause the applianceB. Create an nzcron eventC. Stop and start the applianceD. Add a file entry to both hostsAnswer: DExplanation:

Questions 128. Which of the following is NOT a Prioritized Query Execution priority level?A. LowB. HighC. UrgentD. CriticalE. NormalAnswer: EExplanation:

Questions 129. When using a CREATE TABLE statement, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via t

he database? (Choose two.)A. NULLB. UNIQUE


21/22

C. NOT NULLD. RIMARY KEYE. DEFAULT valueAnswer: B,DExplanation:

Questions 130. What is the host Linux file that must be modified to permanently

adjust optimizer settings such as enabling schema support?A. /nz/data/postgresql.confB. /nz/data/config/system.cfgC. /nz/kit/sys/initTopology.cfgD. /nz/kit/log/sysmgr/sysmgr.logAnswer: AExplanation:

Questions 131. What columns contain row count information in the system tables?(Choose two.)A. STAHIVALB. RELREFSC. STALOVALD. RELTUPLESE. ATTDISPERSIONAnswer: B,E

Explanation:

Questions 132. Which statement or operation will cause IBM Netezza Replication Services to use the "By-VALUE" replication gmethod?A. Insert data from a non-replicated databaseB. LIMIT ALLC. RANDOMOD. A & CE. B& CAnswer: C

Explanation:

Questions 133. 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?

A. The query plan will show a double redistribute for both tables CUSTOMER and ORDERS followed by a HashJoinNode to compare all rowsB. The query plan will showa broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using a HashJoinNodeC. 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 ExprJoinNodeD. The query plan will show a redistribute for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS usingan ExprJoinNodeAnswer: D

Explanation:

Questions 134. Which procedural logic is NOT supported by NZPLSQL?A. Scrollable cursorsB. Looping (while, for)C. Conditionals (if, else)D. Returni

ng a scalar result or result setAnswer: A


22/22

Explanation:

Netezza Questions

Documents

Transcript of Netezza Questions