- All Exams Instant Download
Which of the following security and governance tools/technologies are known to provide native connectivity to Snowflake? [Select 2]
Which of the following security and governance tools/technologies are known to provide native connectivity to Snowflake? [Select 2]A . ALTRB . BaffleC . BIG SquidD . DataikuE . ZeplView AnswerAnswer: A, B Explanation: Security and governance tools ensure sensitive data maintained by an organization is protected from inappropriate access and...
Which option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards?A . He...
He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?
Stuart, a Lead Data Engineer in MACRO Data Company created streams on set of External tables. He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?A . MAX_DATA_EXTENSION_TIME_IN_DAYSB . DATA_RETENTION_TIME_IN_DAYSC . DATA_EXTENSION_TIME_IN_DAYSD . None of...
Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table...
What action he can take to recover the dropped Share?
Ryan, a Data Engineer, accidently drop the Share named SF_SHARE which results in immediate access revoke for all the consumers (i.e., accounts who have created a database from that SF_SHARE). What action he can take to recover the dropped Share?A . By Executing UNDROP command he could possibly recover the...
For enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks, which two glob-al/account privileges snowflake provide?
For enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks, which two glob-al/account privileges snowflake provide?A . CREATE SHAREB . IMPORT SHAREC . REFERENCE USAGED . OPERATEView AnswerAnswer: A, B Explanation: CREATE SHARE In a provider account, this privilege enables creating and managing shares (for sharing data with consumer accounts). IMPORT...
Which option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards?A . He...
print(cur.sfqid)
print(cur.sfqid) B. When he used the Snowflake Connector for Python to execute a query, he can access the query ID through the pyqueryid attribute in the Cursor object. C. He needs to query history views to get the queryID as best practices. D. Using python connector, snowflake does not support...
Which connector creates the RECORD_CONTENT and RECORD_METADATA columns in the existing Snowflake table while connecting to Snowflake?
Which connector creates the RECORD_CONTENT and RECORD_METADATA columns in the existing Snowflake table while connecting to Snowflake? A. Python Connector B. Spark Connector C. Node.js connector D. Kafka ConnectorView AnswerAnswer: D Explanation: Apache Kafka software uses a publish and subscribe model to write and read streams of records, similar to...
Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table...
