New Updated Microsoft MTA 98-364 Real Exam Questions and Answers Download 1-10

Ensurepass

QUESTION 1

John works as a Database Administrator for Bluewell Inc. 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?

 

  1. 4 NF

  2. 2 NF

  3. 1 NF

  4. 3 NF

 

Correct Answer: B

 

 

QUESTION 2

You work as a Database Designer for DataOneWorld Inc. The company has a SQL Server database. You are assigned the task of creating a data model of an enterprise based on a specific data model. The model to be created should be independent of a particular DBMS. Which of the following database designs will help you accomplish the task?

 

  1. Logical database design

  2. Conceptual database design

  3. Physical database design

  4. Application design

 

Correct Answer: A

 

 

QUESTION 3

Which of the following steps in database planning helps to determine the requirements of the database through interviewing?

 

  1. Gathering information

  2. Identifying the relationship between objects

  3. Identify the objects

  4. Identifying the type of information for each objects

  5. Modeling the object

 

Correct Answer: A

 

 

 

 

QUESTION 4

Consider the case of a fruit juice company. The company manufactures fruit juices and supplies them to wholesalers. The Database Designer creates a table named Production. The code is given below:

 

  1. CREATE Table Production

  2. 2.(Fruit_type VarChar,

  3. Fruit_name Char(20),

  4. Quantity Int(3))

 

Which of the above-mentioned lines has an error?

 

  1. Line 3

  2. Line 2

  3. Line 1

  4. Line 4

 

Correct Answer: B

 

 

QUESTION 5

John works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database. John wants to insert records in a table where the database is structured in a fixed format. Which of the following data models will he use to accomplish the task?

 

  1. Object relational data model

  2. Entity-Relationship Model

  3. Network data model

  4. Relational model

 

Correct Answer: D

 

 

QUESTION 6

You manage a database named Customers, which includes a table named Orders. The Orders table is frequently queried, but only orders with a sales total of more than $1000.00 are required in the query. You want to create an index to speed up these types of queries at the same time, ensuring the index is as small as possible. What type of index should you use?

 

    1. Non-clustered

    2. Filtered

    3. Clustered

    4. XML

Correct Answer: B

 

 

QUESTION 7

Which of the following database terms is described in the statement below? “It prevents the current database operation from reading or writing a data item while the data item is being accessed by another operation.”

 

  1. Lock

  2. Encryption

  3. Constraint

  4. Deadlock

 

Correct Answer: A

 

 

QUESTION 8

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?

 

  1. Authentication

  2. Encryption

  3. Native auditing

  4. Integrity controls

 

Correct Answer: B

 

 

QUESTION 9

Which of the following are the main approaches in the database design? Each correct answer represents a complete solution. Choose three.

 

  1. Top-down approach

  2. Bottom-up approach

  3. Middle approach

  4. Inside-out approach

 

Correct Answer: ABD

 

QUESTION 10

You work as a Software Developer for ArchiTech Inc. You plan to create a well-designed database for the company. You implement normalization rules for designing the database. Choose the appropriate normalization rules from the Choose and Reorder window pane.

 

Select and Place:

98-364-demo-2

 

Correct Answer:

98-364-demo-3

 

Instant Access to Download Latest Complete Collection of Microsoft MTA 98-364 Real Exam

Try Microsoft MTA 98-364 Free Demo