Which of the following NFs is considered the most preferable for relational database design?
A. 4 NF
B. 2NF
C. 3 NF
D. 1 NF
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Which of the following is a potential issue raised by enterprise database users?
A. The need to manage long transactions
B. The need to manually transfer records to paper
C. The need for concurrent access and multiuser updates
D. The need for multiple views or windows into the same database
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?
A. Batch into small loads and run in parallel.
B. Split the load size into many transactions.
C. Batch large loads into one transaction.
D. Split the load size in half and run simultaneously.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
Which of the following can be used to protect physical database appliances from damage in a server room? (Choose two.)
A. Biometric access systems
B. Fire suppression systems
C. Database control systems
D. Key card systems
E. Cooling systems
F. Camera systems
正解:B,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
Which of the following statements contains an error?
A. Select EmpId from employee
B. Select* from employee where EmpId=90030
C. Select EmpId from employee where EmpId=90030
D. Select EmpId where EmpId=90030 and DeptId=34
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
Which of the following commands is part of DDL?
A. INSERT
B. UPDATE
C. GRANT
D. CREATE
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
A programmer wants to configure a database to only allow read or write access when requests are coming from specific IP addresses. Which of the following can be used to configure IP addresses to allow access to the database?
A. Dynamic IP address
B. IDNS
C. Static IP address
D. Firewall
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 8:
A database administrator is conducting a stress test and providing feedback to a team that is developing an application that uses the Entity Framework. Which of the following explains the approach the administrator should use when conducting the stress test?
A. Write queries directly into the database and report findings.
B. Check the clustered and non-clustered indexes, and report findings.
C. Capture business logic, check the performance of codes, and report findings.
D. Review application tables and columns, and report findings.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
浅田** -
Pass4TestのDS0-001の問題集を習得して本場試験に合格した。しかも高得点。次はCAS-005に挑戦したいと思います!