Question 1091 · 1323 in bank
What Snowflake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
Show answer
Answer: D
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
What Snowflake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
Answer: D
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history. What will happen if User2 tries to access the query history?
Answer: D
D correct - You can view results only for queries you have executed. If you have privileges to view queries executed by another user, the Query Detail page displays the details for the query, but, for data privacy reasons, the page does not display the actual query result. https://docs.snowflake.com/en/user-guide/ui-history
Source: Adapted from community discussion — Heetec
What is the minimum Snowflake edition that provides data sharing?
Answer: A
Data sharing is possible in the Standard Edition also. VPS (Virtual Private Snowflake) does not support Secure Data Sharing due to the current limitations against sharing data across regions. Standard and Enterprise Editions support Secure Data Sharing with the usual caveats.
Source: Adapted from community discussion — Tapasgup007
A permanent table and temporary table have the same name, TBL1, in a schema. What will happen if a user executes select * from TBL1;?
Answer: A
The effects of query pruning can be observed by evaluating which statistics? (Choose two.)
Answer: AB
AC is correct A. Partitions scanned: This statistic indicates the number of data partitions (or micro-partitions in Snowflake's terms) that were actually accessed during the execution of a query. Efficient query pruning will reduce the number of partitions scanned because it avoids reading data that does not match the query's filters. A lower number compared to the total available partitions can show that query pruning has effectively reduced the dataset that needed to be scanned. C. Bytes scanned: This statistic shows the volume of data scanned to fulfill the query. Just like with partitions scanned, effective query pruning should reduce the amount of data that needs to be scanned, as it skips over blocks of data that are determined (via metadata inspection) not to contain relevant data. This can significantly enhance query performance, especially in large datasets.
Source: Adapted from community discussion — cybe001
Which data types optimally store semi-structured data? (Choose two.)
Answer: AE
What compute resource is used when loading data using Snowpipe?
Answer: C
Which file function gives a user or application access to download unstructured data from a Snowflake stage?
Answer: C
By default, which role can create resource monitors?
Answer: A
Which DDL/DML operation is allowed on an inbound data share?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1091. 1323 questions available.
Version 1.0.0. How we source questions