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?
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?
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
