True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
A. False
B. True
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Which of the following terms best describes Snowflake's database architecture?
A. Multi-cluster, shared data
B. Columnar shared nothing
C. Cloud-native shared memory
D. Shared disk
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
A. Configure the warehouse to a size larger than generally required
B. Set the minimum and maximum clusters to autoscale
C. Use the standard warehouse scaling policy
D. Use the economy warehouse scaling policy
正解:B
質問 4:
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
A. Secure User-Defined Functions (UDFs)
B. External tables
C. Streams
D. Files
E. Sequences
正解:A,B
質問 5:
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
A. Configure the warehouse to a multi-cluster warehouse.
B. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
C. Increase the warehouse size from Medium to 2XL.
D. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
正解:D
質問 6:
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
C. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
D. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
E. Enclose fields that contain delimiter characters in single or double quotes.
F. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
正解:A,B,E
Imoto -
よっかた!COF-R02学習資料を勉強して、先週にCOF-R02試験に合格しました!大変嬉しいです。貴社のサーポットを誠にありがとうございます。