- All Exams Instant Download
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove partitions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?A . TRUEB . FALSEView AnswerAnswer: A Explanation: The CREATE EXTERNAL TABLE syntax for manually added partitions is...
Streams cannot be created to query change data on which of the following objects? [Select All that Apply]
Streams cannot be created to query change data on which of the following objects? [Select All that Apply]A . Standard tables, including shared tables.B . Views, including secure viewsC . Directory tablesD . Query Log TablesE . External tablesView AnswerAnswer: B,D,E Explanation: Streams capture DML changes (INSERT, UPDATE, DELETE) made...
Does High average_overlaps indicates well organized Clustering?
SYSTEM$CLUSTERING_INFORMATION functions returns clustering information, including average clustering depth, for a table based on one or more columns in the table. The function returns a JSON object containing average_overlaps name/value pairs. Does High average_overlaps indicates well organized Clustering?A . YESB . NOView AnswerAnswer: B Explanation: Higher the avg_overlap indicates poorly...
He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?
Stuart, a Lead Data Engineer in MACRO Data Company created streams on set of External tables. He has been asked to extend the data retention period of the stream for 90 days, which parameter he can utilize to enable this extension?A . MAX_DATA_EXTENSION_TIME_IN_DAYSB . DATA_RETENTION_TIME_IN_DAYSC . DATA_EXTENSION_TIME_IN_DAYSD . None of...
Which option he can choose to remove these files either during data loading or afterwards?
To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards? A. He...
