- All Exams Instant Download
Which commands should the Architect use to load only file5.csv file from the stage?
An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously....
What is the data size limit for loading into a variant column?
What is the data size limit for loading into a variant column?A . 16 MB(Compressed) B. 1 GB(Compressed) C. 32 GB D. 10 MB - 100 MB compressedView AnswerAnswer: A
Who can provide permission to EXECUTE TASK?
Who can provide permission to EXECUTE TASK?A . ACCOUNTADMIN B. THE TASK OWNER C. SYSADMINView AnswerAnswer: A Explanation: If the role does not have the EXECUTE TASK privilege, assign the privilege as an account administrator (user with the ACCOUNTADMIN role), e.g.: use role accountadmin; grant execute task on account to...
How does a standard virtual warehouse policy work in Snowflake?
How does a standard virtual warehouse policy work in Snowflake?A . It conserves credits by keeping running clusters fully loaded rather than starting additional clusters. B. It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes....
Which of the following steps MUST be performed for the account PARTNERB to consume data from the MARKET_DB database?
A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company’s business partners has an account named PARTNERB in Azure East US 2 region. For marketing purposes the company has agreed to share...
What are some of the characteristics of result set caches? (Choose three.)
What are some of the characteristics of result set caches? (Choose three.)A . Time Travel queries can be executed against the result set cache. B. Snowflake persists the data results for 24 hours. C. Each time persisted results for a query are used, a 24-hour retention period is reset. D....
Which actions can the company take with the inbound share?
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)A . Clone a table from a share. B. Grant modify...
How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?
How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?A . Create multiple clustering keys for a table. B. Create multiple materialized views with different cluster keys. C. Create super projections that will automatically create clustering. D. Create a clustering key that...
Which of the below objects cannot be replicated from one region to the other?
Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated
What data type SNOWFLAKE will assign to column NAME?
You have created a table as below CREATE TABLE TEST_01 (NAME STRING(10)); What data type SNOWFLAKE will assign to column NAME?A . LONGCHAR B. STRING C. VARCHARView AnswerAnswer: C Explanation: Try it yourself Execute the below commands CREATE TABLE TEST_01 (NAME STRING(10)); DESCRIBE TABLE TEST_01;
