{"id":76951,"date":"2023-12-26T11:17:34","date_gmt":"2023-12-26T05:47:34","guid":{"rendered":"https:\/\/cloudfoundation.com\/blog\/?p=76951"},"modified":"2024-03-18T15:38:58","modified_gmt":"2024-03-18T10:08:58","slug":"ms-bi-interview-questions","status":"publish","type":"post","link":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/","title":{"rendered":"MS BI  Interview Questions"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243;][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;rgba(0,0,0,0.8)&#8221; title_font_size=&#8221;47&#8243; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; header_font=&#8221;Georgia||||||||&#8221; header_font_size=&#8221;22px&#8221; header_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p>MS BI technology interview questions provides you guidance that helps answer them successfully to demonstrate your understanding of MS BI technologies and practices.<\/p>\n<p>Microsoft Business Intelligence is an invaluable tool that enables organizations to make data-driven decisions by providing insights and visualizations from their data.<\/p>\n<p>MS BI comprises numerous components including SQL Server Reporting Services, Analysis Services and the Data Warehouse.<\/p>\n<p>Let&#8217;s dive in! In our inaugural post, we&#8217;ll introduce some key components and features of MS BI technology &#8211; as well as their roles within MS BI landscape &#8211; with their functions described.<\/p>\n<p>Stay tuned for future interviews focused on MS BI tech!<\/p>\n<p><img decoding=\"async\" class=\"size-medium aligncenter\" src=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/12\/Ms-Bi.jpg\" alt=\"\" width=\"800\" height=\"800\" \/><\/p>\n<p><strong>1.What does BI stand for?<\/strong><\/p>\n<p>Business Intelligence<\/p>\n<p><strong>2.<\/strong><strong>Mention some other BI tools in the market besides Microsoft Business Intelligence (MSBI)?<\/strong><\/p>\n<p>ABI N Issue, Informatica, Spotfire, Tableau<\/p>\n<p><strong>\u00a03.<\/strong><strong>How do BI tools add value to businesses?<\/strong><\/p>\n<p>By providing efficient solutions for business intelligence and data mining, they enable businesses to make better decisions.<\/p>\n<p><strong>4.<\/strong><strong>Can you explain the scenario where A B C, a pharmaceutical company, uses different systems to track sales at its retail outlets?<\/strong><\/p>\n<p>A B C&#8217;s retail outlet one uses an Excel sheet to track daily sales, while A B C&#8217;s retail outlet two uses a full-fledged SQL server solution setup.<\/p>\n<p><strong>5.<\/strong><strong>What is the objective of ABC in this scenario?<\/strong><\/p>\n<p>To understand how well it is doing in terms of sales and customer buying behavior.<\/p>\n<p><strong>6.<\/strong><strong>How does ABC plan to achieve this objective?<\/strong><\/p>\n<p>By collecting data from all its retail outlets and consolidating it into one common format.<\/p>\n<p><strong>7.<\/strong><strong>Tell about some possible data sources that ABC&#8217;s retail outlets use to track sales?<\/strong><\/p>\n<p>Excel sheets, SQL servers, Oracle databases, flat file formats, DBS2 databases<\/p>\n<p><strong>8.<\/strong><strong>Why is it important for ABC to perform meaningful analytics on this consolidated data?<\/strong><\/p>\n<p>To gain a comprehensive understanding of its sales performance.<\/p>\n<p><strong>9.<\/strong><strong>What is the goal of consolidating and consolidating data from various retail outlets?<\/strong><\/p>\n<p>To simplify holistic analytics by converting all disparate data sources into one common destination format.<\/p>\n<p><strong>10.<\/strong><strong>List out the benefits of this approach?<\/strong><\/p>\n<p>It does not require people with different skill sets or technologies to perform analytics.<\/p>\n<p>However, maintaining different systems that are not visible is a cost from the company&#8217;s point of view.<\/p>\n<p><strong>11.Define Management Studio?<\/strong><\/p>\n<p>A Management Studio is a database management system that allows users to create and manage databases.<\/p>\n<p>It uses a script to display data as a table, which is stored as a file on the hard disk.<\/p>\n<p><strong>12.<\/strong><strong>Give the definition of backup and restore?<\/strong><\/p>\n<p>A Backup and restore are part of a Disaster Recovery Measure (DRM) that involves saving data files and copying them back on a different machine.<\/p>\n<p>This allows users to move their databases from one server to another, implementing out-of-reach measures.<\/p>\n<p><strong>13.<\/strong><strong>How do I back up a database in Management Studio?<\/strong><\/p>\n<p>A To back up a database in Management Studio, you can right-click on it and go to tasks. You can generate a dot B file, which stores the destination as a dot B file.<\/p>\n<p><strong>14.<\/strong><strong>What are the steps to restore a database in Management Studio?<\/strong><\/p>\n<p>To restore a database in Management Studio, you can search for the file, click on the device, and click on the ellipse sign.<\/p>\n<p>You can choose the backup file you want to restore and navigate through the options.<\/p>\n<p><strong>15.<\/strong><strong>Define SQL Server data warehouse?<\/strong><\/p>\n<p>SQL Server data warehouse is a database that stores aggregated data and is used for reporting and analytics.<\/p>\n<p><strong>16.<\/strong><strong>What is SQL Server Analysis Services?<\/strong><\/p>\n<p>SQL Server Analysis Services is a component of SQL Server that helps build a cube, which is a data structure used for data warehousing and analytics.<\/p>\n<p><strong>17.<\/strong><strong>Elaborate is SSA?<\/strong><\/p>\n<p>SSA (Selective Suppression Analysis) is an optional component that allows for faster generation of aggregated data by storing aggregates in a queue.<\/p>\n<p><strong>18.<\/strong><strong>What is MSBI ETL and reporting solution?<\/strong><\/p>\n<p>MSBI ETL (Extract, Transform, Load) and reporting solution is a software suite used for data integration and reporting.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#0095f2&#8243; background_color_gradient_end=&#8221;#7dbed8&#8243; background_color_gradient_direction=&#8221;92deg&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;73%|62%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/interview-questions\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/SS_436-_Converted_-1.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_scale=&#8221;114%|112%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;25px|-4px&#8221; transform_translate_linked=&#8221;off&#8221; width=&#8221;98.1%&#8221; custom_margin=&#8221;|7px|||false|false&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;21px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/datorama-training\/&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>MS BI <\/strong>Training<\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/blog\/interview-questions\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Explore Course Content&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#0C71C3&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; header_font=&#8221;Georgia||||||||&#8221; header_font_size=&#8221;22px&#8221; header_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]<\/p>\n<p><strong>19.Define a data warehouse?<\/strong><\/p>\n<p>A data warehouse is a database that stores aggregated data and is used for reporting and analytics.<\/p>\n<p><strong>20.<\/strong><strong>Is all data warehouses an SQL Server data warehouse?<\/strong><\/p>\n<p>No, all data warehouses are not SQL Server data warehouses. However, all SQL Server data warehouses are databases.<\/p>\n<p><strong>21.<\/strong><strong>Point out the difference between SSA and a queue solution?<\/strong><\/p>\n<p>SSA is an optional component, and reports can be generated using the database as well.<\/p>\n<p>The queue is the optional component from a performance standpoint, and for better performance, a queue solution is typically implemented on top of the MSBI ETL and reporting solution.<\/p>\n<p><strong>22.<\/strong><strong>What is the purpose of MSBI ETL and reporting solution?<\/strong><\/p>\n<p>The purpose of MSBI ETL (Extract, Transform, Load) and reporting solution is to integrate data from multiple sources, transform it into a format suitable for analysis, and load it into a data warehouse.<\/p>\n<p>It is used for data integration and reporting.<\/p>\n<p><strong>23.<\/strong><strong>Give a details explanationof normalization in online transactional processing (OLTP) systems?<\/strong><\/p>\n<p>Normalization is a process of breaking down a large table into smaller tables to enable faster inserts, updates, and deletes in an OLTP system.<\/p>\n<p><strong>24.<\/strong><strong>Why is normalization important for operational systems?<\/strong><\/p>\n<p>Normalization is important for operational systems because it enables faster inserts, updates, and deletes, which is essential for a robust transactional processing system.<\/p>\n<p><strong>25.<\/strong><strong>How does normalization increase the number of joins involved in a query?<\/strong><\/p>\n<p>Normalization increases the number of joins involved in a query because it breaks down a large table into smaller tables, resulting in more tables that need to be joined.<\/p>\n<p><strong>26.<\/strong><strong>What is the impact of normalization on select statements?<\/strong><\/p>\n<p>Normalization reduces the speed of select statements because it increases the number of joins involved in the query, which can take more time to execute.<\/p>\n<p><strong>27.<\/strong><strong>Mention the main focus of a data warehouse?<\/strong><\/p>\n<p>The main focus of a data warehouse is on analytics rather than supporting an operational OLTP system.<\/p>\n<p><strong>\u00a028.<\/strong><strong>Why is a data warehouse denormalized?<\/strong><\/p>\n<p>A data warehouse is denormalized to allow for faster inserts, updates, and deletes, which is essential for analytics.<\/p>\n<p><strong>\u00a029.<\/strong><strong>Why is a data warehouse recommended for reporting purposes?<\/strong><\/p>\n<p>A data warehouse is recommended for reporting purposes because it is designed to handle complex select statements and maintain a denormalized structure, allowing for faster inserts, updates, and deletes.<\/p>\n<p><strong>\u00a030.<\/strong><strong>What is a data warehouse?<\/strong><\/p>\n<p>A data warehouse is a system designed to store historical data, spanning decades and allowing for trend analysis and analytics.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#ff8c7c&#8221; background_color_gradient_end=&#8221;#e5ba4e&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top left&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;74%|69%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;||-5px||false|false&#8221; custom_padding=&#8221;|||2px|false|false&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/interview-questions\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/8423118_3895895.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; width=&#8221;85.4%&#8221; custom_margin=&#8221;-31px||-24px||false|false&#8221; custom_padding=&#8221;|22px|0px||false|false&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;19px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;1.2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/datorama-training\/&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #000000;\"><strong>MS BI <\/strong>Online Training<\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/blog\/interview-questions\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Up Coming Batches&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#E09900&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221; background_layout=&#8221;dark&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; header_font=&#8221;Georgia||||||||&#8221; header_font_size=&#8221;22px&#8221; header_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221;]<\/p>\n<p><strong>31.What does a data warehouse not do?<\/strong><\/p>\n<p>A data warehouse does not insert, update or delete data, but inserts do occur due to new data being added.<\/p>\n<p><strong>32.Why is inserting data slower in a data warehouse compared to an operation system?<\/strong><\/p>\n<p>Inserting data in a data warehouse is slower than in an operation system because inserts happen all the time in the latter.<\/p>\n<p><strong>33.<\/strong><strong>What should the report generated by a data warehouse be like?<\/strong><\/p>\n<p>The report should be fast, denormalized, and have data across the past day and years.<\/p>\n<p><strong>\u00a034.<\/strong><strong>Why is a denormalized database ideal for reporting?<\/strong><\/p>\n<p>A denormalized database is ideal for reporting because it requires lesser joins and ports run quickly, making select statements run fast.<\/p>\n<p><strong>35.<\/strong><strong>What are the factors that must be identified when building a data warehouse?<\/strong><\/p>\n<p>When building a data warehouse, companies must first model the data warehouse by identifying packs, dimensions, and relationships between them.<\/p>\n<p><img decoding=\"async\" class=\"size-medium aligncenter\" src=\"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/12\/Msbi-interview-questions-1.jpg\" alt=\"\" width=\"800\" height=\"800\" \/><\/p>\n<p><strong>36.<\/strong><strong>Define ETL process?<\/strong><\/p>\n<p>ETL involves extracting data from the source, performing transformation on it, and loading the data onto a data warehouse or database.<\/p>\n<p><strong>37.<\/strong><strong>List out the difference between classical and non-classical ETL?<\/strong><\/p>\n<p>In classical ETL, the process involves extracting data from the source, transforming it, and loading the data onto a destination.<\/p>\n<p>In non-classical ETL, the process involves extracting data from the source, performing transformation on it, and loading the data onto a data warehouse or database.<\/p>\n<p><strong>\u00a038.<\/strong><strong>How does historical data in a data warehouse differ from data in a data warehouse?<\/strong><\/p>\n<p>Historical data in a data warehouse is like an old mine-up data, which means it is stored for a long time and can be used for trend analysis and analytics.<\/p>\n<p>Now its time to give a quick revision with <strong>MCQ&#8217;s<\/strong><\/p>\n<p><strong>1.What is the goal of consolidating and consolidating data from various retail outlets?<\/strong><\/p>\n<p><strong><span style=\"color: #800080;\">To simplify holistic analytics by converting all disparate data sources into one common destination format.<\/span><\/strong><\/p>\n<p>Used for detailed analytics on different data sources without maintaining different systems.<\/p>\n<p>To perform detailed analytics on different data sources without converting them into a single destination format.<\/p>\n<p>Used to perform detailed analytics on different data sources without any consideration for data consolidation.<\/p>\n<p><strong>2.<\/strong><strong>What is the process of ETL (Enter-To-Load)?<\/strong><\/p>\n<p><strong><span style=\"color: #800080;\">Extracting data from the source, performing transformations on the data, and loading the data into a common destination, such as a SQL server.<\/span><\/strong><\/p>\n<p>Extracting data from a SQL server, performing transformations on the data, and loading the data into a different SQL server.<\/p>\n<p>Extracting data from different sources, performing transformations, and loading the data into a single SQL server.<\/p>\n<p>Extracting data from a single SQL server, performing transformations, and loading the data into different SQL servers.<\/p>\n<p><strong>3.What is the goal of SSRS (SQL Server Reporting Services)?<\/strong><\/p>\n<p>To perform detailed analytics on different data sources without consolidating them into a single destination format.<\/p>\n<p><strong><span style=\"color: #800080;\">To simplify analytics by providing information for various queries, such as sales trends over the past year across different regions, gender categories, product categories, and brackets.<\/span><\/strong><\/p>\n<p>To perform detailed analytics on different data sources without consolidating them into a common destination format.<\/p>\n<p>To perform detailed analytics on different data sources without any consideration for data consolidation or visualization.<\/p>\n<p><strong>4.<\/strong><strong>What is the process of SSA (Selective Suppression Analysis)?<\/strong><\/p>\n<p>Extracting data from a SQL server, performing transformations on the data, and loading the data into a different SQL server.<\/p>\n<p>Extracting data from different sources, performing transformations, and loading the data into a SQL server.<\/p>\n<p><span style=\"color: #800080;\"><strong>Extracting data from a SQL server, performing transformations, and loading the data into a common destination format.<\/strong><\/span><\/p>\n<p>Extracting data from different sources, performing transformations, and loading the data into a common destination format<\/p>\n<p><strong>5.<\/strong><strong>What is a data warehouse?<\/strong><\/p>\n<p><strong><span style=\"color: #800080;\">A system designed to handle complex select statements and maintain a denormalized structure, allowing for faster inserts, updates, and deletes.<\/span><\/strong><\/p>\n<p>specific thing in S Q L Server and all data warehouses are databases.<\/p>\n<p>its\u00a0 part of a database.<\/p>\n<p>All databases are not data warehouses.<\/p>\n<p><strong>6.<\/strong><strong>What is the purpose of a data warehouse?<\/strong><\/p>\n<p>Insert data, update or delete data, but inserts do occur due to new data being added.<span style=\"color: #800080;\"><strong>\u00a0<\/strong><\/span><\/p>\n<p><span style=\"color: #800080;\"><strong>provide a management meeting with a report that can tell the story of an organization over the past decade.<\/strong><\/span><\/p>\n<p>Handle complex analytical queries and maintain a normalized structure.<\/p>\n<p>Support an operational OLTP system.<\/p>\n<p><strong>7.What is the ETL process?<\/strong><\/p>\n<p>Extracting data from an OLTP system for reporting needs.<\/p>\n<p><span style=\"color: #800080;\"><strong>Extracting data from the source, performing transformation on it, and loading the data onto a data warehouse or database.<\/strong><\/span><\/p>\n<p>Inserting data, updating or deleting data, but inserts do occur due to new data being added.<\/p>\n<p>Normalizing a large table into smaller, smaller tables.<\/p>\n<p><strong>8.What is normalization in databases?<\/strong><\/p>\n<p><span style=\"color: #800080;\"><strong>The process of breaking down a large table into smaller, smaller chunks, resulting in faster inserts, updates, and deletes.<\/strong><\/span><\/p>\n<p>Its a process of increasing the number of joins involved in the query, which can take more time to execute.<\/p>\n<p>A process of enabling faster selects.<\/p>\n<p>The process of ensuring that databases are designed to support data operations.<\/p>\n<p>Conclusion:<\/p>\n<p>Microsoft Business Intelligence technology offers businesses many benefits when analyzing, visualizing, and sharing data and insights.<\/p>\n<p>Although implementing MS BI may present certain obstacles for organizations, these hurdles can be overcome through clear business goals definition, creating a data governance strategy implementation process with comprehensive training provision as well as cultivating data-driven decision making by creating a culture around data-driven decision-making as well as continuously optimizing MS BI technologies utilizing this approach to data driven insight gathering and use.<\/p>\n<p>Hope \u00a0this Mi bi interview questions and answers gave you great revision.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#064399&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#494fff&#8221; background_color_gradient_end=&#8221;#9ea6ff&#8221; background_color_gradient_type=&#8221;radial&#8221; background_color_gradient_direction_radial=&#8221;top left&#8221; background_color_gradient_start_position=&#8221;35%&#8221; background_color_gradient_end_position=&#8221;80%&#8221; transform_scale=&#8221;74%|71%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;-53px|-50px&#8221; transform_translate_linked=&#8221;off&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/blog\/interview-questions\/&#8221; link_option_url_new_window=&#8221;on&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/06\/Untitled-11.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_scale=&#8221;103%|103%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;11px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_padding=&#8221;|88px||||&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Georgia|700|||||||&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;23px&#8221; text_line_height=&#8221;1.3em&#8221; header_font=&#8221;Georgia|700|||||||&#8221; header_font_size=&#8221;19px&#8221; header_letter_spacing=&#8221;-1px&#8221; header_line_height=&#8221;1.2em&#8221; transform_scale=&#8221;171%|159%&#8221; transform_scale_linked=&#8221;off&#8221; transform_translate=&#8221;40px|44px&#8221; transform_translate_linked=&#8221;off&#8221; transform_origin=&#8221;70%|50%&#8221; z_index=&#8221;-161&#8243; width=&#8221;100%&#8221; custom_margin=&#8221;|-215px||||&#8221; custom_padding=&#8221;|0px||||&#8221; link_option_url=&#8221;https:\/\/cloudfoundation.com\/datorama-training\/&#8221;]<\/p>\n<h1 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>MS BI Course Price<\/strong><\/span><\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/cloudfoundation.com\/blog\/interview-questions\/&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Offer Price&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#0C71C3&#8243; button_bg_color=&#8221;#FFFFFF&#8221; button_font=&#8221;|700|||||||&#8221; transform_translate=&#8221;64px|65px&#8221; transform_translate_linked=&#8221;off&#8221;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221;][et_pb_image src=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2019\/06\/logo_resize_color.png&#8221; _builder_version=&#8221;4.9.7&#8243; _module_preset=&#8221;default&#8221; transform_translate=&#8221;-36px|0px&#8221; transform_translate_linked=&#8221;off&#8221; custom_margin=&#8221;|||178px||&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_team_member name=&#8221;Harsha Vardhani&#8221; position=&#8221;Author&#8221; image_url=&#8221;https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/07\/Harsha.png&#8221; _builder_version=&#8221;4.9.7&#8243; header_font=&#8221;Titillium Web|700|||||||&#8221; body_font=&#8221;Titillium Web||||||||&#8221; body_font_size=&#8221;16&#8243;]\u201d There is always something to learn, we\u2019ll learn together!\u201d[\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243;][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;rgba(0,0,0,0.8)&#8221; title_font_size=&#8221;47&#8243; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; header_font=&#8221;Georgia||||||||&#8221; header_font_size=&#8221;22px&#8221; header_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] MS BI technology interview questions [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":76964,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[84],"tags":[],"class_list":{"0":"post-76951","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-interview-questions"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MS BI Interview Questions<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS BI Interview Questions\" \/>\n<meta property=\"og:description\" content=\"[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243;][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;rgba(0,0,0,0.8)&#8221; title_font_size=&#8221;47&#8243; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; header_font=&#8221;Georgia||||||||&#8221; header_font_size=&#8221;22px&#8221; header_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] MS BI technology interview questions [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudFoundation | Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-26T05:47:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-18T10:08:58+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/12\/business-people-working-laptop-meeting-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"371\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"NAGENDRAG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"NAGENDRAG\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MS BI Interview Questions","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/","og_locale":"en_US","og_type":"article","og_title":"MS BI Interview Questions","og_description":"[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;3.22&#8243;][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.9.7&#8243; title_font=&#8221;Times New Roman||||||||&#8221; title_text_align=&#8221;left&#8221; title_text_color=&#8221;rgba(0,0,0,0.8)&#8221; title_font_size=&#8221;47&#8243; custom_margin=&#8221;|||10%&#8221; title_font_size_tablet=&#8221;40&#8243; title_font_size_phone=&#8221;35&#8243; title_font_size_last_edited=&#8221;on|desktop&#8221;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;3.25&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.9.7&#8243; text_font=&#8221;Georgia|300|||||||&#8221; text_text_color=&#8221;rgba(0,0,0,0.8)&#8221; text_font_size=&#8221;22px&#8221; text_line_height=&#8221;1.9em&#8221; header_font=&#8221;Georgia||||||||&#8221; header_font_size=&#8221;22px&#8221; header_line_height=&#8221;1.9em&#8221; max_width=&#8221;800px&#8221; max_width_last_edited=&#8221;off|phone&#8221; custom_margin=&#8221;|||10%&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; hover_enabled=&#8221;0&#8243; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; text_line_height_last_edited=&#8221;off|phone&#8221; sticky_enabled=&#8221;0&#8243;] MS BI technology interview questions [&hellip;]","og_url":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/","og_site_name":"CloudFoundation | Blog","article_published_time":"2023-12-26T05:47:34+00:00","article_modified_time":"2024-03-18T10:08:58+00:00","og_image":[{"width":600,"height":371,"url":"http:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/12\/business-people-working-laptop-meeting-1.jpg","type":"image\/jpeg"}],"author":"NAGENDRAG","twitter_card":"summary_large_image","twitter_misc":{"Written by":"NAGENDRAG","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/","url":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/","name":"MS BI Interview Questions","isPartOf":{"@id":"https:\/\/cloudfoundation.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/#primaryimage"},"image":{"@id":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/12\/business-people-working-laptop-meeting-1.jpg","datePublished":"2023-12-26T05:47:34+00:00","dateModified":"2024-03-18T10:08:58+00:00","author":{"@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/df6c7eba98f1bb15f2a100a9958266e4"},"breadcrumb":{"@id":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/#primaryimage","url":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/12\/business-people-working-laptop-meeting-1.jpg","contentUrl":"https:\/\/cloudfoundation.com\/blog\/wp-content\/uploads\/2023\/12\/business-people-working-laptop-meeting-1.jpg","width":600,"height":371},{"@type":"BreadcrumbList","@id":"https:\/\/cloudfoundation.com\/blog\/ms-bi-interview-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudfoundation.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MS BI Interview Questions"}]},{"@type":"WebSite","@id":"https:\/\/cloudfoundation.com\/blog\/#website","url":"https:\/\/cloudfoundation.com\/blog\/","name":"CloudFoundation | Blog","description":"A New way of Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudfoundation.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/df6c7eba98f1bb15f2a100a9958266e4","name":"NAGENDRAG","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudfoundation.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09e08ba1102807a876f2c00245d6b955f0a9f027b40c181e9cee0cd2d927f84a?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09e08ba1102807a876f2c00245d6b955f0a9f027b40c181e9cee0cd2d927f84a?s=96&d=wavatar&r=g","caption":"NAGENDRAG"},"url":"https:\/\/cloudfoundation.com\/blog\/author\/nagendrag\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/76951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/comments?post=76951"}],"version-history":[{"count":13,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/76951\/revisions"}],"predecessor-version":[{"id":77073,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/posts\/76951\/revisions\/77073"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/media\/76964"}],"wp:attachment":[{"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/media?parent=76951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/categories?post=76951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudfoundation.com\/blog\/wp-json\/wp\/v2\/tags?post=76951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}