Rate this post

Associate-Developer-Apache-Spark問題集で2022年最新のDatabricks Associate-Developer-Apache-Spark試験問題

無料で使えるAssociate-Developer-Apache-Sparkブレーン問題集でダウンロード(Associate-Developer-Apache-Sparkテスト問題集無料更新された)

新問題 40
The code block displayed below contains an error. The code block should arrange the rows of DataFrame transactionsDf using information from two columns in an ordered fashion, arranging first by column value, showing smaller numbers at the top and greater numbers at the bottom, and then by column predError, for which all values should be arranged in the inverse way of the order of items in column value. Find the error.
Code block:
transactionsDf.orderBy(‘value’, asc_nulls_first(col(‘predError’)))

 
 
 
 
 

新問題 41
The code block shown below should return a column that indicates through boolean variables whether rows in DataFrame transactionsDf have values greater or equal to 20 and smaller or equal to
30 in column storeId and have the value 2 in column productId. Choose the answer that correctly fills the blanks in the code block to accomplish this.
transactionsDf.__1__((__2__.__3__) __4__ (__5__))

 
 
 
 
 

新問題 42
Which of the following describes the characteristics of accumulators?

 
 
 
 
 

新問題 43
Which of the following is not a feature of Adaptive Query Execution?

 
 
 
 
 

新問題 44
In which order should the code blocks shown below be run in order to assign articlesDf a DataFrame that lists all items in column attributes ordered by the number of times these items occur, from most to least often?
Sample of DataFrame articlesDf:
1.+——+—————————–+——————-+
2.|itemId|attributes |supplier |
3.+——+—————————–+——————-+
4.|1 |[blue, winter, cozy] |Sports Company Inc.|
5.|2 |[red, summer, fresh, cooling]|YetiX |
6.|3 |[green, summer, travel] |Sports Company Inc.|
7.+——+—————————–+——————-+

 
 
 
 
 
 

新問題 45
The code block displayed below contains an error. The code block is intended to perform an outer join of DataFrames transactionsDf and itemsDf on columns productId and itemId, respectively.
Find the error.
Code block:
transactionsDf.join(itemsDf, [itemsDf.itemId, transactionsDf.productId], “outer”)

 
 
 
 
 

新問題 46
Which of the following statements about storage levels is incorrect?

 
 
 
 
 

新問題 47
The code block shown below should return a DataFrame with columns transactionsId, predError, value, and f from DataFrame transactionsDf. Choose the answer that correctly fills the blanks in the code block to accomplish this.
transactionsDf.__1__(__2__)

 
 
 
 
 

新問題 48
The code block shown below should return a DataFrame with two columns, itemId and col. In this DataFrame, for each element in column attributes of DataFrame itemDf there should be a separate row in which the column itemId contains the associated itemId from DataFrame itemsDf. The new DataFrame should only contain rows for rows in DataFrame itemsDf in which the column attributes contains the element cozy.
A sample of DataFrame itemsDf is below.
Code block:
itemsDf.__1__(__2__).__3__(__4__, __5__(__6__))

 
 
 
 
 

新問題 49
Which of the following code blocks creates a new DataFrame with two columns season and wind_speed_ms where column season is of data type string and column wind_speed_ms is of data type double?

 
 
 
 
 
 

新問題 50
The code block displayed below contains one or more errors. The code block should load parquet files at location filePath into a DataFrame, only loading those files that have been modified before
2029-03-20 05:44:46. Spark should enforce a schema according to the schema shown below. Find the error.
Schema:
1.root
2. |– itemId: integer (nullable = true)
3. |– attributes: array (nullable = true)
4. | |– element: string (containsNull = true)
5. |– supplier: string (nullable = true)
Code block:
1.schema = StructType([
2. StructType(“itemId”, IntegerType(), True),
3. StructType(“attributes”, ArrayType(StringType(), True), True),
4. StructType(“supplier”, StringType(), True)
5.])
6.
7.spark.read.options(“modifiedBefore”, “2029-03-20T05:44:46”).schema(schema).load(filePath)

 
 
 
 
 

