Which nzload operation statement is correct?
A. nzload must have a control file.
B. nzload performs singleton inserts.
C. nzload user must have CREATE EXTERNAL TABLE privilege.
D. nzload must be run from the PureData System for Analytics host.
OLE-DB based applications on UNIX requires which PureData System for Analytics software?
A. Install the JDBC driver for UNIX.
B. Install the ODBC driver for UNIX.
C. Install the OLE-DB driver for UNIX.
D. OLE-DB is not supported on UNIX.
In order for an ODBC application running on Microsoft Windows to connect to PureData System for Analytics, which two steps must be performed? (Choose two.)
A. Install nzsql for Windows.
B. Install nzAdmin for Windows.
C. Install an ODBC driver for Windows.
D. Install an ODBC Driver Manager for Windows.
E. Create or modify a Data Source Name (DSN) for a connection to a database.
What is the only predefined database user, which is able to access all objects and perform all tasks against the database?
A. root
B. public
C. admin
D. system
What will prevent a GROOM TABLE command from running on a table named TableA?
A. If there are any materialized views on the table TableA.
B. If there are any active selects running against the table TableA.
C. If there are any active nzloads running against the table TableA.
D. If there are any active updates running against the table TableA.
When a CREATE TABLE AS (CTAS) is performed on a table creating more than 1,000,000,000 rows, which statement is true?
A. Groom will be automatically invoked.
B. Primary key constraints will be checked.
C. Statistics will automatically be generated.
D. Materialized views will be automatically generated.
Which statement is true for database users and groups?
A. All users must belong to admin group.
B. Creation of users and groups is not allowed.
C. Users and groups are local and tied to a particular database.
D. Users and groups are global and not tied to a particular database.
What is a benefit of Clustered Base Tables?
A. Replicates base table data.
B. An alternate way to order a table's data.
C. Materializes on disk joins between tables.
D. Increases the performance of load operations.
Which option does NOT trigger a HardwareNeedsAttention event?
A. A power supply has failed.
B. A switch has been rebooted.
C. A SAS cable fails or is disconnected.
D. A chassis or fabric switch port is in a down state for longer than the defined threshold.
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.
