- All Exams Instant Download
How does a standard virtual warehouse policy work in Snowflake?
How does a standard virtual warehouse policy work in Snowflake?A . It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.B . It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.C...
How can this data be shared?
A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?A . The healthcare company will need to change the institute’s Snowflake edition in the accounts...
Which of the following are characteristics of Snowflake’s parameter hierarchy?
Which of the following are characteristics of Snowflake’s parameter hierarchy?A . Session parameters override virtual warehouse parameters.B . Virtual warehouse parameters override user parameters.C . Table parameters override virtual warehouse parameters.D . Schema parameters override account parameters.View AnswerAnswer: D Explanation: This is the correct answer because it reflects the characteristics...
What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link?
A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity, an Architect performed the following steps: * Confirmed Private Link URLs are working by logging in with a username/password account * Verified...
What Snowflake functionality should be used to meet these requirements?
A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate...
What Snowflake features should be leveraged when modeling using Data Vault?
What Snowflake features should be leveraged when modeling using Data Vault?A . Snowflake’s support of multi-table inserts into the data model’s Data Vault tablesB . Data needs to be pre-partitioned to obtain a superior data access performanceC . Scaling up the virtual warehouses will support parallel processing of new source...
Which of the following will enable this type of data ingestion?
A company has several sites in different regions from which the company wants to ingest data. Which of the following will enable this type of data ingestion?A . The company must have a Snowflake account in each cloud region to be able to ingest data to that account.B . The...
What are some of the characteristics of result set caches? (Choose three.)
What are some of the characteristics of result set caches? (Choose three.)A . Time Travel queries can be executed against the result set cache.B . Snowflake persists the data results for 24 hours.C . Each time persisted results for a query are used, a 24-hour retention period is reset.D ....
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)A . SYSTEM$CLUSTERING_INFORMATIONB . SYSTEM$CLUSTERING_USAGEC . SYSTEM$CLUSTERING_DEPTHD . SYSTEM$CLUSTERING_KEYSE . SYSTEM$CLUSTERING_PERCENTView AnswerAnswer: A, C Explanation: According to the Snowflake documentation, these two system functions are provided by Snowflake to monitor clustering information within a table. A...
What is required to allow data sharing between these two companies?
Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A. What is required to allow data sharing between these two companies? A. Create a pipeline to write shared data to a cloud storage location in the...
