Describe how SQL Server 2012 supports authentication for connecting to the database server.
What will be an ideal response?
SQL Server 2012 supports two types of authentication for connecting to the database server:
Windows authentication and SQL Server authentication. The logins associated with authentication on a SQL Server instance are distinct from the security principals known as database users that are defined for each database. Each login may be mapped to one or more database user. For database objects, permissions are granted to a database user and not to the login that is used for authentication.
You might also like to view...
You run an ad-supported photo sharing website using S3 to serve photos to visitors of your site. At some point you find out that other sites have been linking to the photos on your site, causing loss to your business. What is an effective method to mitigate this?
A. Remove public read access and use signed URLs with expiry dates. B. Use CloudFront distributions for static content. C. Block the IPs of the offending websites in Security Groups. D. Store photos on an EBS volume of the web server.
If your computer hangs, you would go to the Processes tab to ________
A) determine whether a program is running or not B) determine what services are running C) check the print queue D) check network throughput