本日更新の2023年01月試験エンジンとPDF Databricks-Certified-Professional-Data-Engineerテスト無料！
究極のガイド準備Databricks-Certified-Professional-Data-Engineer正確なPDF解答
質問 26
A data engineer has developed a code block to perform a streaming read on a data source. The code block is
below:
1. (spark
2. .read
3. .schema(schema)
4. .format("cloudFiles")
5. .option("cloudFiles.format", "json")
6. .load(dataSource)
7. )
The code block is returning an error.
Which of the following changes should be made to the code block to configure the block to successfully
perform a streaming read?
- A. The .read line should be replaced with .readStream
- B. A new .stream line should be added after the .read line
- C. The .format("cloudFiles") line should be replaced with .format("stream")
- D. A new .stream line should be added after the .load(dataSource) line
- E. A new .stream line should be added after the spark line
正解: A
質問 27
A data engineer has a Job with multiple tasks that runs nightly. One of the tasks unexpectedly fails during 10
percent of the runs.
Which of the following actions can the data engineer perform to ensure the Job completes each night while
minimizing compute costs?
- A. They can utilize a Jobs cluster for each of the tasks in the Job
- B. They can institute a retry policy for the task that periodically fails
- C. They can observe the task as it runs to try and determine why it is failing
- D. They can set up the Job to run multiple times ensuring that at least one will complete
- E. They can institute a retry policy for the entire Job
正解: B
質問 28
A data analyst has provided a data engineering team with the following Spark SQL query:
1.SELECT district,
2.avg(sales)
3.FROM store_sales_20220101
4.GROUP BY district;
The data analyst would like the data engineering team to run this query every day. The date at the end of the
table name (20220101) should automatically be replaced with the current date each time the query is run.
Which of the following approaches could be used by the data engineering team to efficiently auto-mate this
process?
- A. They could replace the string-formatted date in the table with a timestamp-formatted date
- B. They could manually replace the date within the table name with the current day's date
- C. They could pass the table into PySpark and develop a robustly tested module on the existing query
- D. They could wrap the query using PySpark and use Python's string variable system to automatically
update the table name - E. They could request that the data analyst rewrites the query to be run less frequently
正解: D
質問 29
You are asked to create a model to predict the total number of monthly subscribers for a specific magazine.
You are provided with 1 year's worth of subscription and payment data, user demographic data, and 10 years
worth of content of the magazine (articles and pictures). Which algorithm is the most appropriate for building
a predictive model for subscribers?
- A. Linear regression
- B. Decision trees
- C. Logistic regression
- D. TF-IDF
正解: A
質問 30
A data engineer has set up a notebook to automatically process using a Job. The data engineer's manager wants
to version control the schedule due to its complexity.
Which of the following approaches can the data engineer use to obtain a version-controllable con-figuration of
the Job's schedule?
- A. They can download the JSON description of the Job from the Job's page
- B. They can submit the Job once on a Job cluster
- C. They can download the XML description of the Job from the Job's page
- D. They can link the Job to notebooks that are a part of a Databricks Repo
- E. They can submit the Job once on an all-purpose cluster
正解: A
質問 31
Which of the following benefits does Delta Live Tables provide for ELT pipelines over standard data pipelines
that utilize Spark and Delta Lake on Databricks?
- A. The ability to write pipelines in Python and/or SQL
- B. The ability to perform batch and streaming queries
- C. The ability to automatically scale compute resources
- D. The ability to declare and maintain data table dependencies
- E. The ability to access previous versions of data tables
正解: D
質問 32
You are using k-means clustering to classify heart patients for a hospital. You have chosen Patient Sex,
Height, Weight, Age and Income as measures and have used 3 clusters. When you create a pair-wise plot of
the clusters, you notice that there is significant overlap between the clusters. What should you do?
- A. Identify additional measures to add to the analysis
- B. Increase the number of clusters
- C. Decrease the number of clusters
- D. Remove one of the measures
正解: C
質問 33
A data engineer has created a Delta table as part of a data pipeline. Downstream data analysts now need
SELECT permission on the Delta table.
Assuming the data engineer is the Delta table owner, which part of the Databricks Lakehouse Plat-form can
the data engineer use to grant the data analysts the appropriate access?
- A. Databricks Filesystem
- B. Jobs
B Dashboards - C. Repos
- D. Data Explorer
正解: C
質問 34
Which of the following data workloads will utilize a Bronze table as its source?
- A. A job that ingests raw data from a streaming source into the Lakehouse
- B. A job that aggregates cleaned data to create standard summary statistics
- C. A job that enriches data by parsing its timestamps into a human-readable format
- D. A job that queries aggregated data to publish key insights into a dashboard
- E. A job that develops a feature set for a machine learning application
正解: C
質問 35
A junior data engineer needs to create a Spark SQL table my_table for which Spark manages both the data and
the metadata. The metadata and data should also be stored in the Databricks Filesystem (DBFS).
Which of the following commands should a senior data engineer share with the junior data engineer to
complete this task?
- A. 1. CREATE MANAGED TABLE my_table (id STRING, value STRING) USING
2. org.apache.spark.sql.parquet OPTIONS (PATH "storage-path"); - B. 1. CREATE MANAGED TABLE my_table (id STRING, value STRING);
- C. 1. CREATE TABLE my_table (id STRING, value STRING) USING DBFS;
- D. 1. CREATE TABLE my_table (id STRING, value STRING) USING
2. org.apache.spark.sql.parquet OPTIONS (PATH "storage-path") - E. 1. CREATE TABLE my_table (id STRING, value STRING);
正解: E
質問 36
You are working on a email spam filtering assignment, while working on this you find there is new word e.g.
HadoopExam comes in email, and in your solutions you never come across this word before, hence probability
of this words is coming in either email could be zero. So which of the following algorithm can help you to
avoid zero probability?
- A. Laplace Smoothing
- B. Naive Bayes
- C. Logistic Regression
- D. All of the above
正解: A
解説:
Explanation
Laplace smoothing is a technique for parameter estimation which accounts for unobserved events. It is more
robust and will not fail completely when data that has never been observed in training shows up.
質問 37
A data engineer has ingested data from an external source into a PySpark DataFrame raw_df. They need to
briefly make this data available in SQL for a data analyst to perform a quality assurance check on the data.
Which of the following commands should the data engineer run to make this data available in SQL for only
the remainder of the Spark session?
- A. raw_df.saveAsTable("raw_df")
- B. raw_df.createOrReplaceTempView("raw_df")
- C. There is no way to share data between PySpark and SQL
- D. raw_df.createTable("raw_df")
- E. raw_df.write.save("raw_df")
正解: B
質問 38
Which of the following statements describes Delta Lake?
- A. Delta Lake is an open format storage layer that processes data
- B. Delta Lake is an open source platform to help manage the complete machine learning lifecycle
- C. Delta Lake is an open source data storage format for distributed data
- D. Delta Lake is an open source analytics engine used for big data workloads
- E. Delta Lake is an open format storage layer that delivers reliability, security, and per-formance
正解: E
解説:
Explanation
Delta Lake
質問 39
A data architect is designing a data model that works for both video-based machine learning work-loads and
highly audited batch ETL/ELT workloads.
Which of the following describes how using a data lakehouse can help the data architect meet the needs of
both workloads?
- A. A data lakehouse combines compute and storage for simple governance
- B. A data lakehouse requires very little data modeling
- C. A data lakehouse stores unstructured data and is ACID-compliant
- D. A data lakehouse provides autoscaling for compute clusters
- E. A data lakehouse fully exists in the cloud
正解: C
質問 40
A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then
perform a streaming write into a new table. The code block used by the data engineer is below:
1. (spark.table("sales")
2. .withColumn("avg_price", col("sales") / col("units"))
3. .writeStream
4. .option("checkpointLocation", checkpointPath)
5. .outputMode("complete")
6. ._____
7. .table("new_sales")
8.)
If the data engineer only wants the query to execute a single micro-batch to process all of the available data,
which of the following lines of code should the data engineer use to fill in the blank?
- A. .trigger(processingTime="once")
- B. .processingTime(1)
- C. .trigger(once=True)
- D. .trigger(continuous="once")
- E. .processingTime("once")
正解: C
質問 41
Which of the following is a Continuous Probability Distributions?
- A. Poisson probability distribution
- B. Normal probability distribution
- C. Binomial probability distribution
- D. Negative binomial distribution
正解: B
質問 42
A data engineer needs to create a database called customer360 at the loca-tion /customer/customer360. The
data engineer is unsure if one of their colleagues has already created the database.
Which of the following commands should the data engineer run to complete this task?
- A. CREATE DATABASE IF NOT EXISTS customer360 LOCATION '/customer/customer360';
- B. CREATE DATABASE customer360 DELTA LOCATION '/customer/customer360';
- C. CREATE DATABASE IF NOT EXISTS customer360 DELTA LOCATION '/customer/customer360';
- D. CREATE DATABASE customer360 LOCATION '/customer/customer360';
- E. CREATE DATABASE IF NOT EXISTS customer360;
正解: A
質問 43
A data engineer is overwriting data in a table by deleting the table and recreating the table. Another data
engineer suggests that this is inefficient and the table should simply be overwritten instead.
Which of the following reasons to overwrite the table instead of deleting and recreating the table is incorrect?
- A. Overwriting a table allows for concurrent queries to be completed while in progress
- B. Overwriting a table maintains the old version of the table for Time Travel
- C. Overwriting a table is an atomic operation and will not leave the table in an unfinished state
- D. Overwriting a table results in a clean table history for logging and audit purposes
- E. Overwriting a table is efficient because no files need to be deleted
正解: D
質問 44
......
合格させるDatabricksはJPNTest試験問題集：https://www.jpntest.com/shiken/Databricks-Certified-Professional-Data-Engineer-mondaishu
完全版最新のDatabricks-Certified-Professional-Data-Engineer問題集で100%カバー率問題と解答があなたをリアル試験で合格させる：https://drive.google.com/open?id=1Jwkwxm511vRpVFVagrI_6X5SYPnysXTq