- All Exams Instant Download
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...
Which copy INTO command outputs the data into one file?
Which copy INTO command outputs the data into one file?A . SINGLE=TRUEB . MAX_FILE_NUMBER=1C . FILE_NUMBER=1D . MULTIPLE=FAISEView AnswerAnswer: B Explanation: The COPY INTO command in Snowflake can be configured to output data into a single file by setting the MAX_FILE_NUMBER option to 1. This option limits the number of...
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: The auto-suspend...
