MS SQL Server - 97 - Graph Databases MCQ

97 – Graph Databases MCQ

1 / 25

1. What is a graph database in SQL Server used for?

B. Storing tabular data

D. Managing interconnected data with relationships

A. Storing unstructured data

C. Managing hierarchical data

2 / 25

2. Which data model is typically used by graph databases?

A. Relational

B. Hierarchical

C. Document

D. Graph

3 / 25

3. In SQL Server, what is a node in a graph database?

C. A property of an entity

D. A data point representing an entity

B. A row in a table

A. A table that stores data

4 / 25

4. What is an edge in a graph database?

D. A relationship between two nodes

C. A property of a node

A. A table that connects nodes

B. A column in a table

5 / 25

5. Which language is commonly used to query graph databases in SQL Server?

B. JSON

A. SQL

D. Python

C. Cypher

6 / 25

6. What is Cypher in the context of graph databases?

D. A data storage format

C. A type of index

A. A query language for graph databases

B. A data modeling technique

7 / 25

7. In SQL Server, which built-in graph database feature allows you to create and manage graph databases?

A. SQL Server Agent

D. SQL Server Graph Extensions

C. SQL Server Integration Services

B. SQL Server Analysis Services

8 / 25

8. What is a property graph in a graph database?

A. A graph with no nodes

B. A graph with no edges

D. A graph with only one node and one edge

C. A graph with properties associated with nodes and edges

9 / 25

9. Which SQL Server edition(s) support the use of graph databases?

B. Enterprise Edition only

C. Standard Edition and Enterprise Edition

D. Express Edition and Developer Edition

A. All editions

10 / 25

10. In a graph database, what is a label?

D. A category or tag assigned to nodes

C. A relationship between nodes

B. A unique identifier for a node

A. A property associated with a node

11 / 25

11. What is the purpose of the MATCH clause in a Cypher query?

A. To filter nodes in a graph

C. To define relationships between nodes

D. To retrieve data from a graph

B. To specify the graph database schema

12 / 25

12. In SQL Server, how do you define a relationship between two nodes in a graph database?

C. Using the CONNECT statement

B. Using the CREATE EDGE statement

D. Using the MATCH clause in a Cypher query

A. Using a foreign key constraint

13 / 25

13. Which SQL Server function is used to traverse a graph database in a Cypher query?

B. MATCH

D. NODE

C. RELATIONSHIP

A. STARTNODE

14 / 25

14. What is a traversal in the context of graph databases?

D. A property associated with a node

C. A way to define relationships between nodes

B. A method for querying graph data

A. A path between two nodes

15 / 25

15. In a graph database, what is a property constraint?

A. A rule that restricts the types of nodes that can be connected

B. A limit on the number of nodes in the graph

D. A method for indexing graph data

C. A requirement for nodes to have specific properties

16 / 25

16. What is the purpose of the MERGE clause in a Cypher query?

B. To create new nodes and relationships if they don't exist

C. To filter nodes based on properties

D. To define relationships between nodes

A. To delete nodes from a graph

17 / 25

17. Which SQL Server feature allows you to import and export graph data?

B. SQL Server Analysis Services (SSAS)

C. SQL Server Data Tools (SSDT)

D. SQL Server Graph Data Import/Export Wizard

A. SQL Server Integration Services (SSIS)

18 / 25

18. In a graph database, what is a subgraph?

C. A portion of a larger graph

D. A graph that has no labels

B. A graph that contains only edges

A. A graph that contains only nodes

19 / 25

19. What is the purpose of the CREATE INDEX statement in a graph database?

D. To enforce referential integrity between nodes

C. To create new nodes and relationships

B. To optimize query performance by creating indexes on properties

A. To define a primary key constraint on nodes

20 / 25

20. In a graph database, what is a traversal depth?

C. The maximum number of nodes traversed in a path

D. The number of labels assigned to a node

A. The number of properties associated with a node

B. The number of relationships a node has

21 / 25

21. What is a directed graph in the context of graph databases?

A. A graph with no nodes

C. A graph where edges have a specific direction

B. A graph with only one node and one edge

D. A graph with no labels

22 / 25

22. In SQL Server, how do you define an undirected relationship between nodes in a graph database?

D. Undirected relationships are not supported in SQL Server graph databases.

B. Using the MATCH clause in a Cypher query

A. Using the UNDIRECTED keyword in the CREATE EDGE statement

C. Using the DIRECTION keyword in the MATCH clause

23 / 25

23. What is a pattern in the context of a Cypher query?

A. A specific combination of nodes and relationships

D. A way to define a traversal

B. A constraint on node properties

C. A type of label

24 / 25

24. In SQL Server graph databases, what is the purpose of the DROP NODE statement?

B. To create a new node

C. To define relationships between nodes

A. To delete a node from a graph

D. To retrieve data from a graph

25 / 25

25. Which SQL Server tool can you use to visualize and explore graph databases?

D. SQL Server Integration Services (SSIS)

B. SQL Server Data Tools (SSDT)

A. SQL Server Management Studio (SSMS)

C. SQL Server Analysis Services (SSAS)

Your score is

MS SQL Server – 97 – Graph Databases MCQ