000-540 - IBM PureData System for Analytics v7.0
Go back to IBM
What will prevent a GROOM TABLE command from running on a table named TableA?
If there are any materialized views on the table TableA.
In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)
The runaway query event was enabled.
The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.
When working with sequences, which statement will always be true?
Integers (whole numbers) are generated.
All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?
nzbackup/nzrestore with the -user option has been replaced with which option to allow multi-level security (MLS) information, such as categories, cohorts, and levels to be backed up/restored?
What is the maximum number of columns you can choose as organizing keys for clustered base table?
Which statement is true for database users and groups?
Users and groups are global and not tied to a particular database.
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
Use an EXTERNAL TABLE
With LDAP enabled, which of the following is verified against an LDAP server?
Database user password authentication.
nzload is invoked with the "allowReplay" option enabled. While the PureData System for Analytics Appliance changes state from online to pausing then to online, which statement is true about the nzload process on the Appliance?
nzload automatically continues without user intervention.
When setting up a crontab entry, what must be done on a PureData System for Analytics server?
Add entry to active host and standby host.
Given a plan ID, how would you obtain the query execution plan? (Choose two.)
Go to the query history within the Windows NzAdmin GUI tool.
Issue "SHOW PLANFILE <nn>;" after the query has been submitted.
Where are the database log files located?
You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?
Select * from PROD..TableA
How does the PureData System for Analytics utilize the distribution key to store records on disk?
System assigns records to a logical data slice based on their distribution key value.
If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?
A maximum of 80% of resources when no other users are on the system.
Which piece of information is NOT gathered as part of the statistical information when generate statistics is run on a table?
The number of updated rows in the table.
The PureData System for Analytics implements which level of transaction isolation?
When are zonemaps initially created for a table?
Which is NOT a function of the Field Programmable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?
Which statement is true regarding the compress engine?
Data automatically gets compressed.
Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?
Flows through the host.
What two conditions must be met to achieve a collocated join between two tables? (Choose two.)
Both join columns have identical data types.
Both tables must be distributed on their join column.
Which statement is NOT true?
nzrestore can restore from an nzbackup UNIX pipe.
Which statement is NOT true regarding the nzload utility?
nzload blocks update/delete against the target table.
What will occur when two tables are joined together and the data is NOT collocated?
Data is dynamically redistributed or broadcasted.
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?
Which will result in support for zonemaps on the LastName column?
CREATE TABLE TableA (LastName VARCHAR(20)); CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY LastName;
The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?
The rotational speed of the disk drives during query execution.
Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?
What is the fastest join utilized by PureData System for Analytics?
In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)
An ODBC driver manager.
A 64-bit ODBC driver for the same UNIX environment.
The simplest query execution plan file must have the following minimum nodes?
ScanNode, RestrictNode, ProjectNode, ReturnNode
Which statement is true about the groom feature?
Groom allows the user to reorganize tables based on the ORGANIZE ON clause.
What are two considerations for usage of materialized views? (Choose two)
Materialized views may improve query performance.
Materialized views are considered for usage by the Optimizer.
Which is NOT a function that can be performed by nzbackup?
Backup the /nz/data directory
Why is table skew important to manage?
High table skew negatively impacts performance.
Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?
On which component(s) does the UDX run?
The host and the S-blades only.
Which is NOT a way to check if the database is online?
Which procedural logic is NOT supported by NZPLSQL?
Which User Defined Function (UDF) statement is true?
It accepts zero or more input values but produces one output value.
Which statement is true about a simple load using external tables?
The load can be configured to automatically continue to load if the S-Blade resets or fails.
What is the limitation on join types with floating-point data types?
The system cannot perform a fast hash join on a floating point data type, but instead must perform a slower sort merge join.
What is required to troubleshoot a query?
nzdumpschema and the execution plan.
When creating a table, you can specify a column constraint for each individual column of either "NULL" or "NOT NULL". When column values are later evaluated within a query statement, which of these is true?
0 is not equal to null, the empty string ( '' ) is not equal to null.
Which nzload operation statement is correct?
nzload user must have CREATE EXTERNAL TABLE privilege.
What PureData System for Analytics component is responsible for controlling table storage?
OLE-DB based applications on UNIX requires which PureData System for Analytics software?
OLE-DB is not supported on UNIX.
A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)
Using the EXECUTE command.
Using the SELECT statement without a FROM clause.