Dataiku Developer Certification case studies
Dataiku Developer Certification · Put your knowledge to work in context.
This independent study page provides practice for Dataiku Developer Certification. Its editorial learning areas include Dataiku code recipes, datasets, environments and extension boundaries; Dataiku scenarios, variables, bundles and API-service deployment; Python and dataframe reasoning for applied analytics; Intelligent search, learning and evaluation; Data, Databases, and Information Retrieval; Identity, access and cryptographic protection; Security operations, monitoring and response; Continuity, backup and technical recovery. The Dataiku Developer Certification case studies are 6 cases and about 2,154 words.
1A convenient write changes the downstream schema
A fictional Dataiku developer creates an output dataframe whose columns differ from the existing output dataset schema. The proposed recipe uses a schema-inferencing write, while a downstream consumer still expects the previous column names and types.
170 words, under 1 min2A SQL change is invisible to the chosen trigger query
A fictional scenario uses a SQL-query change trigger whose query returns only the total row count. The supplied external table changes values inside existing rows while preserving the number of rows.
177 words, under 1 min3A duplicate join key doubles the reported total
A fictional analyst joins transaction rows to a customer-classification table. The supplied classification data contains two records for one customer key, even though the analyst intended one current classification per customer.
170 words, under 1 min4The Slow Catalog Query
A public library's catalog database has 2.4 million rows in a table with columns id, title, author, year, subject, and checked out. The web catalog runs this query about 40 times per second: SELECT id, title FROM books WHERE author = ?
613 words, about 3 min5Candidate Records at East Mercia Examinations Board
East Mercia Examinations Board stores records for 25,000 candidates. Each record contains an 8-digit candidate number, a 60-character name, and nine paper marks that are integers from 0 to 100.
803 words, about 4 min6SaaS access after a role change
A fictional organization uses a managed collaboration service for internal planning documents. The provider maintains the application and underlying servers, while the organization configures users, groups and sharing settings.
221 words, about 1 min