- All Exams Instant Download
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html
Which are true of Snowflake roles?
Which are true of Snowflake roles?A . All grants to objects are given to roles, and never to usersB . In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operationC . The public role controls at...
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: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
What happens when a Data Provider revokes privileges to a Share on an object in their source database?A . The object immediately becomes unavailable for all Data ConsumersB . Any additional data arriving after this point in time will not be visible to Data ConsumersC . The Data Consumers stop...
True or False: You can query the files in an External Stage directly without having to load the data into a table.
True or False: You can query the files in an External Stage directly without having to load the data into a table.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used...
What command is used to load files into an Internal Stage within Snowflake?
What command is used to load files into an Internal Stage within Snowflake?A . PUTB . COPY INTOC . TRANSFERD . INSERTView AnswerAnswer: A Explanation: You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO...
How many shares can be consumed by single Data Consumer?
How many shares can be consumed by single Data Consumer?A . 1B . 10C . 100, but can be increased by contacting supportD . UnlimitedView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html
How long is Snowpipe data load history retained?
How long is Snowpipe data load history retained?A . As configured in the create pipe settingsB . Until the pipe is droppedC . 64 daysD . 14 daysView AnswerAnswer: C Explanation: Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the...
Which of the following roles is recommended to be used to create and manage users and roles?
Which of the following roles is recommended to be used to create and manage users and roles?A . SYSADMINB . SECURITYADMINC . PUBLICD . ACCOUNTADMINView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"
True or False: All Snowflake table types include fail-safe storage.
True or False: All Snowflake table types include fail-safe storage.A . TrueB . FalseView AnswerAnswer: B
