- All Exams Instant Download
What will the below query return
What will the below query return SELECT TOP 10 GRADES FROM STUDENT;A . The top 10 highest grades B. The 10 lowest grades C. Non-deterministic list of 10 gradesView AnswerAnswer: C Explanation: An ORDER BY clause is not required; however, without an ORDER BY clause, the results are non-deterministic because...
How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?
An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group’s manager (ORDER_MANAGER) has full DELETE privileges on the table. How can the ORDER_ADMIN role...
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)A . Choose columns that are frequently used in join predicates. B. Choose lower cardinality columns to support clustering keys and cost effectiveness. C. Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows. D....
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)A . Extended Time Travel (up to 90 days) B. Customer-managed encryption keys through Tri-Secret Secure C. Periodic rekeying of encrypted data D. AWS, Azure, or Google Cloud private connectivity to Snowflake...
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:
Which command below will load data from result_scan to a table?
Which command below will load data from result_scan to a table?A . CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from table(result_scan(last_query_id())); B. CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from result_scan(last_query_id()); C. INSERT INTO STORE_FROM_RESULT_SCAN select * from result_scan(last_query_id());View AnswerAnswer: A Explanation: RESULT_SCAN is a system defined table...
What is a valid object hierarchy when building a Snowflake environment?
What is a valid object hierarchy when building a Snowflake environment?A . Account --> Database --> Schema --> Warehouse B. Organization --> Account --> Database --> Schema --> Stage C. Account --> Schema > Table --> Stage D. Organization --> Account --> Stage --> Table --> ViewView AnswerAnswer: B
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 execute B. Only if the system estimates there’s enough query load...
According to Snowflake recommended best practice, how should these requirements be met?
A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors. The company’s Snowflake Architects need to design a solution that would allow the...
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULLA . An error is returned and no changes are applied to the column B. Snowflake automatically assigns a default value and let the change happen C. Snowflake drops the row and...
