Question 771 · 1323 in bank
What is a characteristic of a role in Snowflake?
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 is a characteristic of a role in Snowflake?
Answer: D
What command would a user execute to load unstructured data files into a Snowflake internal stage?
Answer: A
Copy into command will load data from stage to a table. Data needs to be in stage already. In this case, I think I woul go with A. PUT. COPY INTO Loads data from staged files to an existing table. The files must already be staged in one of the following locations: Named internal stage, Named external stage. To load data from our local machine into the Snowflake Internal stage: 2. Using PUT command, copy the files from the local folder into snowflake internal stage created in earlier step.
Source: Adapted from community discussion — bibisa
How do managed access schemas help with data governance?
Answer: B
B is correct answer With managed access schemas, object owners lose the ability to make grant decisions. Only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant privileges on objects in the schema, including future grants, centralizing privilege management.
Source: Adapted from community discussion — qiyan1982
What is the default period of time the Warehouse Activity section provides a graph of Snowsight activity?
Answer: C
The correct Answer is C Warehouse Activity The Warehouse Activity section provides a graph of activity over a period of time: Hour Day Week 2 Weeks (default) https://docs.snowflake.com/en/user-guide/ui-snowsight-admin#warehouse-activity
Source: Adapted from community discussion — BobFar
A Snowflake user wants to unload data from a relational table sized 5 GB using CSV. The extract needs to be as performant as possible. What should the user do?
Answer: D
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages.
Source: Adapted from community discussion — bibisa
How is the MANAGE GRANTS privilege applied?
Answer: A
In general, a role with any one of the following sets of privileges can grant privileges on an object to other roles: The global MANAGE GRANTS privilege. Only the SECURITYADMIN and ACCOUNTADMIN system roles have the MANAGE GRANTS privilege; however, the privilege can be granted to custom roles.
Source: Adapted from community discussion — bibisa
What is required for a query execution to be served from the result cache?
Answer: B
Which Snowflake URL type is used by directory tables?
Answer: A
Conceptually, directory tables are similar to external tables in that they store file-level metadata about the data files in a stage. Query a directory table to retrieve the Snowflake-hosted file URL to each file in the stage. A file URL permits prolonged access to a specified file. That is, the file URL does not expire. The same file URL is returned by calling the BUILD_STAGE_FILE_URL function.
Source: Adapted from community discussion — bibisa
Which of the following DML commands isn't supported by Snowflake?
Answer: A
There is nothing called UPSERT in snowflake. MERGE = UPDATE+INSERT+DELETE. Also, unlike other databases TRUNCATE is considered DML in snowflake.
Source: Adapted from community discussion — arpit_dataguy
At which point is data encrypted when using a PUT command?
Answer: C
Put command means the customer is loading from the user’s local machine into an internal stage via the Snowflake client (SnowSQL). If the stage is an internal (i.e. Snowflake) stage data files are automatically encrypted by the Snowflake client on the user’s local machine prior to being transmitted to the internal stage, in addition to being encrypted after they are loaded into the stage. https://docs.snowflake.com/user-guide/security-encryption-end-to-end
Source: Adapted from community discussion — OTE
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 771. 1323 questions available.
Version 1.0.0. How we source questions