P2090-050 Exam Questions
125 real P2090-050 exam questions with expert-verified answers and explanations. Page 2 of 3.
- Question #51
Short Query Bias (SQB) allows for reserved resources to be used for which type of query?
- Question #52
What is true about queries submitted on the PureData System for Analytics Appliance?
- Question #53
What two types of notification can be configured for an event? (Choose two.)
- Question #55
If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?
- Question #56
Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?
- Question #57
Which statement regarding temporary tables is true?
- Question #58
What is the fastest join utilized by PureData System for Analytics?
- Question #59
In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)
- Question #60
With LDAP enabled, which of the following is verified against an LDAP server?
- Question #61
What must the Linux administrator ensure when creating a Linux user on the host?
- Question #62
A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)
- Question #63
Which User Defined Function (UDF) statement is true?
- Question #64
The primary copy of a dataslice is spread across how many disks?
- Question #65
Which is NOT a function of the Field Programmable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?
- Question #66
Which is NOT a way to check if the database is online?
- Question #67
All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?
- Question #68
Which two commands can be used to shut the database system down? (Choose two.)
- Question #69
What is nzconvert used for?
- Question #70
Given a plan ID, how would you obtain the query execution plan? (Choose two.)
- Question #71
Which option does NOT trigger a HardwareNeedsAttention event?
- Question #72
What is required to troubleshoot a query?
- Question #74
Which piece of information is NOT gathered as part of the statistical information when generate statistics is run on a table?
- Question #75
Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)
- Question #76
How does the PureData System for Analytics utilize the distribution key to store records on disk?
- Question #77
What should be considered when you are asked to select the distribution key columns for a very large fact table?
- Question #78
A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.
- Question #80
When a poor choice of distribution key is made, what is the impact to storage allocation?
- Question #81
Which statement is true about optimizer settings?
- Question #82
Which statement about the GROOM TABLE feature is true?
- Question #83
After performing a groom on a clustered base table, which statement is true?
- Question #84
What are two considerations for usage of materialized views? (Choose two)
- Question #85
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
- Question #86
What function can nzbackup perform?
- Question #87
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...
- Question #88
When loading a local ASCII file into table via an external table, where can the SQL be submitted?
- Question #89
Which is NOT a function that can be performed by nzbackup?
- Question #90
Which nzload operation statement is correct?
- Question #91
Name the CLI application that allows you to load data from ASCII files to database tables?
- Question #92
You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?
- Question #93
Which statement is true?
- Question #96
If 'admin' user is running a query, what percentage of resources are available when Guaranteed Resource Allocation (GRA) is Enabled?
- Question #97
What CANNOT be measured and managed by system views?
- Question #98
What will occur when two tables are joined together and the data is NOT collocated?
- Question #99
When a temporary table is created, where will the data be stored?
- Question #100
What is the limitation on join types with floating-point data types?
- Question #101
Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?
- Question #102
Why is table skew important to manage?
- Question #103
Which statement is true regarding the compress engine?
- Question #105
Columns in a table may be zonemapped. How are those columns chosen?
- Question #106
When doing a CREATE SEQUENCE, the largest "maximum value" is based on what?