Question-4:
Types of databases
Centralized database.
Cloud database.
Commercial database.
Distributed database.
End-user database.
Graph database.
NoSQL database.
Object-oriented database.
Your organisation needs a way to monitor whether or not someone is using a meeting space that has been booked for a certain appointment. There are one thousand conference rooms spread across five locations located on three different continents. Motion detectors are installed in every single room, and they provide updates on their status every single second. Only a sensor ID and many other discrete pieces of information are included within the data that was collected by the motion detector. These data, together with information on the owners of the accounts and the locations of the offices, will be used by analysts. Which kind of database do you recommend I use?
A. Flat file
B. NoSQL
C. Relational
D. Blobstore
Correct Answer
Get All 340 Questions and Answer for Google Professional Cloud Architect
: 2 Explanation: This is data that is organized by time. In addition, we have no understanding of what sorts of data are being gathered, which contributes to the appearance that there is no structure. Because a flat file is difficult to query and difficult to analyze, A does not appear to be a suitable option. Because this can support unstructured data, Option-2 looks like a viable option. Because we do not know how the data are structured, Option-3 appears to be an unreasonable option. It appears odd to choose option Option-4 given that Google does not have a database of such kind. The only data that is being sent is the sensor id and some other data. Only once the analyst has completed a join operation with additional data, such as office id, would they be able to find a solution to the problem. Postgresql is capable of storing relational and json data simultaneously. A relational database would be my choice if I wanted to avoid having to do joins. NoSQL databases, which are a different kind of database, are often used to store time series data as well. NoSQL databases, which are more versatile in terms of the data format for each record, are advantageous for gathering time series data from a variety of different sources. This is because NoSQL databases have a more flexible data format.