Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 126
How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?
- A: Create transient tables and periodically copy them to permanent tables.
- B: Create temporary tables and periodically copy them to permanent tables.
- C: Create regular tables with extended Time Travel and Fail-safe settings.
- D: Create regular tables with default Time Travel and Fail-safe settings.
Question 127
Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?
- A: SnowSQL
- B: Dashboards
- C: Python worksheets
- D: Provider Studio
Question 128
In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Choose two.)
- A: Implementation of column-level security will optimize query performance.
- B: Column-level security supports encryption of the entire database.
- C: Column-level security ensures that only the table owner can access the data.
- D: Column-level security limits access to specific columns within a table based on user privileges.
- E: Column-level security allows the application of a masking policy to a column within a table or view.
Question 129
How does Snowflake utilize clustering information to improve query performance?
- A: It prunes unnecessary micro-partitions based on clustering metadata.
- B: It compresses the data within micro-partitions for faster querying.
- C: It automatically allocates additional resources to improve query execution.
- D: It organizes clustering information to speed-up data retrieval from storage.
Question 130
How can staged files be removed during data loading once the files have loaded successfully?
- A: Use the DROP command.
- B: Use the PURGE copy option.
- C: Use the FORCE = TRUE parameter.
- D: Use the LOAD_UNCERTAIN_FILES copy option.
Question 131
What objects can be cloned within Snowflake? (Choose two.)
- A: Schemas
- B: Users
- C: External tables
- D: Internal named stages
- E: External named stages
Question 132
What can be used to process unstructured data?
- A: External tables
- B: The COPY INTO [table] command
- C: External functions
- D: Snowpipe
Question 133
Which type of workload is recommended for Snowpark-optimized virtual warehouses?
- A: Workloads with ad hoc analytics
- B: Workloads that have large memory requirements
- C: Workloads with unpredictable data volumes for each query
- D: Workloads that are queried with small table scans and selective filters
Question 134
A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned.
How should this query be optimized?
- A: Create a view on the table.
- B: Add a clustering key to the table.
- C: Add a LIMIT clause to the query.
- D: Add a Dynamic Data Masking policy to the table.
Question 135
Which of the following are options when creating a Virtual Warehouse? (Choose two.)
- A: Auto-suspend
- B: Auto-resume
- C: Local SSD size
- D: User count
Question 136
Which access control entity in Snowflake can be created as part of a hierarchy within an account?
- A: Securable object
- B: Role
- C: Privilege
- D: User
Question 137
When an object is created in Snowflake, who owns the object?
- A: The public role
- B: The user's default role
- C: The current active primary role
- D: The owner of the parent schema
Question 138
What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?
- A: Standard
- B: Enterprise
- C: Business Critical
- D: Virtual Private Snowflake (VPS)
Question 139
Which role is responsible for managing the billing and credit data within Snowflake?
- A: ORGADMIN
- B: ACCOUNTADMIN
- C: SYSADMIN
- D: SECURITYADMIN
Question 140
What can be used to identify the database, schema, stage, and file path to a set of files, and to allow a role that has sufficient privileges on the stage to access the files?
- A: A scoped URL
- B: A file URL
- C: A pre-signed URL
- D: A directory table
Question 141
Which command is used to remove files from either external cloud storage or an internal stage?
- A: DELETE
- B: REMOVE
- C: TRUNCATE
- D: DROP
Question 142
How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column, ID_NUMBER?
- A: TRUNC(ID_NUMBER, -6)
- B: TRUNC(ID_NUMBER, 5)
- C: ID_NUMBER*100
- D: TO_CHAR(ID_NUMBER)
Question 143
While unloading data into a stage, how can the user ensure that the output will be a single file?
- A: Use the COPY option FILES=SINGLE.
- B: Use the COPY option SINGLE=TRUE.
- C: Use the GET option SINGLE=TRUE.
- D: Use the GET option FILES=SINGLE.
Question 144
Which query types will have significant performance improvement when run using the search optimization service? (Choose two.)
- A: Range searches
- B: Equality searches
- C: Substring searches
- D: Queries with IN predicates
- E: Queries with aggregation
Question 145
Which Query Profile operator is considered a DML operator?
- A: ExternalScan
- B: Flatten
- C: Merge
- D: Sort
Question 146
Which formats are supported for unloading data from Snowflake? (Choose two.)
- A: Delimited (CSV, TSV, etc.)
- B: Avro
- C: JSON
- D: ORC
Question 147
Masking policies are created at what level in Snowflake?
- A: Table
- B: Column
- C: Schema
- D: Database
Question 148
What would cause different results to be returned when running the same query twice?
- A: SAMPLE is used and the seed is set.
- B: SAMPLE is used and the seed is not set.
- C: Fraction-based sampling is used.
- D: Fixed-size sampling is used.
Question 149
What are type predicates used for?
- A: Extracting data from a VARIANT column
- B: Casting a value in a VARIANT column to a particular data type
- C: Determining if a value in a VARIANT column is a particular data type
- D: Manipulating objects and arrays in a VARIANT column
Question 150
Which table function is used to perform additional processing on the results of a previously-run query?
- A: QUERY_HISTORY
- B: RESULT_SCAN
- C: DESCRIBE_RESULTS
- D: QUERY_HISTORY_BY_SESSION
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!