You need to improve the performance of the view by persisting data to disk
You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and
OrderDetails tables by using the following definition.
You need to improve the performance of the view by persisting data to disk. What should you do?
You need to design the database to ensure normalization
You are a database developer. You plan to create a database by using SQL Server 2008.
The database will store information about students, teachers, classes, and rooms in a
school. The database will be used by a scheduling application. In the design plan, the
following facts have to be considered: ·Each teacher can teach one or more classes. ·Each
student can register for one or more classes. ·Each class can be in one or more rooms.
·Each room can host one or more classes. You identify the following entities for the
database design: ·Students ·Teachers ·Classes ·Rooms ·ClassesStudents
·ClassesTeachers You need to design the database to ensure normalization. What should
you do?
You need to ensure that the table meets the following requirements…?
You have a table in a database that contains 30 million rows. You need to ensure that the
table meets the following requirements: ·Enables queries on all string values within the table
·Enables queries to be returned by order of proximity ·Minimizes the amount of time
required to execute queries What should you do?
Which SQL Server component should you use?
You need to design a database solution that meets the following capabilities: ·Executes
SQL Server Integration Services (SSIS) packages ·Executes Transact-SQL ·Schedules
tasks ·Sends alerts
Which SQL Server component should you use?
Which configuration option should you use?
You administer a SQL Server 2008 instance. The instance is located on a four-processor,
quad-core server. The server frequently experiences CPU pressure. The instance contains
a very large missioncritical database that is used continuously. You need to ensure that
online index rebuilds do not consume all available CPU cycles. Which configuration option
should you use?
You need to ensure that aggregations are populated
You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to process a cube by using an XML for Analysis (XMLA) script.
You need to ensure that aggregations are populated.
What should you do?
You need to enable query logging
You maintain a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to run the Usage-Based Optimization Wizard. You need to enable query logging.
What should you do?
You need to ensure that the users of the application can successfully access the SSAS database
You maintain a SQL Server Analysis Services (SSAS) database. The database is configured
by using multiple security roles.
The database is accessed by a Microsoft ASP.NET application that runs on a remote
computer.
The application is configured to use Windows Authentication.
You need to ensure that the users of the application can successfully access the SSAS
database.
You also need to ensure that security restrictions of the roles are applied.
What should you do?
You need to implement the business requirements to maintain data integrity
You are a database developer. You plan to design a database solution by using SQL Server
2008. You are creating a database to support the office manager. Your database model has
the following structure. The database design has the following business requirements: ·An
employee can be assigned more than one task. ·Upon completion, the task is deleted.
·When a task is deleted, the associated assignment is deleted. ·When an employee is no
longer available to complete a task, the employee link to the assignment is replaced with a
NULL value. You need to implement the business requirements to maintain data integrity.
What should you do?
You need to optimize the performance of the instance
You administer a SQL Server 2008 infrastructure. An instance runs on a computer that has
eight quad-core processors and 128-GB RAM. Four different applications use the instance.
The instance experiences a low number of CXPACKET waits. The instance also
experiences a large number of lazy writer waits. You need to optimize the performance of
the instance. What should you do?