PrepAway - Latest Free Exam Questions & Answers

Category: 98-364

Exam 98-364: Database Fundamentals

Which of the following normal forms is represented in the scenario?

John works as a Database Administrator for BluewellInc. The company has a SQL Server database. A table in
the database has a candidate key and an attribute that is not a constituent of the candidate key. The non-key
attribute depends upon the whole of the candidate key rather than just a part of it. Which of the following
normal forms is represented in the scenario?

Which of the following protection techniques will you suggest for this database?

Your Company is designing and developing a number of databases for a stock exchange. One of the
databases will contain highly sensitive data for which high level of security will be required. Although high
processing speed is one of the prime requirements of the customer, for this database, security of the data will
take priority over the processing speed. It needs to be ensured that even if unauthorized access to the
database is obtained, the rogue user is unable to read the data. Which of the following protection techniques
will you suggest for this database?


Page 1 of 1312345...10...Last »