- All Exams Instant Download
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
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
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 of the below approach results in perfromance improvement through linear scaling of data ingestion workload?
Which of the below approach results in perfromance improvement through linear scaling of data ingestion workload?A . Split large files into recommended range of 10 MB to 100 MB B. Organize data by granular path C. Resize virtual warehouse D. All of the aboveView AnswerAnswer: D Explanation: When loading your...
What may be the cause of this?
One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage). What may be the cause of this?A . The amount of memory available for the servers used...
Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) only
Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) onlyA . TRUE B. FALSEView AnswerAnswer: A Explanation: The SELECT statement used for transformations does not support all functions. For a complete list of the supported...
Dynamic data masking is supported in which editions of snowflake
Dynamic data masking is supported in which editions of snowflakeA . Enterprise B. VPS C. Business Critical D. StandardView AnswerAnswer: A,B,C Explanation: Support for Dynamic masking is available in enterprise edition and above
You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS.
You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS. What feature of Snowflake is the most appropriate to useA . Materialized View B. SnowPipe C. Secure ViewView AnswerAnswer: B Explanation: Snowpipe is Snowflake’s...
Which copy options are not supported by CREATE PIPE...AS COPY FROM command?
Which copy options are not supported by CREATE PIPE...AS COPY FROM command?A . FILES = ( 'file_name1' [ , 'file_name2', ... ] ) B. FORCE = TRUE | FALSE C. ON_ERROR = ABORT_STATEMENT D. VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS E. MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONEView AnswerAnswer:...
Loading data using snowpipe REST API is supported for external stage only
Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:
