- All Exams Instant Download
To meet this requirement, the user’s role must have which privileges?
An Architect needs to allow a user to create a database from an inbound share. To meet this requirement, the user’s role must have which privileges? (Choose two.)A . IMPORT SHARE;B . IMPORT PRIVILEGES;C . CREATE DATABASE;D . CREATE SHARE;E . IMPORT DATABASE;View AnswerAnswer: C, E Explanation: According to the...
To meet these requirements, which design elements must be implemented?
An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows: 1) Use Tri-Secret Secure in Snowflake 2) Share some information stored in a view with another Snowflake customer 3) Hide portions of sensitive information from some columns...
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?A . External tableB . Materialized viewC . Search optimizationD . Result cacheView AnswerAnswer: B Explanation: A materialized view is a feature that provides the capability to define an alternate cluster key...
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...
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...
Which commands should the Architect use to load only file5.csv file from the stage?
An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously....
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...
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...
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?
When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?A . All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.B . Any rows...
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...
