- All Exams Instant Download
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,...
Which requirements will be addressed with this approach?
A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)A . There needs to be fewer objects per tenant. B. Security and Role-Based Access...
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScan
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScanA . Reading the last 10 minutes of history every 8 minutes B. Read the last 24 hours of history every minute C. Read the last 7 days of history every hourView AnswerAnswer: A Explanation: This endpoint...
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....
How can this query be interpreted?
An Architect runs the following SQL query: How can this query be interpreted?A . FILEROWS is a stage. FILE_ROW_NUMBER is line number in file. B. FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table. C. FILEROWS is a file. FILE_ROW_NUMBER is the file format location. D. FILERONS...
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,...
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: B,C
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...
