- All Exams Instant Download
Which of the below commands lists all the pipes for which you have access?
Which of the below commands lists all the pipes for which you have access?A . Display Pipes() B. SHOW PIPES() C. LIST PIPES() D. LIST @PIPESView AnswerAnswer: B Explanation: SHOW PIPES Lists the pipes for which you have access privileges. This command can be used to list the pipes for...
If you run the below commands in your worksheet, what will happen?
If you run the below commands in your worksheet, what will happen? CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE STUDENT_TABLE_CLONE CLONE STUDENT_TABLE;A . A temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE B. Only the STUDENT_TABLE_CLONE will be...
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?A . Snowpipe loads duplicate data into the source table B. Data loading will fail when the snowpipe...
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view usesA . TRUE B. FALSEView AnswerAnswer: A Explanation: A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view...
Which command below will only copy the table structure from the existing table to the new table?
Which command below will only copy the table structure from the existing table to the new table?A . CREATE TABLE … AS SELECT B. CREATE TABLE … LIKE C. CREATE TABLE … CLONEView AnswerAnswer: B Explanation: CREATE TABLE … LIKE Creates a new table with the same column definitions as...
How will you resume it?
You have created a TASK in snowflake. How will you resume it?A . No need to resume, the creation operation automatically enables the task B. ALTER TASK mytask1 RESUME; C. ALTER TASK mytask1 START;View AnswerAnswer: B Explanation: It is important to remember that a Task that has just been created...
You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS.
You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS. What feature of Snowflake is the most appropriate to useA . Materialized View B. SnowPipe C. Secure ViewView AnswerAnswer: B Explanation: Snowpipe is Snowflake’s...
COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV
COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSVA . GZIP B. BZ2 C. BROTLI D. ZSTD E. DEFLATE F. RAW_DEFLATEView AnswerAnswer: A,B,D,E,F Explanation: AUTO Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use...
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
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
