Microsoft SQL Server

Benjamin is setting up a new server for his company and is considering installing Microsoft SQL Server. He wonders if Microsoft SQL Server can only be installed on a Windows Domain Controller.

• True

• False

Rohan is setting up a new database server for his company using Microsoft SQL Server Enterprise on a physical or virtual machine. He needs to ensure that he purchases the correct type of licenses. Which of the following does Rohan need to buy?

• Physical CPU core or Virtual CPU core

• CPU plus Client Access License

• Client Access License only

• CPU core only

Priya is setting up Microsoft SQL Server for her company. She learns that CAL's can be purchased for either Users or Devices or both. Is this true?

• True

• False

David is setting up a new instance of Microsoft SQL Server for his company's database. When creating users for this instance, what type of user can David create? (Choose two.)

• A domain user account

• A local user account

• No account is needed

• The root user account

Priya is setting up a new project at her company and wants to use Microsoft SQL Server to manage data for several departments. She wonders if she can create separate databases for each department within a single instance of Microsoft SQL Server. Is this possible?

• No, only one database and associated tables is allowed

• Yes, multiple databases and associated tables are allowed

• Neither, databases and tables are the same thing

• Databases require additional software

Noah is tasked with backing up a database in Microsoft SQL Server for his company's IT department. Which steps should he follow to complete the backup? (Choose three.)

• Connect to the database in object explorer

• Export the database to mySQL format

• Expand the databases and select the database to back up

• Right click, choose Tasks, then Back Up

Aria is learning SQL and wants to write queries to manage a database. She is trying to identify which of the following are actual SQL keywords. (Choose 3.)

• USE

• SELECT

• REMOVE

• DELETE

Sophia is setting up a new database for her small business. To create a table, she needs to add a table name and define:

• Rows

• Arrays

• Columns

• Windows

Olivia is setting up a system to store information about her company's employees, including their names, job titles, and contact details in a way that makes it easy to organize and retrieve. What is this system called?

• Artificial intelligence

• A database

• Data in a spreadsheet

• A word document with names and addresses

Sophia is responsible for managing a company's Microsoft SQL Server. She believes that SQL Server can only be managed using SQL Server Management Studio. Is she correct?

• True

• False