- All Exams Instant Download
Which of the following technique can be used to implement fine-grained access control to rows and columns of the Delta table based on the user's access?
Which of the following technique can be used to implement fine-grained access control to rows and columns of the Delta table based on the user's access?A . Use Unity catalog to grant access to rows and columnsB . Row and column access control listsC . Use dynamic view functionsD ....
Data engineering team is required to share the data with Data science team and both the teams are using different workspaces in the same organization which of the following techniques can be used to simplify sharing data across?
Data engineering team is required to share the data with Data science team and both the teams are using different workspaces in the same organization which of the following techniques can be used to simplify sharing data across? *Please note the question is asking how data is shared within an...
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to finish on time, what steps you can take to reduce the amount of time cluster startup time
You are noticing job cluster is taking 6 to 8 mins to start which is delaying your job to finish on time, what steps you can take to reduce the amount of time cluster startup timeA . Setup a second job ahead of first job to start the cluster, so...
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
FROM carts GROUP BY cartId
FROM carts GROUP BY cartId Expected result: cartId items 1 [1,100,200,300,250]A . FLATTEN, COLLECT_UNIONB . ARRAY_UNION, FLATTENC . ARRAY_UNION, ARRAY_DISTINTD . ARRAY_UNION, COLLECT_SETE . ARRAY_DISTINCT, ARRAY_UNIONView AnswerAnswer: D Explanation: COLLECT SET is a kind of aggregate function that combines a column value from all rows into a unique list ARRAY_UNION...
When writing streaming data, Spark’s structured stream supports the below write modes
When writing streaming data, Spark’s structured stream supports the below write modesA . Append, Delta, CompleteB . Delta, Complete, ContinuousC . Append, Complete, UpdateD . Complete, Incremental, UpdateE . Append, overwrite, ContinuousView AnswerAnswer: C Explanation: The answer is Append, Complete, Update •Append mode (default) - This is the default mode,...
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to N
Which of the following SQL statements can be used to update a transactions table, to set a flag on the table from Y to NA . MODIFY transactions SET active_flag = 'N' WHERE active_flag = 'Y'B . MERGE transactions SET active_flag = 'N' WHERE active_flag = 'Y'C . UPDATE transactions...
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_nameB . COPY INTO table_nameC . UPDATE table_nameD . INSERT INTO OVERWRITE table_nameE . INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?
You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?A . AUTO LOADERB . JOBS and TASKSC . SQL EndpointsD...
