- All Exams Instant Download
You have created a reader account for sharing data. who will pay for the compute usage of the account
You have created a reader account for sharing data. who will pay for the compute usage of the accountA . Provider B. ConsumerView AnswerAnswer: A Explanation: Reader account is a way to share data with stakeholders who do not have any snowflake account. They will use providers warehouse for compute.
What is the data size limit for loading into a variant column?
What is the data size limit for loading into a variant column?A . 16 MB(Compressed) B. 1 GB(Compressed) C. 32 GB D. 10 MB - 100 MB compressedView AnswerAnswer: A
Who can provide permission to EXECUTE TASK?
Who can provide permission to EXECUTE TASK?A . ACCOUNTADMIN B. THE TASK OWNER C. SYSADMINView AnswerAnswer: A Explanation: If the role does not have the EXECUTE TASK privilege, assign the privilege as an account administrator (user with the ACCOUNTADMIN role), e.g.: use role accountadmin; grant execute task on account to...
Which of the below objects cannot be replicated from one region to the other?
Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated
Snowflake includes administration settings for resource consumption in order to
Snowflake includes administration settings for resource consumption in order toA . Help control costs associated with unexpected credit usage of data B. Manage access to data warehouses for specific users C. Maintain data availabilityView AnswerAnswer: A Explanation: To help control costs and avoid unexpected credit usage caused by running warehouses,...
You have a table named JSON_TBL which has a variant column JSON_VAR. The json stored in that table looks as below
You have a table named JSON_TBL which has a variant column JSON_VAR. The json stored in that table looks as below { "COURSE_DESC": "SNOWFLAKE CERTIFICATION", "COURSE_ID": 1000, "DURATION": 2 } if you run a query SELECT JSON_VAR:Course_id FROM JSON_TBL; what will it returnA . NULL B. 1000 C. 2View AnswerAnswer:...
Which are those?
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENT B. RECORD_METADATA C. 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:
Snowflake has row level security
Snowflake has row level securityA . TRUE B. FALSEView AnswerAnswer: A Explanation: The below is an old Explanation: -------------- Currently row level security is not available in Snowflake. There is a work around to achieve this using views and permissions. New Explanation: ------- Snowflake has introduced row level security now....
Which option will you choose to setup the access?
Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only. Which option will you choose...
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: D Explanation: Try this your self CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); INSERT INTO SNOWFLAKE VALUES(1111,...
