What are characteristics of transient tables in Snowflake? (Select TWO).
A. Transient tables can be altered to make them permanent tables.
B. Transient tables have a Fail-safe period of 7 days.
C. Transient tables have Time Travel retention periods of 0 or 1 day.
D. Transient tables can be cloned to permanent tables.
E. Transient tables persist until they are explicitly dropped.
正解:D,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
A. MAX_CONCURRENCY__LEVEL
B. QUERY_TIMEOUT_IN_SECONDS
C. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
D. STATEMENT_TIMEOUT__IN__SECONDS
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
What should be considered when deciding to use a secure view? (Select TWO).
A. It is not possible to create secure materialized views.
B. The view definition of a secure view is still visible to users by way of the information schema.
C. Once created there is no way to determine if a view is secure or not.
D. No details of the query execution plan will be available in the query profiler.
E. Secure views do not take advantage of the same internal optimizations as standard views.
正解:D,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
Which view can be used to determine if a table has frequent row updates or deletes?
A. STORAGE USAGE
B. STORAGE_DAILY_HISTORY
C. TABLE_STORAGE_METRICS
D. TABLES
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
A. select src:Dealership from car_sales;
B. select src.dealership from car_sales;
C. select dealership from car_sales;
D. select src:dealership from car_sales;
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
What can a Snowflake user do with the information included in the details section of a Query Profile?
A. Determine the total duration of the query.
B. Determine the source system that the queried table is from.
C. Determine the role of the user who ran the query.
D. Determine if the query was on structured or semi-structured data.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
山木** -
Pass4Testのおかげで無事合格だぁ!!SnowPro-Coreこの問題集はとてもわかりやすいので、しっかりとした理解に導いてくれるPass4TestのSnowPro-Core問題集が合格への最短ルートです。