Which statement is true regarding the compress engine?
A. Compression is performed by the host.
B. Compression degrades data scan speeds.
C. Compression ratio is data dependent.
D. Compression is performed by the SAS switches.
正解:C
質問 2:
What will occur when two tables are joined together and the data is NOT collocated?
A. A merge join operation will be performed.
B. Data is dynamically redistributed or broadcasted.
C. No data movement is required.
D. A cluster based join method is performed.
正解:B
質問 3:
Which nzload operation statement is correct?
A. nzload performs singleton inserts.
B. nzload must have a control file.
C. nzload user must have CREATE EXTERNAL TABLE privilege.
D. nzload must be run from the PureData System for Analytics host.
正解:C
質問 4:
If 'admin' user is running a query, what percentage of resources are available when Guaranteed Resource Allocation (GRA) is Enabled?
A. Typically half of the resources while other resource groups are active.
B. The maximum GRA assigned to the ADMIN group.
C. The maximum GRA assigned to the PUBLIC group.
D. 100% of the resources while other resource groups are active.
正解:A
質問 5:
Why should you avoid using Boolean data types as a distribution key for a table ?
A. Table is likely to be evenly spread across data slices.
B. Table will not broadcast.
C. Table will not join.
D. Table is likely to be skewed.
正解:D
質問 6:
In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)
A. The pg.log file was configured for two minutes.
B. The nzsystem command was used to set the QUERYTIMEOUT to two minutes.
C. The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.
D. The runaway query event was enabled.
E. The runaway query event was configured for two minutes.
正解:C,D
質問 7:
If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?
A. A maximum of 80% of resources when no other users are on the system.
B. A maximum of 50% of resources when other users are on the system.
C. A maximum of 100% of resources when no other users are on the system.
D. A maximum of 20% of resources when other users are on the system.
正解:A
Mizuhara -
直前対策に役立ちます。P2090-047にみごと合格いたしました
Pass4Testおすすめです。