Question 96

An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy command. The loading performance is poor.
What changes can be made to Improve the data loading performance?
  • Question 97

    Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)
  • Question 98

    An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.
    What should the Architect do to enable the Snowflake search optimization service on this table?
  • Question 99

    When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?
  • Question 100

    By executing the 'SHOW TABLES' command, we can list all the tables in all the schemas even if we do not have access to all the tables