- All Exams Instant Download
Which mode will you use for the warehouse?
You will be using a multi cluster warehouse. You will statically control the available resources (i.e. servers) and you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly. Which mode will you use for the warehouse?A . Maximized B. Auto-Scale C. MinimizedView AnswerAnswer:...
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
Multi-cluster warehouses are best utilized for
Multi-cluster warehouses are best utilized forA . Scaling resources to improve concurrency for users/queries B. Improving the performance of slow-running queries C. Improving the performance of data loadingView AnswerAnswer: A Explanation: Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries. They are not as beneficial for...
Which of the two are limitations of the insertReport API of SnowPipe?
Which of the two are limitations of the insertReport API of SnowPipe?A . The 10,000 most recent events are retained B. Events are retained for a maximum of 10 minutes C. Events are retained for a maximum of 24 hoursView AnswerAnswer: A,B Explanation: Endpoint: insertReport Retrieves a report of files...
When does a multi-cluster warehouse shuts down with default scaling policy
When does a multi-cluster warehouse shuts down with default scaling policyA . Immediately after the query is run B. After 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up...
All multi cluster warehouses that were using the Legacy policy now use the default Standard policy
All multi cluster warehouses that were using the Legacy policy now use the default Standard policyA . TRUE B. FALSEView AnswerAnswer: A Explanation: A third scaling policy, Legacy, was provided for backward compatibility. In contrast to the other policies, it used a static approach based on length of time a...
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:
CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?
You have create a table in snowflake as below CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?A . VARCHAR(10) B. VARCHAR C. VARCHAR(16777216) D. STRINGView AnswerAnswer: C Explanation: Please run these commands in snowflake and...
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 . MERGE B. CREATE/DROP/ALTER TABLE C. ALTER SCHEMA D. SELECT WITH JOIN E. SELECT WITH GROUP BY F. INSERT INTOView AnswerAnswer: D,E Explanation: This is a trick question:) remember a share is read only, so you can only...
Select the true statement
Select the true statementA . Privileges are granted to roles. Roles are granted to users B. Privileges are granted to users. Users are granted to roles C. Privileges are granted to both roles and usersView AnswerAnswer: A Explanation: Privileges are granted to roles, and roles are granted to users, to...
