You need to encrypt and compress your backups before replicating them off site. Which is best practice, compress then encrypt, or encrypt then compress?

You need to encrypt and compress your backups before replicating them off site. Which is best practice, compress then encrypt, or encrypt then compress?

• Neither!
• Encrypt first!
• Doesn't matter!
• Compress first! 

 

EXPLANATION

If you encrypt the data first, it will be randomized and unintelligible by your compression application which need to compress the data in a logical format.  

Compressing then encrypting is the way to go.

SOURCE

https://stackoverflow.com/questions/4676095/when-compressing-and-encrypting-should-i-compress-first-or-encrypt-first 

Read More

For every unique constraint on a column, SQL server will create which of the following?

For every unique constraint on a column, SQL server will create which of the following?

• An entry for that column
• A non-clustered index for that column
• A clustered index for that column
• A filtered index 

 

EXPLANATION

For every unique constraint on a column, SQL server creates a non-clustered index. A non-clustered index has a structure separate from the data rows. It contains non-clustered index key values and each key value entry has a pointer to the data row that contains the key value.

Read More

Unix time is the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC) on what date?

Unix time is the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC) on what date?

• Saturday, January 1, 2000
• Sunday, December 28, 1969
• Thursday, January 1, 1970
• Monday, January 1, 1900 

 

EXPLANATION

Unix time counts the number of seconds that have elapsed since 00:00:00 UTC on January 1, 1970. It is used in Unix-like operating systems and file formats. Because it doesn't deal with leap seconds, it is not a true representation of UTC. Check out Unix time for yourself by typing "date +%s" on the command line.

Fun fact: December 28, 1969, is Linus Torvalds' birthday, which makes him older than Unix.

Read More

Which are Fax over IP Protocols?

Which are Fax over IP Protocols?

• k.30 and k.38
• M.16 and M.204
• H.323 and H.404
• t.30 and t.38 

 

EXPLANATION

t.30 and t.38 are fax over ip protocols

SOURCE

https://www.3cx.com/pbx/foip/ 

Read More

What Azure BGP Private ASN are reserved?

What Azure BGP Private ASN are reserved?

• 65515, 65517, 65518, 65519, 65520
• 54000, 54100, 54200, 54300, 54400
• 60001, 60002, 60003, 60004, 60005
• 67715, 67717, 67718, 67719, 67720 

 

EXPLANATION

Private and Public Azure ASN's can be foudn here:
https://docs.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-bgp-overview

SOURCE

https://docs.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-bgp-overview

Read More