If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?
A. An nzbackup of the database in which TableA resides
B. A SELECT from TableA
C. A DELETE from TableA
D. A TRUNCATE of TableA
正解:D
質問 2:
A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource groupeach 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.
正解:B
質問 3:
Which file format is NOT supported by the nzloadutility?
A. gzip compressed file format.
B. ASCII delimited format.
C. Fixed length record format.
D. PureData System for Analytics compressed file format.
正解:A
質問 4:
When setting up a crontab entry, what must be done on a PureData Systemfor Analytics server?
A. Create an nzcron event.
B. Add entry to active host and standby host.
C. Stop and start the appliance.
D. nzstop/nzstart the database.
正解:B
質問 5:
What is a benefit of Clustered Base Tables?
A. Materializes on disk joins between tables.
B. An alternate way to order a table's data.
C. Increases the performance of load operations.
D. Replicates base table data.
正解:B
質問 6:
What is the maximum number of columns you can choose as organizing keys for clustered base table?
A. 8
B. 4
C. 1
D. 2
正解:B
質問 7:
When doing a CREATE SEQUENCE, the largest "maximum value" is based onwhat?
A. NUMERIC(38,0)
B. BIGINT
C. FLOAT8
D. VARCHAR(256)
正解:B
質問 8:
You havecreated a group GroupA with JOB MAXIMUM of 4, which statement is true?
A. No more than 4 users can be assigned to Group
B. If users in GroupA submit more than 4 queries they will fail.
C. If users in GroupA submit more than 4 queries, then they will queue in order.
D. The job maximum cannot be less than the default concurrent query limit of 48.
正解:C
質問 9:
Where are the database log files located?
A. /var/log
B. /usr/local
C. /nz/kit/log
D. The SYSTEM database
正解:C
萩原** -
GoogleからPass4Test推薦され、P2090-050製品を購入しました。この模擬試験を解いてから望むとベストです。