- All Exams Instant Download
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...
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...
at(timestamp => (select current_timestamp())); Select the Correct Query Execution Output option below:
at(timestamp => (select current_timestamp())); Select the Correct Query Execution Output option below: A. Developer missed to create stream on the source table which can further query to capture DML records. B. Select query will fail with error: 'SQL compilation error-Incorrect Keyword "Chang-es()" found' C. No Error reported, select command gives...
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 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...
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...
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...
Mark the correct statements about Cache?
Mark the correct statements about Cache?A . Materialized views are more flexible than, but typically slower than, cached results.B . Materialized views are faster than tables because of their “cache” (i.e. the query results for the view); in addition, if data has changed, they can use their “cache” for data...
Which Scenario Data engineer decide Materialized views are not useful. Select All that apply.
Which Scenario Data engineer decide Materialized views are not useful. Select All that apply. A. Query results contain a small number of rows and/or columns relative to the base table (the table on which the view is defined). B. Query results contain results that require significant processing. C. The query...
Steven created the task, what additional privileges required by Steven on the task so that he can suspend or resume the tasks?
Steven created the task, what additional privileges required by Steven on the task so that he can suspend or resume the tasks? A. Steven is already owner of the task; he can execute the task & suspend/resume the task without any additional privileges. B. In addition to the task owner,...
