True or False: You can define multiple columns within a clustering key on a table.
True or False: You can define multiple columns within a clustering key on a table. A. True B. False
True or False: You can define multiple columns within a clustering key on a table. A. True B. False
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake A. True B. False
What is the default File Format used in the COPY command if one is not specified? A. CSV B. JSON C. Parquet D. XML
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.) A. Users B. Tables C. Databases D. Internal Stages
How would you determine the size of the virtual warehouse used for a task? A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of…
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse. A. True B. False
Which of the following statements would be used to export/unload data from Snowflake? A. COPY INTO @stage B. EXPORT TO @stage C. INSERT INTO @stage P.EXPORT_TO_STAGE(stage => @stage, select => ‘select * from t1’);
What services does Snowflake automatically provide for customers that they may have been responsible for with their on-premise system? (Choose all that apply.) A. Installing and configuring hardware B. Patching software C. Physical security D. Maintaining metadata and statistics
True or False: Once created, a micro-partition will never be changed. A. True B. False
The fail-safe retention period is how many days? A. 1 day B. 7 days C. 45 days D. 90 days