- All Exams Instant Download
What is the recommended file sizing for data loading using Snowpipe?
What is the recommended file sizing for data loading using Snowpipe?A . A compressed file size greater than 100 MB, and up to 250 MBB . A compressed file size greater than 100 GB, and up to 250 GBC . A compressed file size greater than 10 MB, and up...
What data is stored in the Snowflake storage layer? (Select TWO).
What data is stored in the Snowflake storage layer? (Select TWO).A . Snowflake parametersB . Micro-partitionsC . Query historyD . Persisted query resultsE . Standard and secure view resultsView AnswerAnswer: B, D Explanation: The Snowflake storage layer is responsible for storing data in an optimized, compressed, columnar format. This includes...
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.A . TrueB . FalseView AnswerAnswer: B Explanation: The ACCOUNTADMIN role is the most powerful role in Snowflake and should be limited to a select number of users within an...
How long is Snowpipe data load history retained?
How long is Snowpipe data load history retained?A . As configured in the create pipe settingsB . Until the pipe is droppedC . 64 daysD . 14 daysView AnswerAnswer: C Explanation: Snowpipe data load history is retained for 64 days. This retention period allows users to review and audit the...
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?A . The primary cluster in the virtual warehouseB . The entire virtual warehouseC . The database in which the virtual warehouse residesD . The Queries currently being run on the virtual warehouseView AnswerAnswer: B Explanation: The auto-suspend...
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)A . Bytes scannedB . Bytes sent over the networkC . Number of partitions scannedD . Percentage scanned from cacheE . External bytes scannedView AnswerAnswer: A, C Explanation:...
If the user runs the same copy into command what will happen?
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer...
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 command is used to unload data from a Snowflake table into a file in a stage?
Which command is used to unload data from a Snowflake table into a file in a stage?A . COPY INTOB . GETC . WRITED . EXTRACT INTOView AnswerAnswer: A Explanation: The COPY INTO command is used in Snowflake to unload data from a table into a file in a stage....
Which copy INTO command outputs the data into one file?
Which copy INTO command outputs the data into one file?A . SINGLE=TRUEB . MAX_FILE_NUMBER=1C . FILE_NUMBER=1D . MULTIPLE=FAISEView AnswerAnswer: B Explanation: The COPY INTO command in Snowflake can be configured to output data into a single file by setting the MAX_FILE_NUMBER option to 1. This option limits the number of...
