Which of the following have data manipulation and procedural scripting power? (Choose two.)
A. T-SQL
B. Advanced
C. PL/SQL
D. SQL
E. PQL
F. SQL
正解:A,C
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Which of the following services is responsible for assigning, managing, and reclaiming IP addresses on a TCP/IP-based network?
A. DHCP
B. ISMTP
C. DNS
D. LDAP
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
A database professional is considering denormalizing a database. Which of the following documents should be used to analyze the database's structure?
A. SOP
B. UML diaqrams
C. ERD
D. Data dictionaries
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
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 メンバーにのみ表示されます)
質問 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:
Refer to exhibit.
Given the following customer table:
Which of the following ORM snippets would return the ID, state, and country of all customers with the newest customers appearing first?
A.
B.
C.
D.
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
Which of the following is an attack in which an attacker hopes to profit from locking the database software?
A. Spear phishing
B. Ransomware
C. SQL injection
D. On-path
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 8:
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 メンバーにのみ表示されます)
Yamazaki -
DS0-001問題集ぽく、この一冊でだけで合格できました。Pass4Testありがとうございました。