- All Exams Instant Download
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?A . The Connector only works in Snowflake regions that use AWS infrastructure.B . The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.C . The Connector creates and manages its...
What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?
A company’s client application supports multiple authentication methods, and is using Okta. What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?A . 1) OAuth (either Snowflake OAuth or External OAuth) 2) External browser 3) Okta native authentication 4) Key Pair Authentication, mostly used...
What would cause this to occur?
A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schema. One of the requirements is to have online recovery of data on a rolling 7-day basis. After setting up the...
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)A . Shared databases are read-only.B . Shared databases must be refreshed in order for new data to be visible.C . Shared databases cannot be cloned.D . Shared databases are...
Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?
The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?A . The warehouse MY_WH will be made active every five minutes to check the stream.B . The warehouse...
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...
the Principle of Least Privilege?
An Architect entered the following commands in sequence: USER1 cannot find the table. Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)A . GRANT ROLE PUBLIC TO ROLE INTERN;B . GRANT USAGE ON DATABASE...
What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)
What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)A . The MERGE commandB . The UPSERT commandC . The CHANGES clauseD . A STREAM objectE . The CHANGE_DATA_CAPTURE commandView AnswerAnswer: A, D Explanation: In Snowflake, the change tracking metadata for a table is...
How can this query be interpreted?
An Architect runs the following SQL query: How can this query be interpreted?A . FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.B . FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.C . FILEROWS is a file. FILE_ROW_NUMBER is the file format location.D . FILERONS...
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...
