Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?
A. Query acceleration service
B. Query Profile
C. Persisted query results
D. QUERY_HISTORY View
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
A. 8 hours
B. 4 hours
C. 1 hour
D. 2 hours
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Authorization to execute CREATE <object> statements comes only from which role?
A. Database role
B. Application role
C. Primary role
D. Secondary role
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
In which hierarchy is tag inheritance possible?
A. Database » View » Column
B. Account » User » Schema
C. Organization » Account» Role
D. Schema » Table » Column
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
A. In the metadata of the target table for 64 days
B. In the metadata of the pipe for 14 days
C. In the metadata of the target table for 14 days
D. In the metadata of the pipe for 64 days
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
In the Snowflake access control model, which entity owns an object by default?
A. The role used to create the object
B. The SYSADMIN role
C. The user who created the object
D. Ownership depends on the type of object
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
What internal stages are available in Snowflake? (Choose three.)
A. User stage
B. Database stage
C. Schema stage
D. Stream stage
E. Named stage
F. Table stage
正解:A,E,F
解説: (Pass4Test メンバーにのみ表示されます)
質問 8:
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
A. Standard
B. Business Critical
C. Virtual Private Snowflake
D. Enterprise
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 9:
What can a user win a reader account do in Snowflake?
A. Query shared data
B. Update existing data
C. Create a new snare
D. Load now data
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
妹*华 -
よく出題されるパターンを徹底分析した予想COF-C02問題集。冷静に落ち着いて試験に臨むことができました。合格だ!