- All Exams Instant Download
occur?
A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?A . Unmasked data will be loaded in the new column.B . Masked data will be loaded into...
When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)
When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)A . CSVB . XMLC . AvroD . JSONE . ParquetView AnswerAnswer: C, D Explanation: The data formats that are supported for the messages when using the Snowflake Connector for Kafka are Avro and...
What is the MOST cost-effective way to bring this data into a Snowflake table?
A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files are added to the cloud provider. What is the MOST cost-effective way to bring this data into a...
According to Snowflake recommended best practice, how should these requirements be met?
A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors. The company’s Snowflake Architects need to design a solution that would allow the...
Which permission sets must be granted to this role?
There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db...
What is a valid object hierarchy when building a Snowflake environment?
What is a valid object hierarchy when building a Snowflake environment?A . Account --> Database --> Schema --> WarehouseB . Organization --> Account --> Database --> Schema --> StageC . Account --> Schema > Table --> StageD . Organization --> Account --> Stage --> Table --> ViewView AnswerAnswer: B Explanation:...
Which actions can the company take with the inbound share?
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)A . Clone a table from a share.B . Grant modify...
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...
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...
