Which SQL command can be used to see the CREATE definition of a masking policy?
A. SHOW MASKING POLICIES
B. DESCRIBE MASKING POLICY
C. GET_DDL
D. LIST MASKING POLICIES
How can a row access policy be applied to a table or a view? (Choose two.)
A. Within the policy DDL
B. Within the create table or create view DDL
C. By future APPLY for all objects in a schema
D. Within a control table
E. Using the command ALTER
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
B. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
C. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
D. A user cannot specify a default warehouse when using the ODBC driver.
E. The default virtual warehouse size can be changed at any time.
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
A. The clone always stays in sync with the original table.
B. The clone has better query performance.
C. The clone is created almost instantly.
D. The clone will have time travel history from the original table.
E. The clone saves space by not duplicating storage.
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
A. Row access policies
B. Data masking policies
C. Data encryption
D. Role based access control
How many days is load history for Snowpipe retained?
A. 1 day
B. 7 days
C. 14 days
D. 64 days
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1.
Runs a query that takes 3 minutes to complete
2.
Leaves for 15 minutes
3.
Returns and runs a query that takes 10 seconds to complete
4.
Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?
A. 4 minutes
B. 10 minutes
C. 14 minutes
D. 24 minutes
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 small 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?
A. Compress the file and load the compressed file.
B. Split the file into multiple files in the recommended size range (100 MB-250 MB).
C. Use a larger-sized warehouse.
D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
A. Enterprise
B. Business Critical
C. Standard
D. Virtual Private Snowflake
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
A. Custom Edition
B. Virtual Private Snowflake
C. Business Critical Edition
D. Standard Edition
E. Enterprise Edition
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your SNOWPRO-CORE exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.