- All Exams Instant Download
What feature can be used to reorganize a very large table on one or more columns?
What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitionsB . Clustering keysC . Key partitionsD . Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
What is the default File Format used in the COPY command if one is not specified?
What is the default File Format used in the COPY command if one is not specified?A . CSVB . JSONC . ParquetD . XMLView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?A . The primary cluster in the virtual warehouseB . The entire virtual warehouseC . The database in which the virtual warehouse residesD . The Queries currently being run on the virtual warehouseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters %20in%20the%20warehouse.
What is a best practice after creating a custom role?
What is a best practice after creating a custom role?A . Create the custom role using the SYSADMIN role.B . Assign the custom role to the SYSADMIN roleC . Assign the custom role to the PUBLIC roleD . Add__CUSTOM to all custom role namesView AnswerAnswer: B Explanation: When creating roles...
What is a key feature of Snowflake architecture?
What is a key feature of Snowflake architecture?A . Zero-copy cloning creates a mirror copy of a database that updates with the originalB . Software updates are automatically applied on a quarterly basisC . Snowflake eliminates resource contention with its virtual warehouse implementationD . Multi-cluster warehouses allow users to run...
How often are encryption keys automatically rotated by Snowflake?
How often are encryption keys automatically rotated by Snowflake?A . 30 DaysB . 60 DaysC . 90 DaysD . 365 DaysView AnswerAnswer: C
What Snowflake role must be granted for a user to create and manage accounts?
What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMINB . ORGADMINC . SECURITYADMIND . SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
What data is stored in the Snowflake storage layer? (Select TWO).
What data is stored in the Snowflake storage layer? (Select TWO).A . Snowflake parametersB . Micro-partitionsC . Query historyD . Persisted query resultsE . Standard and secure view resultsView AnswerAnswer: B, D
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
