- All Exams Instant Download
Which of the following are common use cases for zero-copy cloning? Choose 3 answers
Which of the following are common use cases for zero-copy cloning? Choose 3 answersA . Quick provisioning of Dev and Test/QA environmentsB . Data backupsC . Point in time snapshotsD . Performance optimizationView AnswerAnswer: A,B,C Explanation: Reference: https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning
Which object allows you to limit the number of credits consumed within a Snowflake account?
Which object allows you to limit the number of credits consumed within a Snowflake account? Select one.A . Account usage TrackingB . Resource MonitorC . Warehouse Limit ParameterD . Credit Consumption TrackerView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/resource-monitors.html
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)A . Growth of storage and compute are tightly coupled togetherB . Storage expands without the requirement to add more computeC . Compute can be scaled up or down without the requirement...
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)A . Is available to all Snowflake EditionsB . Is only available to customers with Business Critical EditionC . Restricts or enables access to specific IP addressesD . Is activated using an “ALTER DATABASE” commandView AnswerAnswer: A,C Explanation:...
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/
What command is used to load files into an Internal Stage within Snowflake? Select one.
What command is used to load files into an Internal Stage within Snowflake? Select one.A . PUTB . COPY INTOC . TRANSFERD . INSERTView AnswerAnswer: A
The number of queries that a Warehouse can concurrently process is determined by: Choose 2 answers
The number of queries that a Warehouse can concurrently process is determined by: Choose 2 answersA . The complexity of each queryB . The CONCURRENT_QUERY_UMIT parameter set on the Snowflake accountC . The size of the data required for each queryD . The tool that s executing the queryView AnswerAnswer:...
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: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Which item in the Data Warehouse migration process does not apply in Snowflake>
Which item in the Data Warehouse migration process does not apply in Snowflake>A . Migrate UsersB . Migrate SchemasC . Migrate IndexesD . Build the Data pipelineView AnswerAnswer: C
True or False: The COPY command must specify a File Format in order to execute.
True or False: The COPY command must specify a File Format in order to execute.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-into-snowflake/
