Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?
A. Use statistics.
B. Set show_plan = true;
C. Use pg.log file.
D. Use explain.
正解:D
質問 2:
Why is generating statistics on a table important to query performance?
A. The table statistics are used to facilitate disk space reclamation of deleted rows.
B. The Zone Map information cross references the table statistics for each column to avoid scanning.
C. The optimizer uses statistics to determine the optimal execution plan for queries.
D. The Field Programmable Gate Array (FPGA) utilizes the statistics to identify which row/columns to filter.
正解:C
質問 3:
Which option does NOT trigger a HardwareNeedsAttention event?
A. A power supply has failed.
B. A chassis or fabric switch port is in a down state for longer than the defined threshold.
C. A SAS cable fails or is disconnected.
D. A switch has beenrebooted.
正解:A
質問 4:
Whyshould 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
質問 5:
Click on the exhibit.
Given the following query: SELECT * FROM TableA, TableB WHERE TableA.c_custkey = TableB.o_custkey;What type of join processing will occur when the query is executed?
A. Collocation hash join processing
B. Distributed hash join processing
C. Replication sort merge join processing
D. Broadcast sort merge join processing
正解:A
質問 6:
After performing a groom on a clustered base table, which statement is true?
A. The table is reorganized on the DISTRIBUTE ON clause.
B. The table is redistributed on the ORGANIZE ON clause.
C. The table is redistributed on the DISTRIBUTE ON clause.
D. The table is reorganized on the ORGANIZE ON clause.
正解:D
質問 7:
Which statement is true about optimizer settings?
A. They can be set at the session and at the group level.
B. They can be set system wide only.
C. They can be set system wide and at the session level.
D. They can be set at the database level only.
正解:C
質問 8:
What two conditions must be met to achieve a collocated join between two tables? (Choose two.)
A. Both tables have primarykeys defined.
B. Both join columns have the same name.
C. Both tables must be distributed on random.
D. Both join columns have identical data types.
E. Both tables must be distributed on their join column.
正解:D,E
質問 9:
An ETL/ODBC application is inserting 1 million records in a single transaction against the PureData System for Analytics. 1 million individual INSERT SQL statements are generated. What can make this faster?
A. Set the COMMIT interval to 10,000.
B. Increase the Socket Buffer Size.
C. Use an EXTERNAL TABLE.
D. Use a COPY command.
正解:C
Fujisawa -
Pass4TestのP2090-050問題集は有難い商品です。一度試験に合格しました。今後、引き続く参考書を利用します。