Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DP-900 > Core Data Concepts > Flashcards

Core Data Concepts Flashcards

1
Q

_____ data store consists of edges and nodes used to store and query complex relationships among entities. It stores all the entities as nodes and builds the relationship between those entities by using edges.

A

A Graph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which component of a table is used to store the unique identifier for instances of that data entity?

A

Primary Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What type of data is JavaScript Object Notation (JSON) format data an example of?

A

Semi-structured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which two data store types are non-relational?

A

A graph or document database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is the correct data type classification for CSV files?

A

Structured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the correct data type classification for XML files?

A

Semi-Structured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the correct data type classification for BLOB files?

A

Unstructured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the correct data type classification for JSON files?

A

Semi-structured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A company uses an accounting system to keep track of all types of financial transactions, which type of workload or processing is this an example of?

A

Online Transaction Processing (OLTP)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

In relation to graph databases what is an instance of data entities (people or company)

A

Node

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In regards to graph databases, what are relationships between instances of data entries, like company/employee

A

Edge

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A small Car Hire company maintains the following spreadsheets:
- a list of vehicles, license plates, make, model, color and year purchased
- a list of rentals, customer name, email address and phone number, vehicles license plate, pick up and drop off dates.

T/F:
Vehicle is a data entity

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A small Car Hire company maintains the following spreadsheets:
- a list of vehicles, license plates, make, model, color and year purchased
- a list of rentals, customer name, email address and phone number, vehicles license plate, pick up and drop off dates.

T/F:
License Plate is a key value

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A small Car Hire company maintains the following spreadsheets:
- a list of vehicles, license plates, make, model, color and year purchased
- a list of rentals, customer name, email address and phone number, vehicles license plate, pick up and drop off dates.

T/F:
The car hire company’s data is semi-structured

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You are designing a database for a new social media platform. The solution must support complex relationship analysis, including values such as age, location, pets and musical preferences

What type of data store would you use

A

Graph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What component of relational databases are instances of data entities such as people or companies

A

Row

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What component of relational databases are relationships between instances of data entities like company/employee

A

Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What component of relational databases are attributes of data entities such as a persons email address

A

Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What type of workload or processing should you use to support a reporting system that performs data mining in large amounts of data

A

Online analytical processing (OLAP)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Your company is hiring a new data analyst and is putting together a job description for the role.

What are three key tasks of data analysts?

A

1.) to create and maintain data models and data sets

2.) To create reports and dashboards

3.) To identify trends and relationships in data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

T/F: a task that generates complex ad-how reports using multiple aggregations is suitable for an analytical workload

A

True

22
Q

T/F:
A task for that performs e-commerce transactions is suitable for an analytical workload

A

False

23
Q

T/F: A task that performs big data analysis in NoSQL databases is suitable for an analytical workload

A

True

24
Q

Your company uses an Azure SQL database to store information about your sales cycle, including customers, quotes, orders and invoices

As part of a new disaster recovery procedure, you need to ensure that a backup of the database is taken and added to Azure Blob Storage every night

Which role is the most appropriate for this task?

A

Database Administrator

25
Q

T/F:
Semi-structured data must adhere to a fixed schema

A

False

26
Q

T/F:
Semi-structured data allows for variation between instances of data entities

A

True

27
Q

T/F:
Semi-structured data allows for hierarchical schema

A

True

28
Q

T/F:
Semi-structured data requires all data entities to have the same attributes

A

False

29
Q

You want to perform data mining on historic data collected from multiple relational and non-relational sources, what form of processing should you use?

A

OLAP (online analytical processing)

30
Q

You want to process hundreds of user purchases per minute, including updates to inventory on hand, what processing workload is most appropriate

A

OLTP (online transactional processing)

31
Q

You want to support warehouse sales and shipping for physical warehouses and multiple international locations, what processing workload type is this?

A

OLTP (online transactional processing)

32
Q

What processing workload type would provide loosely normalized data to support report generation.

A

OLAP (Online Analytic Processing)

33
Q

Your company is writing an application that will receive real-time events from multiple sources which may vary in schema. The application should be able to write the data to a data store as quickly as possible. It should also be able to lookup the value from the data store using a unique key.

Which is the best type of data store you can use?

A

Key/Value

34
Q

Your company application requires you to store user profile data, like shipping addresses and user preferences. Each user can have multiple addresses and different preference fields. All the user data should be stored and retrieved from a single data structure.

Which type of non relational data store should you use?

A

Document Database

35
Q

OLTP T/F:
Data is highly normalized with the schema strongly enforced on write

A

True

36
Q

OLTP T/F:
Read and write workload requirements are balanced.

A

False

37
Q

OLTP T/F:
Changes made are rolled back automatically if a transaction is not completed.

A

True

38
Q

What non-relational data store allows for storage of large audio and video files that are used as the source of streaming content

A

Object

39
Q

What non-relational data store allows for semi-structured data where each entity provides its own field defenitions

A

Document

40
Q

What non-relational data store has entities and relationships, including multiple and complex relationships with other entities

A

Graph

41
Q

Which type of database is used to store structured data?

A

Relational

42
Q

You need to store structured data in a relational database. How is data organized in a relational database

A

Tables containing rows and columns

43
Q

You need to implement a non-relational data store for a new application. The application needs to store data in JSON format with a flexible schema. All entity details should be stored together in the same structure

What non-relational data store should you use?

A

Document

44
Q

Which of these tools would a Data Analyst use most of the time?

A

Power BI

45
Q

T/F:
Each document in a document database typically contains all data for a single entity

A

True

46
Q

T/F:
Documents in a document database use the same data schema for all documents

A

False

47
Q

T/F:
Documents in a document database support relationships enforced between documents

A

False

48
Q

T/F:
You need to define a strict schema on semi-structured data

A

False

49
Q

T/F:
You can use semi-structured data to store data that has a highly variable structure

A

True

50
Q

T/F:
You can use XML or JSON as a file format to store semi-structured data

A

True

51
Q

What data store is optimized to store and retrieve text files, videos, and images? The solution must store metadata about the file, it’s contents, and a unique ID for each file

A

Object

DP-900 (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions