- All Exams Instant Download
To convert JSON null value to SQL null value, you will use
To convert JSON null value to SQL null value, you will useA . STRIP_NULL_VALUEB . IS_NULL_VALUEC . NULL_IFView AnswerAnswer: C Explanation: The NULL_IF function in Snowflake is used to compare two expressions, and if they are equivalent, a SQL NULL value is returned. However, when dealing with JSON data and...
Which are those?
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENTB . RECORD_METADATAC . RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:
How can cloning the STAGING schema be achieved?
An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50 days of retention. The Architect runs the following statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The...
To meet this requirement, the user’s role must have which privileges?
An Architect needs to allow a user to create a database from an inbound share. To meet this requirement, the user’s role must have which privileges? (Choose two.)A . IMPORT SHARE;B . IMPORT PRIVILEGES;C . CREATE DATABASE;D . CREATE SHARE;E . IMPORT DATABASE;View AnswerAnswer: A,C
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)A . SYSTEM$CLUSTERING_INFORMATIONB . SYSTEM$CLUSTERING_USAGEC . SYSTEM$CLUSTERING_DEPTHD . SYSTEM$CLUSTERING_KEYSE . SYSTEM$CLUSTERING_PERCENTView AnswerAnswer: A,C
What Snowflake functionality should be used to meet these requirements?
A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate...
What integration object should be used to place restrictions on where data may be exported?
What integration object should be used to place restrictions on where data may be exported?A . Stage integrationB . Security integrationC . Storage integrationD . API integrationView AnswerAnswer: C
Which of the below commands will use warehouse credits?
Which of the below commands will use warehouse credits?A . SHOW TABLES LIKE 'SNOWFL%';B . SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;C . SELECT COUNT(*) FROM SNOWFLAKE;D . SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;View AnswerAnswer: B,C,D Explanation: All the SELECT queries will use warehouse credits because they involve processing data, which requires...
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?A . Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can executeB . Only if the system estimates there’s enough query load...
Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?
An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner. Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?A...
