- All Exams Instant Download
Directly querying a file from the stage
Directly querying a file from the stageA . 1,2,3,4 B. 4,3,2,1 C. 1,2,4,3 D. 3,2,4,1View AnswerAnswer: A
For authentication, snowflake Kafka connector relies on:
For authentication, snowflake Kafka connector relies on:A . key pair authentication B. username/password C. Both key pair authentication and username/passwordView AnswerAnswer: A Explanation: Using Key Pair Authentication The Kafka connector relies on key pair authentication rather than the typical username/password authentication. This authentication method requires a 2048-bit (minimum) RSA key...
Snowflake includes administration settings for resource consumption in order to
Snowflake includes administration settings for resource consumption in order toA . Help control costs associated with unexpected credit usage of data B. Manage access to data warehouses for specific users C. Maintain data availabilityView AnswerAnswer: A Explanation: To help control costs and avoid unexpected credit usage caused by running warehouses,...
Snowflake supports the following query performance optimizing methods
Snowflake supports the following query performance optimizing methodsA . Caching techniques B. Retrieving results of previous query from cache C. B-tree type indexesView AnswerAnswer: A,B Explanation: Snowflake does not have any support for indexes yet.
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.A . TRUE B. FALSEView AnswerAnswer: A Explanation: Some of the internal optimizations for views require access to the underlying data in the base tables for the view....
{"stuId":2000,"stuCourse":"Snowflake"}
{"stuId":2000,"stuCourse":"Snowflake"} How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2A . with stu_demography as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000, "stuName":"Amy"}')), B. stu_course as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case...
Which is that role?
This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database. Which is that role?A . IMPORTED PRIVILEGES B. SHARED PRIVILEGES C. IMPORT SHAREView AnswerAnswer: A Explanation: IMPORTED PRIVILEGES Grants ability to enable roles other than the owning...
Which of the two are limitations of the insertReport API of SnowPipe?
Which of the two are limitations of the insertReport API of SnowPipe?A . The 10,000 most recent events are retained B. Events are retained for a maximum of 10 minutes C. Events are retained for a maximum of 24 hoursView AnswerAnswer: A,B Explanation: Endpoint: insertReport Retrieves a report of files...
Where can you define the file format settings?
Where can you define the file format settings?A . While creating named file formats B. In the table definition C. In the named stage definition D. Directly in the COPY INTO TABLE statement when loading dataView AnswerAnswer: A,B,C,D Explanation: Snowflake supports creating named file formats, which are database objects that...
What will be recommended approach for deletion?
You want to automatically delete the files from stage after a successful load using the COPY INTO command. What will be recommended approach for deletion?A . Set PURGE=TRUE in the COPY INTO command B. Set REMOVE=TRUE in the COPY INTO Command C. No need to do anything, snowflake does it...
