exam questions

Exam SY0-601 All Questions

View all questions & answers for the SY0-601 exam

Exam SY0-601 topic 1 question 121 discussion

Actual exam question from CompTIA's SY0-601
Question #: 121
Topic #: 1
[All SY0-601 Questions]

A database administrator wants to grant access to an application that will be reading and writing data to a database. The database is shared by other applications also used by the finance department. Which of the following account types is MOST appropriate for this purpose?

  • A. Service
  • B. Shared
  • C. Generic
  • D. Admin
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
stoneface
Highly Voted 2 years, 10 months ago
Selected Answer: A
Service accounts are a special type of non-human privileged account used to execute applications and run automated services, virtual machine instances, and other processes. Service accounts can be privileged local or domain accounts, and in some cases, they may have domain administrative privileges
upvoted 60 times
...
Wallee
Most Recent 1 year, 1 month ago
A service account is a special type of user account that is created specifically to run applications, services, or automated tasks on a computer system.
upvoted 1 times
...
Shouqq_examtopics
1 year, 2 months ago
Selected Answer: A
Service acc
upvoted 1 times
...
kieth01
1 year, 3 months ago
The correct answer is B. Shared. A Service account is typically used for automated processes or services, not for application access. A Generic account is not recommended as it is not secure and can lead to unauthorized access. An Admin account has elevated privileges, which is not necessary for an application that only needs to read and write data. A Shared account, on the other hand, is designed for multiple users or applications to access a database, making it the most appropriate choice in this scenario. It provides access to the database without granting excessive privileges, ensuring data security and segregation of duties.
upvoted 1 times
Shouqq_examtopics
1 year, 2 months ago
A Service account (A) is a type of account that is used by an application or service to access a database. It is a separate account from the administrator’s account and is used to run the application or service. This type of account is most appropriate for this purpose because it allows the application to access the database without giving it administrative privileges. • A Shared account (B) is not a standard type of account in a database, and it is not clear what privileges it would have.
upvoted 1 times
...
...
LordJaraxxus
1 year, 4 months ago
Selected Answer: A
Some applications and services need to run under the context of an account, and a service account fills this need. As an example, SQL Server is a database application that runs on a server, and it needs access to resources on the server and the network. Administrators create a regular user account, name it something like sqlservice, assign it appropriate privileges, and configure SQL Server to use this account.
upvoted 1 times
...
sammy001
1 year, 5 months ago
Selected Answer: C
service account can't be shared between or among departments. generic account can be shared ,but should not be used .
upvoted 1 times
sammy001
1 year, 5 months ago
sorry I was very wrong. correct answer is A
upvoted 2 times
LordJaraxxus
1 year, 4 months ago
Keep up the good work, brother!
upvoted 1 times
...
...
...
cyberPunk28
1 year, 6 months ago
Selected Answer: A
A. Service
upvoted 1 times
...
ApplebeesWaiter1122
1 year, 11 months ago
Selected Answer: A
A. Service The most appropriate account type for an application that needs to read and write data to a shared database is a "Service" account. Service accounts are used to run specific services or applications in a controlled manner, allowing them to access resources and perform specific actions on behalf of the application or service they represent. In this scenario, the application needs to interact with the database on a regular basis, so a dedicated service account should be created for it. This service account should have the necessary permissions to read and write data to the specific tables or data objects required by the application. Using a service account provides better control and accountability over the actions performed by the application. It allows the database administrator to restrict the application's access to only the required resources and minimize the risk of unauthorized access to other parts of the database that are unrelated to the application's functionality.
upvoted 4 times
...
Protract8593
1 year, 11 months ago
Selected Answer: A
A service account is typically used for applications and services that need access to specific resources, such as a database. In this scenario, the application that reads and writes data to the database should have its own dedicated service account. By using a service account, the access can be specifically granted and restricted as needed, providing appropriate permissions for the application to interact with the database without compromising other accounts used by the finance department or other applications. Option B (Shared), Option C (Generic), and Option D (Admin) are not suitable choices in this context. Shared and Generic accounts are not specifically intended for application access, and granting admin privileges to an application is unnecessary and risky, as it may lead to unauthorized access or actions. It is always best practice to use the least privilege principle and provide only the necessary permissions for the application to perform its required tasks.
upvoted 4 times
...
LeonardSnart
2 years, 1 month ago
Selected Answer: A
"Service accounts. Some applications and services need to run under the context of an account, and a service account fills this need. As an example, SQL Server is a database application that runs on a server, and it needs access to resources on the server and the network. Administrators create a regular user account, name it something like sqlservice, assign it appropriate privileges, and configure SQL Server to use this account. Note that this is like a regular end-user account. The only difference is that it’s used by the service or application, not an end user. Credential policies may require long, complex passwords for these accounts, but they should not expire. If the password expires, the account can no longer log on, and the service or application will stop." -Security+ Get Certified Get Ahead SY0-601 by Darril Gibson
upvoted 1 times
...
strong1
2 years, 2 months ago
Service accounts are accounts that specific applications or services use to interact with the system. For example, if you have an FTP server that interacts with an FTP service, you might use a service account with limited permissions to allow that service to access the system. This enables you to apply very tight security controls to the service account, rather than using a general user account to perform the activity
upvoted 1 times
...
Kaps443
2 years, 2 months ago
Selected Answer: A
A is correct.
upvoted 1 times
...
EricShon
2 years, 3 months ago
Selected Answer: A
A. Service account is the most appropriate for this purpose.
upvoted 1 times
...
seagnull
2 years, 4 months ago
Selected Answer: A
"A database administrator wants to grant access to an application". Service accounts are created for apps and services.
upvoted 2 times
...
DALLASCOWBOYS
2 years, 5 months ago
A. Service accounts are associated with applications and services.
upvoted 1 times
...
nul8212
2 years, 6 months ago
Selected Answer: C
generic account A preset, standard, common, guest, fixed, shared, or anonymous user account.
upvoted 2 times
Dacoder
1 year, 10 months ago
It is an application, not a person.
upvoted 1 times
...
Blake89
2 years, 5 months ago
Absolutely not. People like you need to stop commenting on these threads.
upvoted 11 times
...
...
zharis
2 years, 8 months ago
Service accounts are used by scheduled processes and application server software such as databases
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...