- All Exams Instant Download
How did Snowflake fulfill this query?
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?A . Query against the result set cache B. Query against a virtual warehouse cache C. Query against the most-recently created micro-partition D. Query against the metadata...
Which statement about billing applies to Snowflake credits?
Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimum B. Credits are used to pay for cloud data storage usage C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs D. Credits are consumed...
Which SQL command should be used to validate which data was loaded into the stage?
A user has unloaded data from Snowflake to a stage Which SQL command should be used to validate which data was loaded into the stage?A . list @file__stage B. show @file__stage C. view @file__stage D. verify @file__stageView AnswerAnswer: A
What SQL command would be used to view all roles that were granted to user.1?
What SQL command would be used to view all roles that were granted to user.1?A . show grants to user USER1; B. show grants of user USER1; C. describe user USER1; D. show grants on user USER1;View AnswerAnswer: A
Which Snowflake partner specializes in data catalog solutions?
Which Snowflake partner specializes in data catalog solutions?A . Alation B. DataRobot C. dbt D. TableauView AnswerAnswer: A Explanation: Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise. https://docs.snowflake.com/en/user-guide/ecosystem-all.html
What is the purpose of an External Function?
What is the purpose of an External Function?A . To call code that executes outside of Snowflake B. To run a function in another Snowflake database C. To share data in Snowflake with external parties D. To ingest data from on-premises data sourcesView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/sql-reference/external-functions.html
Which feature is only available in the Enterprise or higher editions of Snowflake?
Which feature is only available in the Enterprise or higher editions of Snowflake?A . Column-level security B. SOC 2 type II certification C. Multi-factor Authentication (MFA) D. Object-level access controlView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/intro-editions.html
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)A . Data can be filtered by an optional where clause B. Incoming data can be joined with other tables C. Columns can be reordered D. Columns can be omitted E. Row level access...
Which statements will provide this access?
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access? A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE; B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;...
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Which services does the Snowflake Cloud Services layer manage? (Select TWO).A . Compute resources B. Query execution C. Authentication D. Data storage E. MetadataView AnswerAnswer: C,E Explanation: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different...
