070-462 무료 덤프문제 온라인 액세스

Which of the following is NOT a hardware requirement for SQL Server 2012?

• A.1GHZ CPU speed
• B.1GB of memory
• C.6GB of hard drive space
• D.a graphics card with 2GB video memory

You plan to install a Microsoft SQL Server 2012 instance.
The instance will support a database that has the following requirements:
* Store Excel workbooks on the file system.
* Access the workbooks through Transact-SQL.
* Include the workbooks in database backups.
During installation, you need to ensure that the requirements will be met.
Which feature should you use?

• A.OpenXML
• B.SQL Server Integration Services (SSIS)
• C.Excel Services
• D.FILESTREAM

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).
The financial database has the following characteristics:
* A data file of 2 terabytes is located on a dedicated LUN (drive D).
* A transaction log of 10 GB is located on a dedicated LUN (drive E).
* Drive D has 1 terabyte of free disk space.
* Drive E has 5 GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between
09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and
15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.
You need to ensure that your backup will continue if any invalid checksum is encountered.
Which backup option should you use?

• A.BULK_LOGGED
• B.CONTINUE_AFTER_ERROR
• C.STANDBY
• D.SKIP
• E.NORECOVERY
• F.Differential
• G.CHECKSUM
• H.RESTART
• I.SIMPLE
• J.FULL
• K.DBO_ONLY
• L.COPY_ONLY
• M.Transaction log
• N.NO_CHECKSUM

You have a server named SPS1 that has Microsoft SharePoint Server 2013 installed.
You have several Power View reports that are created in Microsoft Excel 2016.
You need to configure SPS1 to display the Power View reports.
Which two SQL Server components should you install on SPS1? Each correct answer presents part of the solution.

• A.the PowerPivot for SharePoint 2013 add-in
• B.SQL Server Analysis Services (SSAS) in Tabular Mode
• C.SQL Server Analysis Services (SSAS) in SharePoint mode
• D.SQL Server Analysis Services (SSAS) in Multidimensional and Data Mining Mode
• E.SQL Server Reporting Services (SSRS) in SharePoint mode

You create a view based on the following statement:

You grant the Select permission to User1 for this view. You need to change the view so that it displays only the records that were processed in the month prior to the current month. You need to ensure that after the changes, the view functions correctly for User1. Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)

정답:

Explanation

http://msdn.microsoft.com/en-us/library/hh213020.aspx
http://msdn.microsoft.com/en-us/library/ms186819.aspx
http://msdn.microsoft.com/en-us/library/ms173846.aspx