- All Exams Instant Download
What happens when an external or an internal stage is dropped? (Select TWO).
What happens when an external or an internal stage is dropped? (Select TWO).A . When dropping an external stage, the files are not removed and only the stage is droppedB . When dropping an external stage, both the stage and the files within the stage are removedC . When dropping...
Which command can be used to view the list of files that has been uploaded to the staged?
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?A . list @mytable;B . list @%raytable;C . list @ %m.ystage;D . list @mystage;View AnswerAnswer: D
Which stage type can be altered and dropped?
Which stage type can be altered and dropped?A . Database stageB . External stageC . Table stageD . User stageView AnswerAnswer: B
How did Snowflake fulfill this query?
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?A . Query against the result set cacheB . Query against a virtual warehouse cacheC . Query against the most-recently created micro-partitionD . Query against the metadata...
True or False: A Virtual Warehouse can be resized while suspended.
True or False: A Virtual Warehouse can be resized while suspended.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse
Which of the following describes how clustering keys work in Snowflake?
Which of the following describes how clustering keys work in Snowflake?A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.B . Clustering keys sort the designated columns over time, without blocking DML operationsC . Clustering keys create a distributed, parallel data structure...
How long is Snowpipe data load history retained?
How long is Snowpipe data load history retained?A . As configured in the create pipe settingsB . Until the pipe is droppedC . 64 daysD . 14 daysView AnswerAnswer: D
Which of the following statements will return the required information?
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?A . SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;B . SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())C . SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;D ....
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).A . ORCB . XMLC . AvroD . ParquetE . JSONView AnswerAnswer: D, E Explanation: Semi-structured JSON, Parquet https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).A . Materialized viewsB . SequencesC . ProceduresD . TablesE . Secure User Defined Functions (UDFs)View AnswerAnswer: AD
