- All Exams Instant Download
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:A . Scaling rhythmicallyB . Scaling maxC . Scaling outD . Scaling upView AnswerAnswer: D
Fail-safe is unavailable on which table types?
Fail-safe is unavailable on which table types?A . TemporaryB . TranslentC . ProvisionalD . PermanentView AnswerAnswer: A,B
Which of the following statements is true of data loading?
Which of the following statements is true of data loading?A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fastB . The "deal file size for loading is 16MB to match micro-partition sizeC . Marry files in the 10-lOOMB range tend to land...
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?A . DatabaseB . TablesC . WarehousesD . WorksheetsView AnswerAnswer: A,C,D
As a best practice, clustering keys should only be defined on tables of which minimum size?
As a best practice, clustering keys should only be defined on tables of which minimum size?A . Multi-Kilobyte (KB) RangeB . Multi-Megabyte (MB) RangeC . Multi-Gigabyte (GB) RangeD . Multi-Terabyte (TB) RangeView AnswerAnswer: D
Data storage for individual tables can be monitored using which commands and/or object(s)?
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answersA . SHOW TABLES;B . SHOW STORAGE BY TABLE;C . Information Schema -> TABLE_STORAGE_METRICSD . Information Schema -> TASLE_HISTORYView AnswerAnswer: A,D
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.A . TrueB . FalseView AnswerAnswer: B
What is the recommended method for loading data into Snowflake?
What is the recommended method for loading data into Snowflake?A . Load row by rowB . Load data in batchC . Load data by writing it In the Snowflake Web Interface (UI)D . Load data via frequent, angle row DML'sView AnswerAnswer: B
In which layer of its architecture does Snowflake store its metadata statistics?
In which layer of its architecture does Snowflake store its metadata statistics?A . Storage LayerB . Compute LayerC . Database LayerD . Cloud Service LayerView AnswerAnswer: D
When creating a user it is advisable sable to: Choose 2 answers
When creating a user it is advisable sable to: Choose 2 answersA . Set the user to be initially disabledB . Force an immediate password changeC . Set a default role for the userD . Set the number of minutes to unlock to 15 minutesE . Set the users access...
