If you want to create a new login on SQL Server, what is the proper syntax?

If you want to create a new login on SQL Server, what is the proper syntax?

• CREATE LOGIN login_id WITH PASSWORD = password
• CREATE LOGIN login_id WITH USE = password
• CREATE LOGIN login_id USE = password
• USE LOGIN login_id WITH PASSWORD = password 

 

EXPLANATION

Somebody on the Microsoft team decided that this syntax – create a login with this password – made sense. Even if it's arbitrary, you can't say it isn't intuitive.
https://msdn.microsoft.com/en-us/library/ms189751.aspx

Read More

Which of the following would NOT be an ideal route information sharing method in a mixed-brand networked environment?

Which of the following would NOT be an ideal route information sharing method in a mixed-brand networked environment?

• Static
• EIGRP
• RIP
• OSPF 

EXPLANATION

EIGRP is a Cisco proprietary protocol that often isn't supported by all other hardware vendors.
OSPF would be the best alternative if using mixed-brand equipment since it is universally well supported.

Read More

What is the minimum number of disks required for RAID1?

What is the minimum number of disks required for RAID1?

• 2
• 1
• 4 or 5
• 3 

 

EXPLANATION

RAID 1 (mirroring) – the basic idea of such a solution is the replication (mirroring) of two or more discs. It means that while using RAID 1, an exact copy (or mirror) is created on two or more discs. Such a solution gives good read performance and reliability, but storage capacity must be compartmentalized. The reason for this is that the total storage must be equal to the capacity of the smallest disk. i.e.: in the case of an array composed of 3 discs – 250GM, 500GB and 1TB – the usable space will be equal to 250GB.

Read More

You want to link your company's Microsoft Active Directory user accounts to your cloud provider for federated identity management. What type of configuration must you create within your company?

You want to link your company's Microsoft Active Directory user accounts to your cloud provider for federated identity management. What type of configuration must you create within your company?

• Relying party trust
• Identity trust
• XML provider
• JSON provider 

EXPLANATION

Because your company is the identity provider, you must trust the relying party offering services, so you must configure a relying party trust. The cloud provider would deal with configuring an identity trust, not you. XML and JSON are not specifically related to configuring identity federation.

Read More

Which IRQ does COM1 commonly use?

Which IRQ does COM1 commonly use?

• 8
• 4
• 6
• 3 

EXPLANATION

Interrupt request (IRQ) 4 is normally used for the first serial port, COM1. This is also the default interrupt for the third serial port.
In a computer, an interrupt request is a hardware signal sent to the processor that temporarily stops a running program and allows a special program, an interrupt handler, to run instead. Hardware interrupts are used to handle events such as receiving data from a modem or network card, key presses, or mouse movements.

Read More

Which of these is NOT an alternative to Microsoft Excel?

Which of these is NOT an alternative to Microsoft Excel?

• LibreOffice Calc
• GIMP
• Gnumeric
• Google Drive - Sheets

EXPLANATION

GIMP is an image manipulation software for multiple platforms. WIkipedia describes it as a free and open-source raster graphics editor used for image retouching and editing, free-form drawing, resizing, cropping, photo-montages, converting between different image formats, and more specialized tasks. https://en.wikipedia.org/wiki/GIMP
It is more like an alternative to Adobe PhotoShop.
The other applications are actually alternatives to Microsoft Excel.
https://alternativeto.net/software/microsoft-excel/

Read More

In relation to Network Switches, what is the purpose of the spanning tree algorithm?

In relation to Network Switches, what is the purpose of the spanning tree algorithm?

• To help ensure that messages will arrive over all possible paths.
• To provide a path between every LAN segment.
• To discover a "loop free" topology and provide, as possible, a path between every pair of LAN's
• To keep routing updates from being transmitted onto the same port on which they were received. 

 

EXPLANATION

The spanning tree algorithm is a requirement in meshed transparent bridging. As a transparently bridged frame contains no record of the path it has taken, and contains no mechanism for aging, any bridge loop will result in storms of packets continually circulating around the loop. By providing a loop-free path between any two points in the network, the spanning tree algorithm prevents these storms. A form of this algorithm is also used for Explorer control in source-route bridges.

Read More