- All Exams Instant Download
When would you usually consider to add clustering key to a table
When would you usually consider to add clustering key to a tableA . The performance of the query has deteriorated over a period of time. B. The number of users querying the table has increased C. it is a multi-terabyte size table D. The table has more than 20 columnsView...
Which of the following are characteristics of Snowflake’s parameter hierarchy?
Which of the following are characteristics of Snowflake’s parameter hierarchy?A . Session parameters override virtual warehouse parameters. B. Virtual warehouse parameters override user parameters. C. Table parameters override virtual warehouse parameters. D. Schema parameters override account parameters.View AnswerAnswer: A
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....
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...
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;
A user can change object parameters using which of the following roles?
A user can change object parameters using which of the following roles?A . ACCOUNTADMIN, SECURITYADMIN B. SYSADMIN, SECURITYADMIN C. ACCOUNTADMIN, USER with PRIVILEGE D. SECURITYADMIN, USER with PRIVILEGEView AnswerAnswer: A
