- All Exams Instant Download
According to recommended best practice, what should be done to reduce the Queue volume?
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse. According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).A . Use multi-clustered warehousing to scale out...
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 scanned B. Bytes sent over the network C. Number of partitions scanned D. Percentage scanned from cache E. External bytes scannedView AnswerAnswer: A, C
What Snowflake role must be granted for a user to create and manage accounts?
What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMIN B. ORGADMIN C. SECURITYADMIN D. SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
Where would a Snowflake user find information about query activity from 90 days ago?
Where would a Snowflake user find information about query activity from 90 days ago?A . account__usage . query history view B. account__usage.query__history__archive View C. information__schema . cruery_history view D. information__schema - query history_by_ses s i on viewView AnswerAnswer: B
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).A . Load files that are approximately 25 MB or smaller. B. Remove all dates and timestamps. C. Load files that are approximately 100-250 MB (or larger) D. Avoid using embedded characters...
The fail-safe retention period is how many days?
The fail-safe retention period is how many days?A . 1 day B. 7 days C. 45 days D. 90 daysView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Which of the following are benefits of micro-partitioning? (Select TWO)
Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of values B. Micro-partitions are immutable objects that support the use of Time Travel. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses D. Rows are automatically stored...
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html
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 of the following compute resources or features are managed by Snowflake? (Select TWO).
Which of the following compute resources or features are managed by Snowflake? (Select TWO).A . Execute a COPY command B. Updating data C. Snowpipe D. AUTOMATIC__CLUSTERING E. Scaling up a warehouseView AnswerAnswer: A, D
