DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Practice Questions

Which of the following cluster configurations is least likely to experience delays due to garbage collection of a large DataFrame? Note: each configuration has roughly the same com...

The code block shown below should return a new DataFrame where column product補tegories only has one word per row, resulting in a DataFrame with many more rows than DataFrame stores...

Which of the following code blocks returns a new DataFrame with column storeReview where the pattern "End" has been removed from the end of column storeReview in DataFrame storesDF...

The code block shown below should return a new DataFrame where rows in DataFrame storesDF containing at least one missing value have been dropped. Choose the response that correctl...

Which of the following operations calculates the simple average of a group of values, like a column?

Which of the following code blocks fails to return the number of rows in DataFrame storesDF for each distinct combination of values in column division and column storeCategory?

The code block shown below contains an error. The code block is intended to return a collection of summary statistics for column sqft in Data Frame storesDF. Identify the error. Co...

The code block shown below should return a 25 percent sample of rows from DataFrame storesDF with reproducible results. Choose the response that correctly fills in the numbered bla...

Which of the following code blocks creates a Python UDF assessPerformanceUDF() using the integer-returning Python function assessPerformance() and applies it to Column customerSati...

The code block shown below contains an error. The code block is intended to create a single- column DataFrame from Python list years which is made up of integers. Identify the erro...

The code block shown below should return a DataFrame containing a column openDateString, a string representation of Java's SimpleDateFormat. Choose the response that correctly fill...

Which of the following operations can be used to perform a left join on two DataFrames?

The code block shown below should return a new DataFrame that is the result of an inner join between DataFrame storesDF and DataFrame employeesDF on column storeId and column emplo...

The code block shown below should return a new DataFrame that is the result of a position-wise union between DataFrame storesDF and DataFrame acquiredStoresDF. Choose the response...

Which of the following code blocks writes DataFrame storesDF to file path filePath as text files overwriting any existing files in that location?

The code block shown below contains an error. The code block is intended to read JSON at the file path filePath into a DataFrame with the specified schema schema. Identify the erro...

Which of the following describes executors?

The code block shown below should return a DataFrame containing only the rows from DataFrame storesDF where the value in column sqft is less than or equal to 25,000 AND the value i...

Which of the following code blocks returns a DataFrame with column storeSlogan where single quotes in column storeSlogan in DataFrame storesDF have been replaced with double quotes...

Which of the following operations can be used to rename and replace an existing column in a DataFrame?

The code block shown below should print the schema of DataFrame storesDF. Choose the response that correctly fills in the numbered blanks within the code block to complete this tas...

The code block shown below contains an error. The code block is intended to create and register a SQL UDF named "ASSESS_PERFORMANCE" using the Python function assessPerformance() a...

Which of the following code blocks attempts to cache the partitions of DataFrame storesDF only in Spark's memory?

Which of the following operations will always return a new DataFrame with updated partitions from DataFrame storesDF by inducing a shuffle?

Which of the following code blocks returns a DataFrame containing a column month, an integer representation of the month from column openDate from DataFrame storesDF? Note that col...

The code block shown below should read a parquet at the file path filePath into a DataFrame. Choose the response that correctly fills in the numbered blanks within the code block t...

Which of the following statements describing a difference between transformations and actions is incorrect?

Which of the following describes why garbage collection in Spark is important?

Which of the following code blocks returns a new DataFrame where column managerNameLength is the number of characters in column managerName in DataFrame storesDF? Assume DataFrame...

Which of the following code blocks returns a DataFrame where rows in DataFrame storesDF containing missing values in every column have been dropped?

The code block shown below contains an error. The code block is intended to return a new DataFrame that is the result of a left join between DataFrame storesDF and DataFrame employ...