COF-C01 V1

Which statement best describes Snowflake tables?A . Snowflake tables are logical representations of underlying physical dataB . Snowflake tables ate the physical instantiation of data loaded Into SnowflakeC . Snowflake tables require that clustering keys be defined to perform optimallyD . Snowflake tables are owned by a userView AnswerAnswer: A...

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . InformaticaB . Power BlC . AdobeD . Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

The FLATEEN function is used to query which type of data in Snowflake?A . Structured dataB . Semi-structured dataC . Both of the aboveD . None of the aboveView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by...

Which of the following statements would be used to export/unload data from Snowflake?A . COPY INTO @stageB . EXPORT TO @stageC . INSERT INTO @stageD . EXPORT_TO_STAGE (stage = > @Wage, select = > 'select * from t1);View AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?A . Organize files into logical pathsB . Store the files on the external stage to ensure caching is maintainedC . Use pattern matching for regular expression executionD . Load the...

Which Snowflake partner specializes in data catalog solutions?A . AlationB . DataRobotC . dbtD . 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

True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.A . TrueB . FalseView AnswerAnswer: B

What privileges are required to create a task?A . The global privilege create task is required to create a new task.B . Tasks are created at the Application level and can only be created by the Account Admin role.C . Many Snowflake DDLs are metadata operations only, and create task...

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html