- All Exams Instant Download
If the user loads this column data into another column that does not have a masking policy, what will occur?
A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?A . Unmasked data will be loaded in the new column.B . Masked data will be loaded into...
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...
