[Oct 05, 2023] DEA-C01 Exam Dumps - Snowflake Practice Test Questions [Q62-Q80] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

Q62. By default, a newly-created Custom role is not assigned to any user, nor granted to any other role?

TRUE

FALSE

Q63. The smaller the average depth, the better clustered the table is with regards to the specified column?

TRUE

FALSE

Q64. If the data retention period for a table is less than 90 days, and a stream has not been consumed, Snowflake temporarily extends this period to prevent it from going stale?

TRUE

FALSE

Q65. In efforts to recover the dropped child tables within schema named SCV_SCHEMA by Data Engi-neer, She found that DATA_RETENTION_TIME_IN_DAYS parameter set with value 45 days at Schema level &the data retention period for child tables explicitly set at 85 days. What will happen when she will try to run undrop table command on Child tables to recover them on the 50th day as-suming SCV_SCHEMA is already dropped on 45th day?

To honor the data retention period for child tables, She will ab able to recover the child tables on 50th day as DATA_RETENTION_TIME_IN_DAYS is explicitly set with higher retention value.

When a schema is already dropped, the data retention period for child tables, if explicit-ly set to be different from the retention of the schema, is not honoured. So UNDROP command will fail to run on
50th day for Child tables recovery.

Child tables can be recovered using Fail-Safe SQL commands.

Data Engineer needs to first recover the Schema & then Child tables will automatically be recovered irrespective of Retention Inheritance.

Q66. Which privilege are required on an object (i.e. user or role) with USERADMIN Role can modify the object properties?

OPEARTE

MANAGE GRANTS

OWNERSHIP

MODIFY

Q67. Can the same column be specified in both a Dynamic data masking policy signature and a row ac-cess policy signature at the same time?

YES

NO

Q68. A SQL UDF evaluates an arbitrary SQL expression and returns the result(s) of the expression. Which value type it can returns?

Single Value

A Set of Rows

Scaler or Tabular depend on input SQL expression

Regex

Q69. Which is the non-supportable JavaScript UDF data types?

Integers

String

Binary

Double

Q70. To troubleshoot data load failure in one of your Copy Statement, Data Engineer have Executed a COPY statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS with reference to the set of files he had attempted to load. Which below function can facilitate analysis of the problematic records on top of the Results produced? [Select 2]

RESULT_SCAN

LAST_QUERY_ID

Rejected_record

LOAD_ERROR

Q71. As Data Engineer, you have been asked to access data held in AWS Glacier Deep Archive storage class for Historical Data Analysis, which one is the correct statement to recommend?

You cannot access data held in archival cloud storage classes that requires restoration before it can be retrieved.

Loading data from AWS cloud storage services is supported regardless of the cloud platform that hosts your Snowflake account.

Data can be accessed from External stage using AWS Private link in this case.

We can simply access AWS Glacier Deep Archive storage External Stage data using PUT command.

Upload (i.e. stage) files to your cloud storage account using the tools provided by the cloud storage service.

Q72. Jeff, a Data Engineer, accessing elements in JSON object in its 3 data loading scripts, he unknow-ingly use the upper case while accessing the elements. e.g.
Script 1 –> fruits:apple.sweet
Script 2 –> FRUITS:apple.sweet
Script 3 –> FRUITS:Apple.Sweet
Which are the correct statements?

Script 1 & Script 2 traverse path twill be treated same, but Script 2 will not.

Script 1,2,3 traverse path will treat in same way.

Script 1 & 3 traverse path will be treated in same way.

Script 2&3 traverse path will be same.

Q73. While creating External function, Which Database object required with at least ACCOUNTAD-MIN privileges?

STORAGE Integration

SECURITY Integration

API Integration

None of the above required.

Q74. To view/monitor the clustering metadata for a table, Snowflake provides which of the following system functions?

SYSTEM$CLUSTERING_DEPTH_KEY

SYSTEM$CLUSTERING_KEY_INFORMATION (including clustering depth)

SYSTEM$CLUSTERING_DEPTH

SYSTEM$CLUSTERING_INFORMATION (including clustering depth)

Q75. Search optimization works best to improve the performance of a query when the following condi-tions are true:[Select All that apply]

The table is not clustered.

The table is frequently queried on columns other than the primary cluster key.

Search Query uses Equality predicates (for example, <column_name> = <constant>) OR Predicates that use IN.

Search Query uses Sort Operations.

Q76. Snowflake does not provide which of following set of SQL functions to support retrieving infor-mation about tasks?

SYSTEM$CURRENT_USER_TASK_NAME

TASK_HISTORY

TASK_DEPENDENTS

TASK_QUERY_HISTORY

SYSTEM$TASK_DEPENDENTS_ENABLE

Q77. Which of the below concepts/functions helps while implementing advanced Column-level Security?

CURRENT_ROLE

INVOKER_ROLE

Role Hierarchy

CURRENT_CLIENT

Q78. Data Engineer wants to analyze query performance & looking out for profiling information, He went to Query/Operator Details also called Profile Overview of Query Profile Interface & searching for statistics attributes around I/O. Which of the following information he can’t get from there?

Percentage scanned from cache – the percentage of data scanned from the local disk cache.

Bytes written – bytes written (e.g. when loading into a table).

External bytes scanned – bytes read from an external object, e.g. a stage.

Bytes sent over the wireframe – amount of data sent over the wireframe

Bytes read from result – bytes read from the result object.

Q79. Pascal, a Data Engineer, have requirement to retrieve the 10 most recent executions of a specified task (completed, still running, or scheduled in the future) scheduled within the last hour, which of the following is the correct SQL Code ?

1.select *
2.from table(information_schema.task_history(
3.scheduled_time_range_start=>dateadd(‘hour’,-1,current_timestamp()),
4.result_limit => 10,
5.task_name=>’MYTASK’) WHERE query_id IS NOT NULL);

1.select *
2.from table(information_schema.task_history(
3.scheduled_time_range_start=>dateadd(‘hour’,-1,current_timestamp()),
4.result_limit => 11,
5.task_name=>’MYTASK’) WHERE query_id IS NOT NULL);

1.select *
2.from table(information_schema.task_history(
3.scheduled_time_range_start=>dateadd(‘hour’,-1,current_timestamp()),
4.result_limit => 10,query_id IS NOT NULL
5.task_name=>’MYTASK’));

1.select *
2.from table(information_schema.task_history(
3.scheduled_time_range_start=>dateadd(‘hour’,-1,current_timestamp()),
4.result_limit => 10,
5.task_name=>’MYTASK’));

Q80. Which Role inherits the privileges of the USERADMIN role via the system role hierarchy?

SYSADMIN

SECURITYADMIN

PUBLIC

CUSTOM ROLE