Communicating Insights from Microsoft Azure to the Business

Question 1

What is the likely cause when a supervised model makes predictions perfectly against all the training data but fails against new data?

Underfitting

Overfitting

Overtraining

Undertesting

Answer 1

Overfitting

Question 2

What is used to guide the improvement of the model during model training?

Feature engineering

Plotting the error

Regression

Minimizing the error

Answer 2

Minimizing the error

Question 3

What is the accuracy and precision of the model?

A. Accuracy is a measure of the consistency of the predictions. Precision is the value of accurate predictions over the total number of predictions.

B. Accuracy is the value of accurate predictions over the total number of predictions. Precision is a measure of the consistency of the predictions.

C. Accuracy is the value of accurate predictions over the total number of predictions. Precision is total accurate predictions over total false predictions.

D. Accuracy is total accurate predictions over total false predictions. Precision is a measure of the consistency of the predictions.

Answer 3

B. Accuracy is the value of accurate predictions over the total number of predictions. Precision is a measure of the consistency of the predictions.

Question 4

What third-party tool creates visualizations and dashboards?

Databricks

Matplotlib

Power BI

Matlibplot

Answer 4

Matplotlib

Question 5

What kind of a connector is needed to establish a connection between Power BI and Azure Databricks?

Rest API

Http

ODBC

JDBC

Answer 5

JDBC

Question 6

What function is used to display results in notebooks?

display()

visualize()

Create()

show()

Answer 6

display()

Question 7

Which notebook format is used in Databricks?

.dbfs

.spark

.notebook

.dbc

Answer 7

.dbc

Question 8

What is not a specialized role in the Data Science process?

Database Administrator

Developer

Data Engineer

Data Scientist

Answer 8

Database Administrator

Question 9

Which (Spark) DataFrame method do you use to create a temporary view?

createorReplaceView()

createOrReplaceTempView()

createTempViewDF()

createTempView()

Answer 9

createOrReplaceTempView()

Question 10

What is the DataFrame equivalent of the SQL statement SELECT count(*) AS total?

.select(agg(“*”).alias(“total”))

.select(count(“*”) alias(“total”))

.select(count(“*”).alias(“total”))

.agg(count(“*”).alias(“total”))

Answer 10

.agg(count(“*”).alias(“total”))