You need to ensure that the table is designed appropriately
You are a database developer. You plan to design a database solution by using SQL Server
2008. You create a table that contains information about Web pages that are added to a
Web site. The Web site has a home page and contains various other Web pages. The home
page is the root page of the site. All pages except the root page have a link to an
upper-level page. The table must support the following design considerations: ·Records of
the Web pages that are linked to a particular page can be quickly retrieved. ·The position of
a Web page in a collection of linked pages can be quickly retrieved. ·Changing the links to
the upper-level pages is a rare requirement. You need to ensure that the table is designed
appropriately. What should you use?
You need to limit data that is displayed in the table while ensuring that the matrix is unaffected
You create a SQL Server 2008 Reporting Services (SSRS) report that contains a dataset.
The dataset retrieves data by executing a stored procedure. The report contains a table and
a matrix that use the dataset.
You need to limit data that is displayed in the table while ensuring that the matrix is
unaffected.
What should you do?
You need to ensure that the data is available as quickly as possible with minimal effect on users
You administer a SQL Server 2008 instance that hosts a large database. The following
backup strategy is used for the database: A full database backup is performed at 02:00 hr
every Monday. A differential backup is performed at 23:00 hr every day. A transaction
log backup is performed on an hourly basis. A power failure on Thursday causes the SQL
Server 2008 server to restart at 09:15 hr. Fifteen minutes after the server restarts, the users
report that they are unable to execute certain queries that access customer data. You
discover that the customer data is unmodified after the power failure. When you execute the
DBCC CHECKDB command on the database, you receive the following error message:
Object ID 2814307832, index ID 2, partition ID 83127819437122157, alloc unit ID
82134587923221126 (type In-row data): Page (3421:169) could not be processed. See
other errors for details. Table error: Object ID 2814307832, index ID 2, partition ID
83127819437122157, alloc unit ID 82134587923221126 (type In-row data), page
(3421:169). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 16928422 and
-8. CHECKDB found 0 allocation errors and 2 consistency errors in table ‘tbl_Customer’
(object ID 2814307832). When you execute the sp_help ‘tbl_customer’ stored procedure
you receive the following result set: index_name index_description ————-
———————————- PK clustered located on PRIMARY NCIX nonclustered located on
PRIMARY You need to ensure that the data is available as quickly as possible with minimal
effect on users. What should you do?
You need to configure the report to prevent users from modifying the value of the @SalesTaxRateID parameter
You develop a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a parameter named @SalesTax8ateID.
You set the value of the @SafesTaxRateID parameter in the report by selecting a specific
region.
You need to configure the report to prevent users from modifying the value of the
@SalesTaxRateID parameter.
What should you do?
You need to ensure that the report displays member properties and extended properties
You develop a SQL Server 2008 Reporting Services (SSRS) project.
The report will display data from a SQL Server 2005 Analysis Services database.
You need to ensure that the report displays member properties and extended properties.
What should you do?
Which Transact-SQL statement should you use?
You use a Microsoft SQL Server 2012 database.
You want to create a table to store Microsoft Word documents.
You need to ensure that the documents must only be accessible via Transact-SQL queries.
Which Transact-SQL statement should you use?
Which SSRS technology should you use?
You are developing a sales report by using SQL Server 2008 Reporting Services (SSRS).
The report contains a table.
You need to implement a technology that allows users to open a new report when they click
on a field in a table.
Which SSRS technology should you use?
Which step should you choose?
You administer a SQL Server 2008 database solution that is log-shipped for high-availability
purposes. The data files of the database are located on drive D. The transaction log files of
the database are located on drive E. You are designing a recovery test plan to meet the
following requirements for the log-shipping solution: The secondary database is brought
online as quickly as possible. The data loss is minimal. The data is in a consistent state.
You need to identify the first step for the recovery test plan when drive D fails. Which step
should you choose?
You need to modify the report to prevent the rendering of blank pages
You create a SQL Server 2008 Reporting Services (SSRS) report. The report contains a
report header and a report footer.
The report preview shows that the report is rendered correctly. You discover that when the
report is rendered as a PDF file, even-numbered pages are rendered blank.
You need to modify the report to prevent the rendering of blank pages.
What should you do?
Which data type should you use?
You are designing a database table for a content management system. Users will store
images and videos in the database. You need to ensure that the database can store files
that are 20 MB or less. The solution must minimize the amount of space required to store
the data. Which data type should you use?