- All Exams Instant Download
How Data Engineer can do Monitoring of Files which are Staged Internally during Continuous data pipelines loading process? [Select all that apply]
How Data Engineer can do Monitoring of Files which are Staged Internally during Continuous data pipelines loading process? [Select all that apply]A . She Can Monitor the files using Metadata maintained by Snowflake i.e. file-name,last_modified date etc.B . Snowflake retains historical data for COPY INTO commands executed within the previous...
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...
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...
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...
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...
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...
When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions?
When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions?A . FALSEB . TRUEView AnswerAnswer: B Explanation: When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake...
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?A . TRUEB . FALSEView AnswerAnswer: A Explanation: The CREATE EXTERNAL TABLE syntax for manually added partitions is...
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...
