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