Question 341 · 1323 in bank
Select 2Which of the following objects are contained within a schema? (Choose two.)
Show answer
Answer: BD
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
Which of the following objects are contained within a schema? (Choose two.)
Answer: BD
Which of the following statements describe features of Snowflake data caching? (Choose two.)
Answer: BE
Option A is incorrect because when a virtual warehouse is suspended, the data cache is not saved on the remote storage layer. The data cache is cleared when a virtual warehouse is suspended and any data that needs to be cached is reloaded from the remote storage layer when the virtual warehouse is resumed. Option C is incorrect because the query result cache is a shared cache and all users can access the data that has been cached. There are no restrictions based on user access. Option D is incorrect because the metadata cache is used by default in queries and there is no need for a user to explicitly set USE_METADATA_CACHE to TRUE. Option B is correct because Snowflake automatically manages its data cache and evicts the least-recently used data when the cache becomes full. Option E is correct because the RESULT_SCAN table function can be used to query and filter the data that has been cached in the query result cache.
Source: Adapted from community discussion — DataEngineer7331
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size S is being used. The following COPY INTO command was executed: COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON) The load failed with this error: Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?
Answer: D
D https://docs.snowflake.com/en/user-guide/semistructured-considerations#data-size-limitations Semi-structured Data Size Limitations A VARIANT can have a maximum size of up to 16 MB of uncompressed data. However, in practice, the maximum size is usually smaller due to internal overhead. The maximum size is also dependent on the object being stored. For more information, see VARIANT. In general, JSON data sets are a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported. If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO command to remove the outer array structure and load the records into separate table rows
Source: Adapted from community discussion — 0e504b5
What is a feature of a stored procedure in Snowflake?
Answer: D
but can't hide the underlying metadata from all users. Here "all" users is the catch. The role that created can view the definition of stored proc
Source: Adapted from community discussion — SV1122
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Answer: BD
The output of Flatten: SEQ A unique sequence number associated with the input record; the sequence is not guaranteed to be gap-free or ordered in any particular way. KEY For maps or objects, this column contains the key to the exploded value. PATH The path to the element within a data structure which needs to be flattened. INDEX The index of the element, if it is an array; otherwise NULL. VALUE The value of the element of the flattened array/object. THIS The element being flattened (useful in recursive flattening).
Source: Adapted from community discussion — KarBiswa
What is the minimum Snowflake edition required to create a materialized view?
Answer: B
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
Answer: A
How are serverless features billed?
Answer: A
A - correct B - serverless has no minimum (virtual warehouse has 60 sec) C - parameter doesn't exists D - not 10% of MONTHLY, but DAILY usage - Usage for cloud services is charged only if the daily consumption of cloud services exceeds 10% of the daily usage of virtual warehouses.
Source: Adapted from community discussion — EmiB
Which Snowflake architectural layer is responsible for a query execution plan?
Answer: C
Cloud Services The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control
Source: Adapted from community discussion — Naah
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
Answer: B
https://docs.snowflake.com/en/user-guide/data-sharing-reader-create The reader account is created, owned, and managed by the provider account, which assumes all responsibility for credit charges incurred by users in the reader account. Similar to standard consumer accounts, the provider account uses shares to share databases with reader accounts; however, a reader account can only consume data from the provider account that created it. Warehouses in a reader account can consume an unlimited number of credits each month, which will be charged to your provider account. To limit usage, set up a resource monitor for the warehouse.
Source: Adapted from community discussion — 0e504b5
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 341. 1323 questions available.
Version 1.0.0. How we source questions