DS0-001問題集、CompTIA実際の試験問題

質問 1

(A business analyst queries the same few tables every quarter and does not want to write new SQL code every time. Which of the following would best support the business analyst's needs and allow the database administrator to optimize disk space?)

A. Function

B. Table

C. View

D. Stored procedure

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 2

Which of the following is recommended in order to provide encrypted data communication pathways for information as it is transmitted over a network?

A. NFS

B. TCP/IP

C. TLS

D. SMB

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 3

Which of the following NoSQL database types best categorizes MongoDB?

A. Document

B. Graph

C. Column-oriented

D. Key-value stores

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 4

A database administrator set up a connection for a SQL Server instance for a new user, but the administrator is unable to connect using the user's workstation. Which of the following is the most likely cause of the issue?

A. The SQL Server has not been tested properly.

B. The SQL Server codes are performing badly.

C. The SQL Server has many concurrent users.

D. The SQL Server ports to the main machine are closed.

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 5

A new retail store employee needs to be able to authenticate to a database. Which of the following commands should a database administrator use for this task?

A. ALTER USER

B. INSERT USER

C. ALLOW USER

D. CREATE USER

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 6

Which of the following is used to write SQL queries in various programming languages?

A. Object-relational mapping

B. Indexing

C. Excel

D. Normalization

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 7

(Which of the following normal forms (NFs) is considered the most preferable for relational database design?)

A. 4NF

B. 1NF

C. 3NF

D. 2NF

正解: C

解説: (PassTest メンバーにのみ表示されます)

CompTIA DataSys+ Certification - DS0-001 模擬練習