Which two statements are true about queries on the PureData System for Analytics Appliance? (Choose two.)
A. Queries are executed in parallel by the host.
B. Queries must be compressed before they can be executed.
C. Queries are compiled into snippets and executed in parallel by the S-Blades.
D. Queries must be uncompressed by the user and executed in parallel by the host.
E. A query is compiled into a snippet which is executed across all available S-Blades.
What is the limitation on join types with floating-point data types?
A. The system does not have a limitation on floating-point data types.
B. The system cannot perform any type of join on floating-point data types.
C. The system cannot perform a fast sort merge join on a floating point data type, but instead must perform a slower hash join.
D. The system cannot perform a fast hash join on a floating point data type, but instead must perform a slower sort merge join.
Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?
A. Bypasses the host.
B. Flows through the host.
C. Compressed on the host.
D. Uncompressed on the host.
Why is table skew important to manage?
A. Low table skew negatively impacts performance.
B. High table skew negatively impacts performance.
C. Low table skew negatively impacts data compression.
D. Deleted rows consume disk space until they are freed.
Which statement is true regarding the compress engine?
A. Data automatically gets compressed.
B. Columns to be compressed must be defined.
C. The nzcompress utility must be run to compress the table.
D. The nzcompress utility must be run to compress the database.
If 'admin' user is running a query, what percentage of resources are available when Guaranteed Resource Allocation (GRA) is Enabled?
A. The maximum GRA assigned to the ADMIN group.
B. The maximum GRA assigned to the PUBLIC group.
C. 100% of the resources while other resource groups are active.
D. Typically half of the resources while other resource groups are active.
What CANNOT be measured and managed by system views?
A. Temperature values on S-blade.
B. Status of the host attached storage.
C. Power supply status for each frame.
D. Resource group utilization and history.
What will occur when two tables are joined together and the data is NOT collocated?
A. No data movement is required.
B. A merge join operation will be performed.
C. A cluster based join method is performed.
D. Data is dynamically redistributed or broadcasted.
When a temporary table is created, where will the data be stored?
A. On the host under the /nz/tmp directory.
B. On the S-Blades under the data partition.
C. Held in physical memory on the S-Blades.
D. On the S-Blades under the swap partition.
A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource group each execute 1 job at the same time, which statement is correct?
A. Each job gets 25% and both run at the same time.
B. Each job gets 50% but only one job runs at a time.
C. Each job gets 50% and both run at the same time.
D. You cannot set the job maximum per resource group.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-047 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.