- All Exams Instant Download
What datatype Snowflake will use for EMPLOYEE_ID?
You have created a table as below CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR); What datatype Snowflake will use for EMPLOYEE_ID?A . FIXED B. INTEGER C. NUMBERView AnswerAnswer: A Explanation: Please try this for yourself. Note that this advanced certification requires working experience, so some of these hands-on will help in...
Which command will you run to list all privileges and roles granted to the role
Which command will you run to list all privileges and roles granted to the roleA . SHOW GRANTS TO ROLE <ROLE NAME> B. SHOW GRANTS ON ROLE <ROLE NAME> C. SHOW GRANTS OF ROLE <ROLE NAME> D. SHOW GRANTS FOR ROLE <ROLE NAME>View AnswerAnswer: A Explanation: Variants SHOW GRANTS ON...
USERADMIN and Security administrators (i.e. users with the SECURITYADMIN role) or higher can create roles.
USERADMIN and Security administrators (i.e. users with the SECURITYADMIN role) or higher can create roles.A . TRUE B. FALSEView AnswerAnswer: A Explanation: ACCOUNTADMIN (aka Account Administrator) Role that encapsulates the SYSADMIN and SECURITYADMIN system-defined roles. It is the top-level role in the system and should be granted only to a...
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?A . Snowpipe loads duplicate data into the source table B. Data loading will fail when the snowpipe...
By executing the 'SHOW TABLES' command, we can list all the tables in all the schemas even if we do not have access to all the tables
By executing the 'SHOW TABLES' command, we can list all the tables in all the schemas even if we do not have access to all the tablesA . TRUE B. FALSEView AnswerAnswer: B Explanation: SHOW TABLES Lists the tables for which you have access privileges, including dropped tables that are...
Schema owner can grant object privileges in a regular schema
Schema owner can grant object privileges in a regular schemaA . TRUE B. FALSEView AnswerAnswer: B Explanation: Another important topic to remember. Please also go through the difference between a managed schema and a regular schema https://docs.snowflake.com/en/user-guide/security-access-control-configure.html#creating-managed-acc ess-schemas
To convert JSON null value to SQL null value, you will use
To convert JSON null value to SQL null value, you will useA . STRIP_NULL_VALUE B. IS_NULL_VALUE C. NULL_IFView AnswerAnswer: A Explanation: STRIP_NULL_VALUE Converts a JSON “null” value to a SQL NULL value. All other variant values are passed unchanged. Please remember this is semi structured data function and is different...
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
How do you validate the data that is unloaded using COPY INTO command
How do you validate the data that is unloaded using COPY INTO commandA . After unloading, load the data into a relational table and validate the rows B. Load the data into a CSV file to validate the rows C. Use validation_mode='RETURN_ROWS'; with COPY commandView AnswerAnswer: C Explanation: Validating Data...
system$stream_has_data('rawstream1') condition returns false, what will happen to the task ?
Create a task and a stream following the below steps. So, when the system$stream_has_data('rawstream1') condition returns false, what will happen to the task ? -- Create a landing table to store raw JSON data. -- Snowpipe could load data into this table. create or replace table raw (var variant); --...
