Knowledge quiz

It's time to put what you've learned to the test, get 8 right to pass this unit.

What kinds of custom types can you define?

There are three correct answers.

Simple Types

Structured Types

Table Types

Associations

Which of the following statements about persistent SQLite databases are true?

There are two correct answers.

A file name for the database must be specified in package.json.

Changes to the CDS models or the initial data are automatically deployed to the database when the server is started with cds watch.

All data changes are lost as soon as the server started with cds watch is stopped.

By executing the cds deploy command in the terminal, the database tables are filled with the initial data from the provided .csv files, among other things.

What naming conventions are recommended when creating domain models?

There are three correct answers.

Entity names should start with a capital letter.

The singular form should be used for entity names.

Element names should start with a capital letter.

Names for custom-defined types should start with a capital letter.

The singular form should be used for names of custom-defined types.

Which of the following protocols does CAP support out of the box?

There are two correct answers.

OData V2

OData V4

SOAP

REST

Suppose you want to explicitly specify /admin as the endpoint of an exposed service. How do you need to annotate the corresponding service definition to achieve this?

Choose the correct answer.

@(root: '/admin')

@(url: '/admin')

@(path: '/admin')

@(endpoint: '/admin')

For a domain model created in a CAP project, an SQL DDL script can be generated manually. Assuming that the domain model is contained in the db/model.cds file of the CAP project, which terminal command do you need to execute in the root directory of the project to generate the SQL DDL statements for the model?

Choose the correct answer.

cds parse db/model.cds --to sql

cds translate db/model.cds --to sql

cds generate db/model.cds --to sql

cds compile db/model.cds --to sql

What command do you need to enter in the terminal to generate a properly named .csv file for each table from the CDS model in the db/data folder? (The generated files do not yet contain any data, but they do contain column titles that correspond to the declared element names in the CDS model).

Choose the correct answer.

cds data

cds add

cds add data

cds data add

You have created a service definition that exposes an entity A, which is a projection on an entity B from the domain model. Which objects are generated in the database on the basis of this service model?

Choose the correct answer.

A table is created for entity A and a view for entity B.

A view is created for entity A and a table for entity B.

A table is created for entity A and a table is created for entity B.

A view is created for entity A and a view is created for entity B.

A table is created for entity B, no object is created for entity A.

10.

In a service, an entity called Books is to be exposed, which is to be defined as a projection on the entity db.Books from the domain model. The exposed entity should allow access to the underlying data in a 1:1 manner. What syntax can you use for this?

There are two correct answers.

entity Books as view on db.Books;

entity Books as projection on db.Books;

entity Books as select from db.Books;

entity Books as choice of db.Books;

Knowledge quiz

What kinds of custom types can you define?

Which of the following statements about persistent SQLite databases are true?

What naming conventions are recommended when creating domain models?

Which of the following protocols does CAP support out of the box?

Suppose you want to explicitly specify /admin as the endpoint of an exposed service. How do you need to annotate the corresponding service definition to achieve this?

What command do you need to enter in the terminal to generate a properly named .csv file for each table from the CDS model in the db/data folder? (The generated files do not yet contain any data, but they do contain column titles that correspond to the declared element names in the CDS model).

For which databases does the CAP Node.js runtime provide out-of-the-box support?

You have created a service definition that exposes an entity A, which is a projection on an entity B from the domain model. Which objects are generated in the database on the basis of this service model?

In a service, an entity called Books is to be exposed, which is to be defined as a projection on the entity db.Books from the domain model. The exposed entity should allow access to the underlying data in a 1:1 manner. What syntax can you use for this?