QuestionQ108Verified/Endpoint SecurityCopy linkReport a problemAsk AstroTutorSave questionMany IIS servers connect to Microsoft SQL databases. Which statement about SQL Server security is TRUE?ASQL Server patches are part of the operating system patches.BSQL Server should be installed on the same box as your IIS web server when they communicate as part of the web application.CIt is good practice to never use integrated Windows authentication for SQL Server.DIt is good practice to not allow users to send raw SQL commands to the SQL Server.Show AnswerAnswerExplanationAllowing users to submit raw SQL can permit SQL injection, in which malicious input becomes executable database code. Secure applications validate input and use parameterized commands or stored procedures so user-supplied values are not executed as SQL.Learn moreSQL injection - SQL Server | Microsoft LearnShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion