A2090-560 Exam Questions

Which statement is NOT true?

Which statement is NOT true?

Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?

What function can nzrestore perform?

An ETL/ODBC application is inserting 1 million records in a single transaction against the PureData System for Analytics. 1 million individual INSERT SQL statements are generated....

When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query histor...

With LDAP enabled, which of the following is verified against an LDAP server?

What must the Linux administrator ensure when creating a Linux user on the host?

The primary copy of a dataslice is spread across how many disks?

Which is NOT a function of the Field Programmable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?

Which is NOT a way to check if the database is online?

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

Which two commands can be used to shut the database system down? (Choose two.)

A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.

Which statement is true?

When a poor choice of distribution key is made, what is the impact to storage allocation?

Which statement is true about optimizer settings?

Which statement about the GROOM TABLE feature is true?

After performing a groom on a clustered base table, which statement is true?

What are two considerations for usage of materialized views? (Choose two)

A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?

What function can nzbackup perform?

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 u...

When loading a local ASCII file into table via an external table, where can the SQL be submitted?

Which is NOT a function that can be performed by nzbackup?

Which nzload operation statement is correct?

Name the CLI application that allows you to load data from ASCII files to database tables?

Which statement is true?

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

You have created a group GroupA with JOB MAXIMUM of 4, which statement is true?

Which CREATE DATABASE attributes are required?

Which statement is true for database users and groups?

Which two characteristics describe materialized views. (Choose two.)

What is a benefit of Clustered Base Tables?

When are zonemaps initially created for a table?

Which of the following is a valid datatype definition?

Columns in a table may be zonemapped. How are those columns chosen?

When doing a CREATE SEQUENCE, the largest "maximum value" is based on what?

Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?

TableA is currently being accessed in a number of long running queries. Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?

If 'admin' user is running a query, what percentage of resources are available when Guaranteed Resource Allocation (GRA) is Enabled?

What CANNOT be measured and managed by system views?

What will occur when two tables are joined together and the data is NOT collocated?

When a temporary table is created, where will the data be stored?

What is the limitation on join types with floating-point data types?

Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?

Why is table skew important to manage?

Which statement is true regarding the compress engine?

What is nzconvert used for?

Which piece of information is NOT gathered as part of the statistical information when generate statistics is run on a table?