- All Exams Instant Download
What is the best option?
You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data. What is the best option?A . CREATE TABLE customer_table_other CLONE customer_table B. CREATE TABLE customer_table_other AS SELECT * FROM customer_table C. ALTER TABLE customer_table_other...
Validation mode can take the below options
Validation mode can take the below optionsA . RETURN_<n>_ROWS B. RETURN_ERRORS C. RETURN_ALL_ERRORS D. RETURN_SEVERE_EERORS_ONLYView AnswerAnswer: A,B,C Explanation: VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests...
Which is that role?
This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database. Which is that role?A . IMPORTED PRIVILEGES B. SHARED PRIVILEGES C. IMPORT SHAREView AnswerAnswer: A Explanation: IMPORTED PRIVILEGES Grants ability to enable roles other than the owning...
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 skipped B. If SYSTEM$STREAM_HAS_DATA...
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
When would you usually consider to add clustering key to a table
When would you usually consider to add clustering key to a tableA . The performance of the query has deteriorated over a period of time. B. The number of users querying the table has increased C. it is a multi-terabyte size table D. The table has more than 20 columnsView...
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...
Materialized views based on external tables can improve query performance
Materialized views based on external tables can improve query performanceA . TRUE B. FALSEView AnswerAnswer: A Explanation: Querying data stored external to the database is likely to be slower than querying native database tables; however, materialized views based on external tables can improve query performance. https://docs.snowflake.com/en/user-guide/tables-external-intro.html
Materialized views are recommended for all of the scenarios except
Materialized views are recommended for all of the scenarios exceptA . Query results contain a small number of rows and/or columns relative to the base table B. Query results contain results that require significant processing C. The query is on an external table D. The view’s base table changes frequentlyView...
What may be the issue?
One of your joins is taking a lot of time. The query profile view looks like this. What may be the issue? A . This may be an "exploding join" issue. The query has provided a condition where records from one table match multiple records from another table resulting in...
