- All Exams Instant Download
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 Snowflake supports unloading data in several semi-structured file formats, including Parquet and JSON. These formats allow for efficient storage...
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: Virtual Warehouses in Snowflake can indeed be resized while they are suspended. Resizing a warehouse involves changing the number of compute resources (servers) allocated to it, which can be done to adjust...
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryptionB . An HTTPS server with WebDAVC . A Google Cloud storage bucketD . A Windows server file share on AzureView AnswerAnswer: D...
Which of the following statements will accommodate this request?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH. Which of the following statements will accommodate this request?A . ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;B . GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;C . GRANT MODIFY...
Which feature is only available in the Enterprise or higher editions of Snowflake?
Which feature is only available in the Enterprise or higher editions of Snowflake?A . Column-level securityB . SOC 2 type II certificationC . Multi-factor Authentication (MFA)D . Object-level access controlView AnswerAnswer: A Explanation: Column-level security is a feature that allows fine-grained control over access to specific columns within a table....
What are the default Time Travel and Fail-safe retention periods for transient tables?
What are the default Time Travel and Fail-safe retention periods for transient tables?A . Time Travel - 1 day. Fail-safe - 1 dayB . Time Travel - 0 days. Fail-safe - 1 dayC . Time Travel - 1 day. Fail-safe - 0 daysD . Transient tables are retained in neither...
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)A . Via the Snowflake Web Interface (Ul)B . Via the data_share=true parameterC . Via SQL commandsD . Via Virtual WarehousesView AnswerAnswer: A, C Explanation: In Snowflake, Data Shares can be created and managed in two primary...
If the user runs the same copy into command what will happen?
A user has 10 files in a stage containing new customer dat a. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new...
Which SQL command should be used to validate which data was loaded into the stage?
A user has unloaded data from Snowflake to a stage Which SQL command should be used to validate which data was loaded into the stage?A . list @file__stageB . show @file__stageC . view @file__stageD . verify @file__stageView AnswerAnswer: A Explanation: The list command in Snowflake is used to validate and...
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . TrueB . FalseView AnswerAnswer: A Explanation: Provisioning time can vary based on the size of the warehouse. A 4X-Large Warehouse typically has more resources and may take longer to provision compared to...
