- All Exams Instant Download
What data type SNOWFLAKE will assign to column NAME?
You have created a table as below CREATE TABLE TEST_01 (NAME STRING(10)); What data type SNOWFLAKE will assign to column NAME?A . LONGCHARB . STRINGC . VARCHARView AnswerAnswer: C Explanation: Try it yourself Execute the below commands CREATE TABLE TEST_01 (NAME STRING(10)); DESCRIBE TABLE TEST_01;
Which statement is true below?
You have create a task as below CREATE TASK mytask1 WAREHOUSE = mywh SCHEDULE = '5 minute' WHEN SYSTEM$STREAM_HAS_DATA('MYSTREAM') AS INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT'; Which statement is true below?A . If SYSTEM$STREAM_HAS_DATA returns false, the task will be skippedB . If SYSTEM$STREAM_HAS_DATA...
Which of the below operations are allowed on an inbound share data?
Which of the below operations are allowed on an inbound share data?A . MERGEB . CREATE/DROP/ALTER TABLEC . ALTER SCHEMAD . SELECT WITH JOINE . SELECT WITH GROUP BYF . INSERT INTOView AnswerAnswer: D,E Explanation: This is a trick question:) remember a share is read only, so you can only...
Which of the below select query will fail for this table?
You have created a table as below CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); Which of the below select query will fail for this table?A . SELECT * from snowflake;B . SELECT * from Snowflake;C . SELECT * from "snowflake";D . SELECT * FROM "SNOWFLAKE";View AnswerAnswer: D Explanation: SQL identifiers...
What are purposes for creating a storage integration? (Choose three.)
What are purposes for creating a storage integration? (Choose three.)A . Control access to Snowflake data using a master encryption key that is maintained in the cloud provider’s key management service.B . Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud...
What are the MINIMUM object privileges required for the Snowpipe user to execute Snowpipe?
A Data Engineer is designing a near real-time ingestion pipeline for a retail company to ingest event logs into Snowflake to derive insights. A Snowflake Architect is asked to define security best practices to configure access control privileges for the data load for auto-ingest to Snowpipe. What are the MINIMUM...
Which of the following will enable this type of data ingestion?
A company has several sites in different regions from which the company wants to ingest data. Which of the following will enable this type of data ingestion?A . The company must have a Snowflake account in each cloud region to be able to ingest data to that account.B . The...
What are some of the characteristics of result set caches? (Choose three.)
What are some of the characteristics of result set caches? (Choose three.)A . Time Travel queries can be executed against the result set cache.B . Snowflake persists the data results for 24 hours.C . Each time persisted results for a query are used, a 24-hour retention period is reset.D ....
What Snowflake features should be leveraged when modeling using Data Vault?
What Snowflake features should be leveraged when modeling using Data Vault?A . Snowflake’s support of multi-table inserts into the data model’s Data Vault tablesB . Data needs to be pre-partitioned to obtain a superior data access performanceC . Scaling up the virtual warehouses will support parallel processing of new source...
Following objects can be cloned in snowflake
Following objects can be cloned in snowflake A. Permanent table B. Transient table C. Temporary table D. External tables E. Internal stagesView AnswerAnswer: A,B,E Explanation: In Snowflake, the ability to clone objects is an important feature for quickly duplicating the schema and data of various database objects. Here's the capability...
