Question 531 · 1323 in bank
Which of the following are characteristics of security in Snowflake?
Show answer
Answer: C
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 are characteristics of security in Snowflake?
Answer: C
Which of the following objects can be shared through secure data sharing?
Answer: D
Which formats does Snowflake store unstructured data in? (Choose two.)
Answer: BD
I am very confusion about this question. Because I read the information that Unstructured data is information that does not fit into a predefined data model or schema. https://docs.snowflake.com/en/user-guide/unstructured-intro.html#sql-functions.
Source: Adapted from community discussion — leozhang
A user is preparing to load data from an external stage. Which practice will provide the MOST efficient loading performance?
Answer: A
Both internal (i.e. Snowflake) and external (Amazon S3, Google Cloud Storage, or Microsoft Azure) stage references can include a path (or prefix in AWS terminology). When staging regular data sets, we recommend partitioning the data into logical paths that include identifying details such as geographical location or other source identifiers, along with the date when the data was written. Organizing your data files by path lets you copy any fraction of the partitioned data into Snowflake with a single command. This allows you to execute concurrent COPY statements that match a subset of files, taking advantage of parallel operations. https://docs.snowflake.com/en/user-guide/data-load-considerations-stage.html#organizing-data-by-path
Source: Adapted from community discussion — SV1122
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
Answer: D
WAIT_FOR_COMPLETION = FALSE | TRUE When resizing a warehouse, you can use this parameter to block the return of the ALTER WAREHOUSE command until the resize has finished provisioning all its compute resources. Blocking the return of the command when resizing to a larger warehouse serves to notify you that your compute resources have been fully provisioned and the warehouse is now ready to execute queries using all the new resources. https://docs.snowflake.com/en/sql-reference/sql/alter-warehouse.html
Source: Adapted from community discussion — SV1122
Which of the following can be used when unloading data from Snowflake? (Choose two.)
What data is stored in the Snowflake storage layer? (Choose two.)
Answer: BC
Service Layer: Which accepts SQL requests from users, coordinates queries, managing transactions and results. Logically, this can be assumed to hold the result cache – a cached copy of the results of every query executed. https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform D cannot be right because the services layer stores cache, not the the storage layer
Source: Adapted from community discussion — 0e504b5
True or False: It is possible to load data into Snowflake without creating a named File Format object.
Answer: A
As the link suggests: 'In regular use, this step is optional, but is recommended'. Therefore it can be loaded without. I think thats enough proof?
Source: Adapted from community discussion — SD3
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps: 1. Created a user called "CONSUMER" 2. Created a database to hold the share and an extra-small warehouse to query the data 3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
Answer: B
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
Answer: DE
A warehouse provides the required resources, such as CPU, memory, and temporary storage, to perform the following operations in a Snowflake session: Executing SQL SELECT statements that require compute resources (e.g. retrieving rows from tables and views). Performing DML operations, such as: Updating rows in tables (DELETE , INSERT , UPDATE). Loading data into tables (COPY INTO ). Unloading data from tables (COPY INTO ). Note - To perform these operations, a warehouse must be running and in use for the session. While a warehouse is running, it consumes Snowflake credits. https://docs.snowflake.com/en/user-guide/warehouses.html
Source: Adapted from community discussion — SV1122
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 531. 1323 questions available.
Version 1.0.0. How we source questions