Job offersCompaniesTestsBlogI'm an employerSign upLog in
Home>IT Tests>Questions>What are the two parts of a URL? (Choose the most suitable answer)

Question from the Infrastructure Architecture test

What are the two parts of a URL? (Choose the most suitable answer)

Archived

Your application is a directory of addresses saved in a single database table / document. Each entry contains:

  • A name, address (number and street name) and a postal code

  • The name of the entry creator (unique).

All users of your application can access all addresses in the database.
Users can only request all entries with a certain postal code.

You are asked to partition this table.

That means

  • Replicating the table on multiple slave servers to distribute queries

  • Splitting the table into multiple sub-tables, with each entry appearing in only one table

What are the possible partitioning keys to ensure that each query only reaches one table:

Author: Kevin LefevreStatus: Archived(New question!)Question passed 234 times
0
Community EvaluationsNo one has reviewed this question yet, be the first!
Similar Questions
1
Explain the different types of caching in the context of an information system architecture.
1
How long does it take to build a data warehouse?
1
Explain the difference between a distribution group and a security group in Active Directory.
0
What are the characteristics of a data warehouse?
0
In a distributed system, it is possible to guarantee consistency (that all nodes in the system have access to the same data at the same time), it is possible to guarantee the atomicity of some operations
0
A is faster than B, C is as fast as A, C is faster than B
0
If the data to be validated does not depend on other data in the database, performing data validation in the server application reduces the number of database queries compared to validation only in the database.