- All Exams Instant Download
Which practice will provide the MOST efficient loading performance?
A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?A . Organize files into logical pathsB . Store the files on the external stage to ensure caching is maintainedC . Use pattern matching for regular expression executionD . Load the...
What is the MOST performant file format for loading data in Snowflake?
What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped)B . ParquetC . CSV (Gzipped)D . ORCView AnswerAnswer: A
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?A . PipeB . External stageC . TaskD . StreamView AnswerAnswer: A Explanation: Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load...
What is the minimum Snowflake edition that provides data sharing?
What is the minimum Snowflake edition that provides data sharing?A . StandardB . PremierC . EnterpriseD . Business Critical EditionView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answersA . Amazon Web ServicesB . Private Virtual CloudC . Oracle CloudD . Microsoft Azure CloudView AnswerAnswer: A,D
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?A . Okta VerifyB . Duo MobileC...
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
Which type of table corresponds to a single Snowflake session?
Which type of table corresponds to a single Snowflake session?A . TemporaryB . TranslentC . ProvisionalD . PermanentView AnswerAnswer: A Explanation: Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist...
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
What happens when a virtual warehouse is resized?
What happens when a virtual warehouse is resized?A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affectedB . When reducing the size of a warehouse the compute resources are removed only when they are no longer...
