- All Exams Instant Download
How do you access or use tables in the unity catalog?
How do you access or use tables in the unity catalog?A . schema_name.table_nameB . schema_name.catalog_name.table_nameC . catalog_name.table_nameD . catalog_name.database_name.schema_name.table_nameE . catalog_name.schema_name.table_nameView AnswerAnswer: E Explanation: The answer is catalog_name.schema_name.table_name Graphical user interface, diagram Description automatically generated Note: Database and Schema are analogous they are interchangeably used in the Unity catalog. FYI,...
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
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...
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 asked to setup an AUTO LOADER to process the incoming data, this data arrives in JSON format and get dropped into cloud object storage and you are required to process the data as soon as it arrives in cloud storage, which of the following statements is correct
You are asked to setup an AUTO LOADER to process the incoming data, this data arrives in JSON format and get dropped into cloud object storage and you are required to process the data as soon as it arrives in cloud storage, which of the following statements is correctA ....
You were asked to setup a new all-purpose cluster, but the cluster is unable to start which of the following steps do you need to take to identify the root cause of the issue and the reason why the cluster was unable to start?
You were asked to setup a new all-purpose cluster, but the cluster is unable to start which of the following steps do you need to take to identify the root cause of the issue and the reason why the cluster was unable to start?A . Check the cluster driver logsB...
as total_sales from sales
as total_sales from salesView AnswerAnswer: C Explanation: The answer is
table(table_name))
table(table_name))A . format, checkpointlocation, schemalocation, overwriteB . cloudfiles.format, checkpointlocation, cloudfiles.schemalocation, overwriteC . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchemaD . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, overwriteE . cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, appendView AnswerAnswer: C Explanation: The answer is cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchema. Here is the end to end syntax of streaming ELT, below link contains complete...
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...