新問題 51
Which of the following code blocks returns a DataFrame with a single column in which all items in column attributes of DataFrame itemsDf are listed that contain the letter i?
Sample of DataFrame itemsDf:
1.+——+———————————-+—————————–+——————-+
2.|itemId|itemName |attributes |supplier |
3.+——+———————————-+—————————–+——————-+
4.|1 |Thick Coat for Walking in the Snow|[blue, winter, cozy] |Sports Company Inc.|
5.|2 |Elegant Outdoors Summer Dress |[red, summer, fresh, cooling]|YetiX |
6.|3 |Outdoors Backpack |[green, summer, travel] |Sports Company Inc.|
7.+——+———————————-+—————————–+——————-+

 
 
 
 
 

新問題 52
In which order should the code blocks shown below be run in order to return the number of records that are not empty in column value in the DataFrame resulting from an inner join of DataFrame transactionsDf and itemsDf on columns productId and itemId, respectively?
1. .filter(~isnull(col(‘value’)))
2. .count()
3. transactionsDf.join(itemsDf, col(“transactionsDf.productId”)==col(“itemsDf.itemId”))
4. transactionsDf.join(itemsDf, transactionsDf.productId==itemsDf.itemId, how=’inner’)
5. .filter(col(‘value’).isnotnull())
6. .sum(col(‘value’))

 
 
 
 
 

新問題 53
Which of the following code blocks performs an inner join of DataFrames transactionsDf and itemsDf on columns productId and itemId, respectively, excluding columns value and storeId from DataFrame transactionsDf and column attributes from DataFrame itemsDf?

 
 
 
 
 

新問題 54
The code block displayed below contains an error. The code block should produce a DataFrame with color as the only column and three rows with color values of red, blue, and green, respectively.
Find the error.
Code block:
1.spark.createDataFrame([(“red”,), (“blue”,), (“green”,)], “color”)
Instead of calling spark.createDataFrame, just DataFrame should be called.

 
 
 
 

新問題 55
The code block displayed below contains an error. When the code block below has executed, it should have divided DataFrame transactionsDf into 14 parts, based on columns storeId and transactionDate (in this order). Find the error.
Code block:
transactionsDf.coalesce(14, (“storeId”, “transactionDate”))

 
 
 
 
 

新問題 56
Which of the following describes a narrow transformation?

 
 
 
 
 

新問題 57
Which of the following describes Spark’s Adaptive Query Execution?

 
 
 
 
 

新問題 58
The code block displayed below contains an error. The code block should display the schema of DataFrame transactionsDf. Find the error.
Code block:
transactionsDf.rdd.printSchema

 
 
 
 
 

新問題 59
The code block shown below should return an exact copy of DataFrame transactionsDf that does not include rows in which values in column storeId have the value 25. Choose the answer that correctly fills the blanks in the code block to accomplish this.

 
 
 
 
 

新問題 60
Which of the following code blocks removes all rows in the 6-column DataFrame transactionsDf that have missing data in at least 3 columns?

 
 
 
 
 

新問題 61
Which of the following is one of the big performance advantages that Spark has over Hadoop?

 
 
 
 
 

新問題 62
Which of the following code blocks returns a new DataFrame with only columns predError and values of every second row of DataFrame transactionsDf?
Entire DataFrame transactionsDf:
1.+————-+———+—–+——-+———+—-+
2.|transactionId|predError|value|storeId|productId| f|
3.+————-+———+—–+——-+———+—-+
4.| 1| 3| 4| 25| 1|null|
5.| 2| 6| 7| 2| 2|null|
6.| 3| 3| null| 25| 3|null|
7.| 4| null| null| 3| 2|null|
8.| 5| null| null| null| 2|null|
9.| 6| 3| 2| 25| 2|null|
10.+————-+———+—–+——-+———+—-+

 
 
 
 
 
 

新問題 63
Which of the following statements about garbage collection in Spark is incorrect?

 
 
 
 
 

検証済みのAssociate-Developer-Apache-Spark問題集と解答で合格保証で試験問題集テストエンジン:https://www.goshiken.com/Databricks/Associate-Developer-Apache-Spark-mondaishu.html

Related Links: fortunetelleroracle.com myportal.utt.edu.tt myportal.utt.edu.tt telegra.ph scalar.usc.edu justpaste.me