Microsoft 70-465 - Designing Database Solutions for Microsoft SQL Server Exam
Page: 3 / 23
Total 111 questions
Question #11 (Topic: Topic 2)
You need to recommend a solution that addresses the security requirement.
What should you recommend?
What should you recommend?
A. Revoke user permissions on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures.
B. Grant the users the SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views.
C. Deny the users SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views.
D. Deny the users the SELECT permission on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures.
Answer: C
Question #12 (Topic: Topic 2)
You need to recommend changes to the ERP application to resolve the search issue. The
solution must minimize the impact on other queries generated from the ERP application.
What should you recommend changing?
solution must minimize the impact on other queries generated from the ERP application.
What should you recommend changing?
A. The collation of the Products table
B. The index on the ProductName column
C. The collation of the ProductName column
D. The data type of the ProductName column
Answer: C
Question #13 (Topic: Topic 2)
You need to recommend a solution that reduces the time it takes to import the supplier
data.
What should you include in the recommendation?
data.
What should you include in the recommendation?
A. Enable instant file initialization.
B. Reorganize the indexes.
C. Disable Resource Governor.
D. Enable Auto Update Statistics.
Answer: C
Question #14 (Topic: Topic 2)
You need to recommend a solution that addresses the file storage requirements.
What should you include in the recommendation?
What should you include in the recommendation?
A. FileStream
B. FileTable
C. The varbinary data type
D. The image data type
Answer: B
Question #15 (Topic: Topic 2)
You need to recommend a solution that resolves the missing data issue. The solution must
minimize the amount of development effort.
What should you recommend?
minimize the amount of development effort.
What should you recommend?
A. Denormalize the Products table.
B. Denormalize the OrderDetails table.
C. Normalize the OrderDetails table.
D. Normalize the Products table.
Answer: D
