P2090-050 Exam Questions

Short Query Bias (SQB) allows for reserved resources to be used for which type of query?

What is true about queries submitted on the PureData System for Analytics Appliance?

What two types of notification can be configured for an event? (Choose two.)

If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?

Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?

Which statement regarding temporary tables is true?

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

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?

A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)

Which User Defined Function (UDF) statement is true?

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

What is nzconvert used for?

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

Which option does NOT trigger a HardwareNeedsAttention event?

What is required to troubleshoot a query?

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

Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)

How does the PureData System for Analytics utilize the distribution key to store records on disk?

What should be considered when you are asked to select the distribution key columns for a very large fact table?

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

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?

You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

Which statement is true?

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?

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?