ATD Quiz

Complete the test with a score of 40-100% to receive a prize.

The number of attempts remaining is 1

Please fill in the form

I would like to receive news from ELEKS Software.

1 / 10

Why do we need an analytics storage separated from transactional?

To avoid usage of Excel in analytics workload.

To avoid unnecessary resource consumption of the source system.

To not corrupt transactional data, which is very important for business

To improve performance speed of analytics workload (ad-hoc queries, reporting)

2 / 10

What is faster in a transactional database:

DELETE FROM dbo.employees;

TRUNCATE TABLE dbo.employees;

3 / 10

What is the best approach to read last committed data without locking in RDBMS?

Use optimistic isolation type, in example “SNAPSHOT” isolation level

None of above

Use “READ UNCOMMITED” isolation level

Use “WITH (NO LOCK)” hint

4 / 10

Pick one answer that describes slowly changing dimensions Type 2. (SCD2)

Only the Current data is kept. No history.

Keep limited historical context (current+previous value) in the same row.

Full history of changes is made by closing the old record and inserting a new one.

Nothing above.

5 / 10

Which of the following issues is the regularization aimed to solve?

High bias

Cross-validation

Overfitting

Underfitting

6 / 10

Which of the following are regularization methods?

Data Augmentation

Grid Search

Elastic Net

Early-Stopping

Boosting

Batching

All of the above

DropOut

7 / 10

You are training a medical diagnostic classification model to detect a rare deadly disease. It is important to identify as many people who actually have the disease as possible, even if it means some healthy people are incorrectly flagged. Which evaluation metric should you focus on?

Precision

AUC

Recall

RMSE

8 / 10

What was the initial LeNet-5 neural network use case?

Handwritten zip code recognition

Summarization of legal documents

Housing price prediction

9 / 10

Which one term is NOT related to the Artificial Neural Networks:

ReLU

Backpropagation

Activation Function

Perceptron

Kernel Trick

10 / 10

What does the term “AI winter” refer to?

The vanishing gradient problem in Deep Neural Network

Period in scientific research in 20th century

The apocalyptic scenario of the future where Artificial Superintelligence takes over humanity

Your score is

The average score is 8%

0%