Communicating Insights from Microsoft Azure to the Business Flashcards Preview

DP-100 - PS > Communicating Insights from Microsoft Azure to the Business > Flashcards

Flashcards in Communicating Insights from Microsoft Azure to the Business Deck (10)
Loading flashcards...
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

Overfitting

2

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

Feature engineering

Plotting the error

Regression

Minimizing the error

Minimizing the error

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.

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

4

What third-party tool creates visualizations and dashboards?

Databricks

Matplotlib

Power BI

Matlibplot

Matplotlib

5

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

Rest API

Http

ODBC

JDBC

JDBC

6

What function is used to display results in notebooks?

display()

visualize()

Create()

show()

display()

7

Which notebook format is used in Databricks?

.dbfs

.spark

.notebook

.dbc

.dbc

8

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

Database Administrator

Developer

Data Engineer

Data Scientist

Database Administrator

9

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

createorReplaceView()

createOrReplaceTempView()

createTempViewDF()

createTempView()

createOrReplaceTempView()

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"))

.agg(count("*").alias("total"))